Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 remote sql

Author  Topic 

storm1981
Starting Member

9 Posts

Posted - 2007-07-19 : 13:14:32
i install sql server 2000 in server and i install sp4 for sql ,how can i access the database from remote pc using (new region in sql)?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-19 : 13:15:32
Did you install the client tools on the remote PC?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

storm1981
Starting Member

9 Posts

Posted - 2007-07-19 : 18:39:06
yes ,i have install client tools in the remote pc
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-20 : 11:02:47
Then you can register sql server in client tool if there is network connection between them.
Go to Top of Page

storm1981
Starting Member

9 Posts

Posted - 2007-07-21 : 07:47:51
i try it but it give me "access deny or sql not exist" ,their is network connection between them
i can access to the server by remote desktop tools.
is their any service in sql server that i must start it to connect to it ?

Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-21 : 12:33:54
Is sql service running on the server? Which protocol do you use to talk to sql server? What kind of network connection do you have? Is sql port open on your network? Which authentication used?
Go to Top of Page
   

- Advertisement -