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,