How do I connect to a remote instance of SQL Server 2008
Posted on 2009-02-22
I have an instance of SQL Server 2008 installed on Windows Server 2008 and am trying to set it up for remote access from computers on the same network. The steps I have tried out so far are as follows:-
- Configured the TCP protocol for both IPn (n=internal IP of the server) as well as IPAll to use a static port 1640 and have set Dynamic Ports to blank
-The protocol priority is 1-Shared Memory, 2-TCP, 3-Named Pipes
-Configured Windows Advanced Firewall to allow incoming and outgoing connections on port 1640 for any computer on all the 3 trust zones - Domain, Public and Private.
-On one of the client computers (on the same network) I have an instance of SQL Server 2008 running and on that machine's Surface area config. manager i have configured native client configuration with an alias for port 1640 with the name of the DB Server that I want to connect to via TCP.
-Allowed outgoing/incoming connections via port 1640 on my client machine via its firewall
-Configured the router to direct tcp connections via port 1640 to my DB Server
However on the client machine I still cannot see my Server's Database instance show up in the network servers list when I open SQL Server Management Studio.
Am I missing something ?