views:

17

answers:

0

I have a server with sql server 2005, 2008 and sql express. This is a dev machine.

When I log onto the server I can get access to all servers as expected [SERVERNAME] = 2005 [SERVERNAME]\mssql2008 = 2008

When I connect to my vpn connection both sql management 2008 and redgate software see [SERVERNAME] as my 2008 server.

When I try to use [SERVERNAME]\mssql2008 I get a remote connection error.

I thinks it's something to do with TCP/IP settings in configuration manager.

Does anyone know how to setup this up so I can access both servers.

Currently I have 2008 server with tcp setting using port 1433 but when I set the 2005 server to this I can't restart the sql server until I change the port back to 0 which is dynamic port. Also before when I had 2005 server with tcp port of 1433 that worked and 2008 wouldn't connect.

Any suggestions would be greatly appreciated.

If you need more information please let me know.

Thanks,