Questions to ask to set up php server


#1

Hi,
I am working with a Sql server database. My boss asked me to to create a website that create reports for end users based on this data. I need to tell my boss the requirements of the system.Now my questions are:
1- what kind of server do we need? Linux? Windows? What other specification should I consider?
2- if the database should stay on its current server, how do I connect these 2 servers?
3- Does not it matter that I am using php with ms sql server? Shouldn’t it be mysql only?
4-what if the database should remain in our internal server? Can I still connect it to a public web server?
5- what software should I ask to be installed on the server?
Thanks


#2

1- what kind of server do we need? Linux? Windows? What other specification should I consider?

Any

2- if the database should stay on its current server, how do I connect these 2 servers?

API

3- Does not it matter that I am using php with ms sql server? Shouldn’t it be mysql only?

PDO can handle the connection just fine, just need the sql server driver

4-what if the database should remain in our internal server? Can I still connect it to a public web server?

Depends on firewall rules. Though it may be better to at least have a synced database

5- what software should I ask to be installed on the server?

Not sure how specific you want this answered.


#3

I am probably the last person who should give any guidance on this, but based on a course I took last year I can tell you that a very common set up is a “LAMP stack”. Linux, Apache, MySQL, PHP


#4

Thanks. But why do I need to have MySql when I will be using SQL Server?