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)
 Connecting to a remote server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-23 : 10:14:53
tapiwa writes "am implementing an application using vb and sql server. some of the clients are at out of town branches with server at head office. have added users to database and given appropriate permissions. on trying to connect generates the following error.

[DBNTNTW]Specified Server Not found.

Can see the IP address for server machine on client but not actual computer name. is there a way to associate the IP address to the computer name so that our clients can use the name specified in teh connection string"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-23 : 14:33:17
Their default protocol is set to Named Pipes. It can be set to TCP/IP instead or an alias can be created. Do these clients have SQL Client Tools installed? If so, you can do both in Client Network Utility. If they don't, you'll need to make the change in the registry. Let us know.

Tara
Go to Top of Page
   

- Advertisement -