Hi i want to know how to enable remote server connection in sql server 2000. I have sql server 2000 installed in a system with windows server 2003 os. i want to create a dsn connection to the database through remote. I have created a dsn locally in the server it is working. but how to create dsn from the remote system and make it work.
+1
A:
To allow remote connections to the server, do the following:
In SQL Server Enterprise Manager, right-click the server and choose Properties. On the General tab, click the Network Configuration button and enable Named Pipes, and TCP/IP in the new window. I'm not sure if you need to restart SQL Server after doing this.
After doing this, you should be able to connect to the SQL Server from a remote computer, by referring to e.g. MYSERVER\MyInstanceName.
Bernhof
2009-07-27 08:40:31
Named pipes as well as TCP/IP is already in the enabled list
Rajesh Kumar J
2009-07-27 08:57:52
Connections to SQL Server are typically established through port 1433, unless you have changed this. Is there anything blocking access to the server, such as a firewall?
Bernhof
2009-07-27 09:39:08
I should probably also ask if you have tried connecting and it failed, or if you simply don't know how to setup the connection?
Bernhof
2009-07-27 10:25:41
A:
It helped me.
BTW I've also added sqlservr.exe to my firewall exception list: http://support.microsoft.com/kb/841251
digz6666
2010-09-20 10:33:44