Sql-server – How to run SQL Server 2005 and 2008 on the same box

sql serversql-server-2005sql-server-2008

I've got MS SQL Server 2005 (default instance) and SQL Server 2008 (named instance) running on Vista Ultimate x86.

I have no problem connecting to both instances locally, but when I try connecting to them from another NETWORK – no luck. SQL Server 2005 works fine, but I can't connect to SQL Server 2008.

I've got TCP/IP and Named Pipes enabled on SQL Server 2008, and remote connections are allowed.

Am I missing anything?

P.S.: I changed dynamic port to 1444. I don't seem to find a way to specify a port number when connecting to named instance via MS SQL Management Studio.

P.P.S: connecting from SSMS 2008.

More information:

I've also opened up TCP 1444 on the firewall and the router. I can't think of anything else.

UPDATE:

The following works:

  • connecting from the same machine using the ServerName without any ports
  • connecting from the same SUBNET using the ServerName without any ports
  • connecting from the same SUBNET using the LOCAL IP (192…) without any ports

The following DOES NOT work:

  • connecting from the same SUBNET using the OUTSIDE IP ADDRESS (not 192…) without any ports
  • connecting from the different NETWORK using the OUTSIDE IP ADDRESS (not 192…) without any ports

SOLUTION:

It turns out the problem was with the router port forwarding setup, I was forwarding my custom port to the default port … duh …

I got this sorted out by rewording the question.

Thank you all for the help.

Best Answer

Make sure that the SQL Browser is enabled and running. It's probably disabled or stopped.

Also make sure that the instance is configured to allow remote connections.