Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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

Novice: Requires knowledge of the user interface on single-user computers.

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


↑ Back to the top

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.

↑ Back to the top

Resolution

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

↑ Back to the top

More Information

Steps to reproduce the problem

  1. Open any project in Microsoft Access.
  2. On the File menu, click Connection

    Note In Microsoft Office Access 2007, click Microsoft Office button, point to Server, and then click Connections
  3. Type any server name that does not exist. For example, type abcdefg.

    Note In Access 2007, click to select Use Windows NT Integrated security under Enter information to log on to the server.
  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.

↑ Back to the top

Keywords: kbprb, kberrmsg, kbclientserver, kbaccess10ready, accrtmpublic, kbswept, kb, kbbillprodsweep, kbsweptsoltax, kboffice12yes, kbfreshness2006, kboffice2003yes

↑ Back to the top

Article Info
Article ID : 275118
Revision : 3
Created on : 4/17/2018
Published on : 4/18/2018
Exists online : False
Views : 177