CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • Microsoft OLE DB Provider for SQL Server (0x80004005) SQL Server does not exist or access denied

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    54
  • Date Created
    Wednesday, November 24, 2010
  • Last Updated
    Thursday, April 21, 2022
  • This Article Has been Viewed
    2730 times
  • Short Desc
    If you can an Access denied to your SQL Server connection, chances are, you have lost access to SQL Server either by downtime or other unknown issues.
  • Details
    If SQL Server is not running or has shutdown to an unknown reason or cause, you will receive the following error

     
    Microsoft OLE DB Provider for SQL Server (0x80004005)
    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
    /wl/ACN.asp, line 4
  • Recreate Issue
    Scenario #1
    When SQL Server stops or is unresponsive, you will receive this error.

    Scenario #2
    If the appropriate ports are not open, you will receive this error.
  • Resolve Issue
    Scenario #1
    To correct this issue, Restart the computer or server and try to connect to SQL Server again. If you still cannot connect to SQL Server and this error persists, then you may have to reinstall SQL Server or Your OS to correct the issue.

    In more cases, restarting the computer or server usually fixes this issue.

    Performing the following action can also resolve this issue.
    Open Control Panel
    Then open Services
    Scroll down and find SQL Server (MSSQLSERVER)
    Right click and choose Start.



    --------
    Related Articles

    Microsoft OLE DB Provider for SQL Server (0x80004005) General network error. Check your network documentation«


    Scenario #2
    Make sure your port is properly configured.

    (Remote Connection to the Server Core)
    Open Computer Management, and log on to Server.
    --Right-click [Computer Management]
    ---Choose [Connect to another computer]
    ----Type in the server name. (This will also have to be enabled on the remote server to work.)
    Services and Applications
    ---[SQL Server Configuration Manager]
    -----[SQL Server Network Configuration]
    --------[Protocols for SQL2019]
    ;--Enable the following properties
    Named Pipes [Enable]
    TCP/IP
    Protocol = [Enable]
    IP Address
    --IP1
    TCP Port = [1433]
    Enable = YES
    --IPAll (located at the bottom)
    TCP Port = [1433]

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles