|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Cannot connect to server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot connect to server
|
|
| Alex Moran 2002-06-26, 10:25 am |
| When trying to connect to local server on my computer in
datalink from VisualStudio.Net or from Access XP I
repeatedly get the error message "Connection failed, SQL
State:'08001' SQL Server Error: 17 [DBNETLIB]
[ConnectionOpen(Connect()).]SQL does not exist or access
denied.
No servers or data connections show up in ServerExplorer,
what do I need to do to connect?
I have an icon in my systray that say's "Running-
\\jimmagee\NetSDK - MSSQLServer" I assume that's what I'm
trying to connect to.
| |
| John Gose [MS] 2002-06-27, 9:25 pm |
| Alex,
Looks like you have a named instance. Start up query analyzer. Use
jimmagee\NetSDK as the server name. Leave authentication as NT. If this
fails, try switching to SQL Server authentication and use SA & the proper
password.
John Gose
MCDBA
Microsoft SQL Server Support
This posting is provided "AS IS", with no warranties, and confers no rights
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Content-Class: urn:content-classes:message
| From: "Alex Moran" <alexmoran@frontier.net>
| Sender: "Alex Moran" <alexmoran@frontier.net>
| Subject: Cannot connect to server
| Date: Wed, 26 Jun 2002 09:12:03 -0700
| Lines: 13
|
<Snip of Header Stuff>
|
| When trying to connect to local server on my computer in
| datalink from VisualStudio.Net or from Access XP I
| repeatedly get the error message "Connection failed, SQL
| State:'08001' SQL Server Error: 17 [DBNETLIB]
| [ConnectionOpen(Connect()).]SQL does not exist or access
| denied.
|
| No servers or data connections show up in ServerExplorer,
| what do I need to do to connect?
|
| I have an icon in my systray that say's "Running-
| \\jimmagee\NetSDK - MSSQLServer" I assume that's what I'm
| trying to connect to.
|
|
|
|
|
|