Link to home
Start Free TrialLog in
Avatar of minichicken
minichicken

asked on

Window Server 2003 - IIS and Apache, ASP and PHP, MSSQL and MySQL concurrently

Hi Experts

I would like to setup a server with Windows Server 2003 that runs IIS and Apache concurrently.
IIS will be running ASP and Apache will be running PHP.
Setup MS SQL Server and MySQL.
ASP will mostly be using MSSQL and PHP with MySQL. But ASP should also use MySQL and PHP should also be able to use MSSQL.

How would I go about doing that?

Thanks :)



SOLUTION
Avatar of humeniuk
humeniuk
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of minichicken
minichicken

ASKER

Thanks humeniuk for your input.

So to run 2 separate web servers on 1 machines is just a matter of assigning 2 different IP addresses to each of them.
Sounds easy, but how would I go about doing that? The setup is just for internal development use it is not public on the internet.

thanks :)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Xactly...  And its really easy to put on the web if you wish to do so.
thanks guys, i was just trying to setup the environment and i have some problems.

IIS is installed.
Apache, MySQL and PHP is installed and tested, works fine.

This is what I did to setup 2 IP addressed, please confirm:

>> CONTROL PANEL >> NETWORK CONNECTIONS >> LAN CONNECTIONS >> PROPERTIES >> INTERNET PROTOCOL TCP/IP  >> PROPERTIES >> manually set first IP address >> click on ADVANCED >> add another IP address.

The problem:
I can only have 1 web-server running at once, either IIS or Apache, and not both. If one of them is running already and i try to start the other one, i can't. I know where to assign IP address for IIS (I think i know) but I dont know how to assign IP address for Apache. While I have apache running i tried to assign IIS with both the IP i created and failed. Seems like it conflicting.

Also, normally to access your web server locally, you usually type in "localhost" or the name of the server in the browser address bar. it doesnt matter which server you running. If you have IIS running you still type "localhost" and will access the wwwroot folder and if you have apache running and type "localhost" you will see the htdocs folder. So if you have both of them running at the same time, how to you access each of the servers separately?

thanks.... ^_^
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you all.

I got it to work with one IP but different ports for IIS and Apache.

IIS: 192.168.0.xx:aa
Apache: 192.168.0.xx:bb

and it seems to work well, I got apache, mysql and php running as well as ASP working, but havent install MSSQL yet, but i think it should be fine.

My security concern is that is it safe to assign ports to the two different web servers or is it better to have two IP address and use port 80 for both of the IPs??

I will close the question when I get a confirmation on the security concern.

Thank you for all the help :)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks, really being of great help.....

I will gratefully reward the points now.

I've got a scenario with 2 different IPs. Normally when you browse a page on the server you will type localhost or 127.0.0.1 or the name of the server in the browser address bar, right? So having two IPs I then cant use localhost or 127.0.0.1 or the name of the server and can only type in the actuall IP address of the web servers i.e to access IIS i will type 192.168.0.aa and Apache 192.168.0.bb is that correct?

Thank you for the help, much appreciated :)
Right, you're better off using the IP address or setting up DNS - www.IISdomain.com resolves to IIS IP and www.apachedomain.com resolves to Apache IP.
Glad to be of help and thanks for the A.