How to acesses sql server 2000 from remote pc ?

hi masters,

i am using Sql server 2000 (MSDE) , and i want to acesses database from remote machin, how it is possible any one tell me pls?

You need to enable NP and/or TCP protocols on the server side using SQL Server Server Utility. You need restart MSDE after the configuration change. If you have SQL Server 2005 installed, you need to run SQL Browser as well. In addition, make sure your firewall does not block the TCP ports if you have firewall installed. Check you error log to find out which TCP port your MSDE is listening on. For Sql Browser, you need put UDP port 1434 into exception.

Thanks,

|||

Thanks for reply,

but still unable to connect the remote pc,

i have working with only sqlserver 2000

and also

enable NP and/or TCP protocols on the server side using SQL Server Server Utility

what can i do next?

|||

Are the client and server on the same network?
Can you ping your server from remote client machine?
What's the tcp port sql server listen on? You can get this from errorlog. Try "telnet remotemachine yoursqlport", can you connect? If you have firewall, please put both your sqlport(tcp) and UDP 1434 into exception.

|||

thanks for reply

1. Yes the client and server on the same network.

2. Yes ping is replying

but how to do--?

What's the tcp port sql server listen on? You can get this from errorlog. Try "telnet remotemachine yoursqlport", can you connect? If you have firewall, please put both your sqlport(tcp) and UDP 1434 into exception.

will you guide me?

|||Please refer to: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

You can also check books-on-line.