SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ERROR:SQL server doesn't exist or access is denie
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

boody_2007
Starting Member

1 Posts

Posted - 09/29/2007 :  08:01:07  Show Profile  Reply with Quote


I get this problem

unable to connect to server <server name>:
server:MSG 17, level 16, state 1
[Microsfot][ODBC SQL SERVER Driver][shared memory]
SQL server doesn't exist or access is denied

Please HELP ME if u can

_____
BOODY

Zoroaster
Aged Yak Warrior

USA
702 Posts

Posted - 09/29/2007 :  10:58:24  Show Profile  Reply with Quote
Please provide some details, where are you attempting to access the SQL Server from, what have you typed in for the servername? If you are not on the server itself are you able to ping the server? Have you ensured that the SQL Server service is started on the Server you are attempting to reach?

Take a look at this also and check all outlined causes:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328306




Future guru in the making.

Edited by - Zoroaster on 09/29/2007 10:59:10
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 09/29/2007 :  22:08:38  Show Profile  Reply with Quote
Enable tcp/ip and/or named pipes on sql server then try to connect with those protocols.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2060 Posts

Posted - 10/01/2007 :  05:40:13  Show Profile  Visit jackv's Homepage  Reply with Quote
This may be a name resolution issue , are using an IP address or a machine name?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/01/2007 :  06:14:32  Show Profile  Reply with Quote
Or the UserID/password you are using is not valid.

Kristen
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 10/01/2007 :  22:35:42  Show Profile  Reply with Quote
Error came from shared memory, it's protocol for local connection only.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000