Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loss of connection for local databases after connecting to network

Status
Not open for further replies.

sqlserveruser

Programmer
Jun 25, 2001
1
US
I have had difficulty maintaining the ability to connect locally to the PC's internal databases in SQL Server (local)
after a connection has been made to a network server. I get message "General Network Error: Check your documentation"
The only computers at our company that have been able to maintain successfully their local server connection are those that have never connected through the network to the network SQL Server. The separate registrations (i.e. local and network) are properly named. I have tried Multiprotocol
via the Client Network Utility. Any help would be appreciated.
The software constantly tries to go to a network SQL server
even when the connection registration is named with the local PC's identification from Network Neighborhood in Control Panel. Disconnecting from the network does not help.
John Newman
 
using Client Configuration Utility, try to add your computer's name using TCP/IP net work library :

Server Name : your computer name
Network Library : TCP/IP
Connection String : your computer's IP address

You can also set the default network library to Named Pipes and just refer to your computername when connecting to the (local) sQL server. :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top