Microsoft KB Archive/328306

= Potential causes of the &quot;SQL Server does not exist or access denied&quot; error message =

Article ID: 328306

Article Last Modified on 2/22/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-



This article was previously published under Q328306



SUMMARY
&quot;SQL Server does not exist or access denied&quot; is a generic Microsoft Data Access Components (MDAC) message that indicates that the computer that is running Microsoft SQL Server cannot be contacted. This generic message has many potential causes. Some of the most common causes are described in the &quot;More Information&quot; section.

Note The following error messages also have similar causes:

SQL Server is unavailable or does not exist

The specified SQL Server is not found



MORE INFORMATION
The &quot;SQL Server does not exist or access denied&quot; message does not indicate the following:
 * That the logon process to SQL Server failed.
 * That SQL Server does not have the correct permissions to process the query.
 * That you cannot use SQL Server authentication because only Windows authentication is permitted.

Server-related causes
If no client computers can connect to the computer that is running SQL Server, there may be a server-side problem.  SQL Server is not installed on the computer that you specify in the connection string. Verify that SQL Server is actually installed on the computer that you specify in your connection string. SQL Server is not started. SQL Server must be running to accept connections. SQL Server is not listening on the protocol or port that you are using to connect. The Server Network Utility on the server determines which protocols SQL Server will use and on which TCP/IP ports SQL Server will listen. The Client Network Utility, an MDAC data source name (DSN), or your connection string determines which protocol and port your client uses when it connects. For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

289573 PRB: Configuring DSNs with SQL Server net-libraries

328383 SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server

 When SQL Server started, it could not listen on the specified TCP/IP port and is not accepting TCP/IP connections. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

293107 PRB: TCP\IP port in use by another application

 The SQL Server name is different from the computer name. For additional information about this issue for SQL Server 2000, click the following article number to view the article in the Microsoft Knowledge Base:

303774 BUG: &quot;Renaming a server&quot; topic in SQL Server Books Online is incomplete

For additional information about this issue for SQL Server 7.0, click the following article number to view the article in the Microsoft Knowledge Base:

195759 Frequently asked questions - SQL Server 7.0 - SQL Setup

For additional information about this issue for SQL Server in a clustered environment, click the following article number to view the article in the Microsoft Knowledge Base:

307336 How to change a clustered SQL Server network name

 For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

298822 FIX: MSDE connection may fail on a multihomed computer

 For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

306199 FIX: Dynamic IP addresses cannot connect to SQL Server 2000

</li> Starting with SQL Server Desktop Engine (also known as MSDE 2000) Service Pack 3 (SP3) or SP3a, only local connectivity is permitted, by default. If you want to permit remote connections to SQL Server Desktop Engine, follow the steps in the following article:

814130 How to help secure network connectivity for SQL Server 2000 local databases

</li></ul>

Client-related or application-related causes
If some client computers or applications can connect but others cannot, you are probably experiencing a client-side problem. <ul> The computer name does not exist. Double-check the spelling of the computer to which you are trying to connect.</li> You are trying to access a named instance of SQL Server, but you are not specifying the correct instance name. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

265808 How to connect to a SQL Server 2000 named instance with the previous version's client tools

</li> The Windows-level security that you are using to connect is different from what you expect. For example, Microsoft Internet Information Services (IIS) uses IUSR_ , not the account with which you log on to Windows or perhaps another account depending on how you configured IIS. Additionally, linked servers use the Windows-level security context of SQL Server Agent in some circumstances. The security context of the account that you are using may not have access to the computer on which SQL Server is installed.</li> You are not using the correct protocol. Check your Client Network Utility (CNU) to verify the protocols that you are using (for earlier versions of MDAC, you set a default instead of enabling protocols). Additionally, verify whether there are any defined aliases in the CNU that specify a different protocol or port (or both) than you expect. For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

328383 SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server

289573 PRB: Configuring DSNs with SQL Server net-libraries

</li> You removed the Client for Microsoft Networks networking component from the network properties on the client. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

253959 Client for Microsoft Networks functions when unbound from network adapter

</li> If SQL Server is clustered, the network adapters may be incorrectly named or configured. If any network adapters are named with special characters or with mixed case, rename them. Verify that the network adapters on the computer are configured properly.</li> You may be experiencing the side effects of an MDAC mismatch. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

307255 Component Checker: Diagnose problems and reconfigure MDAC installations

</li> Check the protocol that is specified in the following subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQUERY

This value typically reflects the settings in the CNU, but sometimes it does not. If the value is DBNETLIB, it uses one of the protocols in the enabled protocols list of the CNU. If a specific protocol is listed, that protocol is used instead.</li> You are trying to connect through named pipes, but either the named pipe on which SQL Server is listening has changed from the default, or you are using the incorrect pipe name.

For a default instance, use the following pipe in the Server Network Utility:

\\.\pipe\sql\query

For a named instance, use:

\\.\pipe\MSSQL$ \sql\query

</li> You have specified a DSN that is not of the correct type (file, user, or system). For additional information about the different types of DSNs, click the following article number to view the article in the Microsoft Knowledge Base:

213772 How to use system, user, and file data sources

</li> For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290820 BUG: SQL Desktop Edition: Shared memory fails to connect after you install MDAC 2.6

</li></ul>

<div class="moreinformation_section">

Network-related or domain-related causes
If you receive this error message only with computers that are in a specific domain, on a certain subnet, or behind a firewall, review the following issues. <ul> A firewall or router is not configured properly or has been configured to block UDP port 1434. If UDP port 1434 is blocked, you may have to specify the port on which SQL Server is listening in your connection string from the client. For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

287932 TCP ports needed for communication to SQL Server through a firewall

318432 BUG: Cannot connect to a clustered named instance through a firewall

</li> The local security policy user rights assignment for your Windows account does not allow access from the network. The &quot;Access this Computer from the Network&quot; policy must be permitted. Additionally, the &quot;Deny access to this computer from the network&quot; right must not be granted.</li> There is a domain trust problem, or one of the computers is in a workgroup and therefore has no access to the domain. In some cases, to work around this problem, you can create the same local Windows account on both computers with the same password for each account. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

321247 How to configure security for log shipping

</li> <li>Your name resolution is not working. Check your settings in the name resolution system that you use (such as DNS, WINS, hosts, or lmhosts). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

169790 How to troubleshoot basic TCP/IP problems

</li></ul>

Additional query words: tcp/ip tcpip named pipes shared memory odbc mdac

Keywords: kbinfo KB328306

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.