Solved

IIS/Apache and MS SQL 2005/MySQL on same server

Posted on 2006-06-13
5
779 Views
Last Modified: 2008-01-09
Is it possible to run IISv5, Apache, MS SQL 2005 and MySQL on the same Windows 2000 Server? I have one website that is currently running off my Windows 2000 server that is written in PHP. I have installed Apache2.0.xx and MySQL and everything is running great. Now I have a requirement to install a .NET webapp and it requires IIS and SQL 2005. Is this possible and most importantly if so, how do I do it?

Thanks
0
Comment
Question by:Trihimbulus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 1

Accepted Solution

by:
TheShaner earned 168 total points
ID: 16893689
The best way to do this is run 2 concurrent IP addresses for your webservers.  That way you can bind IIS to the first and Apache to the second.  MYSQL and SQL 2005 are pretty straight forward.  Try referring to these articles if you have issues attaching your ASP pages to MSQL or php to SQL:

www.php.net/manual/en/ref.mssql.php
www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=7739&lngWId=4

0
 
LVL 35

Assisted Solution

by:mrichmon
mrichmon earned 166 total points
ID: 16896330
Possible - yes.

A good idea - no.
0
 
LVL 16

Assisted Solution

by:OliWarner
OliWarner earned 166 total points
ID: 16896347
>> Is this possible
Of course

>> how do I do it?
Make sure aspnet is installed for IIS, enable it for your directory (be that the root dir or a virtual dir lower down).
If you want yoursite.com/your_aspnet_app:
 - make a new virtual directory called your_aspnet_app
 - map it to where the files are
 - right click it in IIS and go to properties then hit the aspnet tab
 - make sure its installed and running the right version for thsi app
 - done.

If you want aspnet enabled throughout the website so its working side-by -side with php, just install it in the root on the root dir (same as before starting from the third point) and you're done. If you want some files implicitly going to aspnet, you will need to go into the application config (through the properties screen) and map the extensions to the framework dll.

As far as I know, php and aspnet sessions and application variables will be completely separate and wont be able to inter-operate.

If you want the php and aspnet sites completely different, you will need to make a new website and either run it on a different port, a different ip, or use header checking to separate them.


As for MSSQL and MySQL... there should be no conflict at all. Install away.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question