How to keep SQL Server from killing WAMP

[Jackolantern]

I ran into this problem a week or two ago, and found that a solution was not clearly documented online. I installed SQL Server 2008 Developer Edition while I was working with C# and ASP.NET. After working with it for a while, I tried to re-open WAMP to test out some PHP pages, and I found that my Apache/WAMP icon was getting stuck on yellow as it was starting up. It would not serve any pages, and was basically useless.

1. I first tried going to the WAMP menu, and clicked on Apache >> Services >> Test Port 80. It came up saying that port 80 was in use by "MSSQLAPI", or something like that. This is because SQL Server Reporting Services is holding port 80. WAMP will not function properly while it is.

2. Go to Start Button >> All Programs >> Microsoft SQL Server 2008/2005 >> Configuration Tools >> Reporting Services Configuration Tool

3. Inside the Reporting Services Config Tool, go to the following options on the left sidebar: Web Services URL and Report Manager URL > Advanced. Change both of the port numbers you see there to an empty port. Make sure to use the same port for both options.

4. Restart all WAMP services.

5. Retest Port 80 under Apache options. It should now say that Port 80 is being used by Apache, and WAMP should be usable again.

[Falken]

Ye, skype got the same problem. If you launch skype before wamp, apache wont start.

[Jackolantern]

Ye, skype got the same problem. If you launch skype before wamp, apache wont start.

I heard a lot about Skype doing it, too. The issue with SQL Server is that once it is installed, there is nothing you can do to run WAMP again unless you do the above, short of uninstalling SQL Server. You can't disable the service through Windows (port 80 stays used), and it doesn't matter if SQL Server is running or not. It is highly irritating and I struggled with it for several hours before finally finding all the places to change the port #.

[Falken]

Ye, skype got the same problem. If you launch skype before wamp, apache wont start.

I heard a lot about Skype doing it, too. The issue with SQL Server is that once it is installed, there is nothing you can do to run WAMP again unless you do the above, short of uninstalling SQL Server. You can't disable the service through Windows (port 80 stays used), and it doesn't matter if SQL Server is running or not. It is highly irritating and I struggled with it for several hours before finally finding all the places to change the port #.

Ye many programs that use port 80. I also had the problem with a program called Intelliremote, a great software for remote controls tho