faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

60 of 237 people (25%) answered Yes
Recently 1 of 10 people (10%) answered Yes

Entry

Microsoft:SQLserver:[DBNETLIB][ConnectionOpen Connect()]SQL Server does not exist or access denied

May 24th, 2004 14:45
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 08 December 2003 - 09:21 pm -------------------
Microsoft:SQLserver:[DBNETLIB][ConnectionOpen Connect()]SQL Server 
does not exist or access denied
---
When trying to open a Microsoft SQL server database error 'Connection
open failed. SQL State: 08001 SQL Error Code: 17
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied'.
---
Probable cause:
The Microsoft SQL server is not running at all.
Check e.g. in your Microsoft task manager if you see the process
 sqlservr.exe
running.
If not, start it e.g. by opening the Microsoft SQL server Enterprise 
manager,
right click on the name of your SQL server, and choose 'connect'.
---
---
Probable cause:
You should supply the same server name as the SQL server that is 
running.
To see this, put the mouse on the taskbar over the Microsoft SQL server
icon, and there you see e.g.
\\DELLI8500 - MS SQL Server
So choose then as server name
 DELLI8500
(replace this with what you see on your computer)
---
After that, choose as login 'Windows NT authentification' (or otherwise
login name + password if you did choose this option while installing
Microsoft SQL server 2000.
----------------------------------------------------------------------