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.
I've also opened up TCP 1444 on the firewall and the router. I can't think of anything else.
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
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.