Question:
How do I connect remotely to my SQL Server 2005?
anonymous
2007-12-20 01:05:33 UTC
The SQl Server 2005 is in the office. From y home how do I connect using the sql server 2005 manager studio? No IP is asked except the server name. I don't see how this is possible?
Three answers:
anonymous
2007-12-20 09:23:38 UTC
In order to connect to a remote server, you either need to have a fully qualified domain name (FQDN) for the server (e.g., sql.domain.com) or the IP address of the server.



As previously mentioned, the remote server must not be firewalled against port 1444, or you must set up the firewall to forward incoming port 1444 requests to the appropriate remote server.



Additionally, the remote server must be configured to allow remote connections via TCP / IP. See here:



http://nil.checksite.co.uk/index.cfm/2007/4/30/SQL-Server-2005-TCPIP-Connections



Once your remote server is configured properly, in SQL Management Console, create a new connection:



Provide the FQDN / IP address to the server in the Server Name field. Do NOT provide a protocol (e.g., http); provide only the domain name or IP address, e.g., 127.0.0.1 or sql.domain.com



Under Authentication, choose the appropriate authentication method.



If you are using Windows Authentication, you must provide a domain and user Domain\Username combination ON THE REMOTE SERVER / NETWORK that has permission for the DB objects.



For example, if the remote SQL Server box is named SQL and you want to log in as the built-in Administrator account on that box, you would use SQL\Administrator as the user name and supply the admin password as password.



If you want to connect via their NT Domain, you would provide the name of the domain and user name, of course; and that user name would need permission on the SQL Server to use the objects you want to access remotely.
Tony W
2007-12-20 09:15:23 UTC
1st Method=. Simply put ",1444" (minus the quotes) next to the server name when connecting with Enterprise Manager or SQL Query Analyser .2. (Optional) Uncheck show system tables, this helps speed up the connection.2nd Method=1. Open SQL Client

Program Files -> Microsoft SQL Server -> Client Network Utility



If you cant find it there or don"t have Microsoft SQL or MSDE installed, you may find run Client Network Utility directly.



Start -> Run -> c:\windows\system32\cliconfg.exe



2. Click "Alias" Tab



3. Click the ADD button,



4. Under Server Alias type, sql.domain.com, substituting domain.com for your domain name.



5. Under "Network Libraries" on the left, please select TCP/IP.



6. Under Server Name type, sql.domain.com, substituting domain.com for your domain name.



7. Uncheck "Dynamically determine port"



8. Under Port Number, type 1444
th3fish
2007-12-20 09:14:49 UTC
remote desktop connection is the best way.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...