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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection Open...sql server does not exist error

Status
Not open for further replies.

grez

Technical User
Dec 1, 2002
155
US
Hi! Back again. Had a post earlier on the weekend (see "SQL 7.0 Proper Backup and Restore Procedures" on this forum). OK, placed the original machine back and that machine (we'll call it the "server" although on just a P2P network via a switch with one other computer) works just fine, however, the second computer, we'll call "workstation" uses the program from the "server" via the network and shortcut icons. When we try to connect, we get the following error:
"[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied."

Note that I took this machine and placed it on a router with DHCP at the shop. Apparantly, this may be a TCP/IP problem from what I understand.

From my research, I found the following link:
Now, where do I go and what step by step functions do I perform to get there? Don't have the machine in front of me, but I assume that "Server Network Utility" is off the SQL menu with Ent. Mgr.

Thanks again for your help and patience! Any guideance is greatly appreciated!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top