You receive the "SQL Server does not exist or access denied" error message when you specify a nonexistent server name in the ADP connection information (275118)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
This article was previously published under Q275118
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

If you specify a nonexistent server in the connection information for a Microsoft Access project (ADP), you receive one of the following error messages:

Error message 1
Microsoft Data Link Error

Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
Error message 2
Microsoft Data Link Error

[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

RESOLUTION

Specify an existing server name in the connection information for a Microsoft Access project (ADP).

MORE INFORMATION

Steps to reproduce the problem

  1. Open any project in Microsoft Access.
  2. On the File menu, click Connection.
  3. Type any server name that does not exist, for example abcdefg.
  4. Click Test Connection. Note that you receive the following error message:
    Microsoft Data Link Error

    Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
  5. Click OK in the error message box, and then try to click to select a database on the server. Note that you receive the following error message:
    Microsoft Data Link Error

    [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
Modification Type:MajorLast Reviewed:11/2/2005
Keywords:KbClientServer kberrmsg kbprb KB275118 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.