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:

  • error: 40 - Cannot connect to Server/Instance Specified The server was not found or was not accessible

    • 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:
    207
  • Date Created
    Wednesday, February 26, 2014
  • Last Updated
    Wednesday, February 26, 2014
  • This Article Has been Viewed
    1765 times
  • Short Desc
    Connecting to SQL Server, using the Management Studio, without SQL Server Service running, will cause the error 40.
  • Details
    Make sure that SQL Server (InstanceName) is running, if not, you may encounter this error.

     

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to server-name\instance-name.

    ------------------------------
    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

    >------------------------------
    BUTTONS:
    OK
    ------------------------------
  • Recreate Issue
    To recreate this issue:

    Stop the following services from running.
    SQL Server (InstanceName)
    SQL Server Agent (InstanceName)
  • Resolve Issue
    To Resolve this issue:

    Make sure that SQL Server (InstanceName) is running.

    Go to
    [Control Panel] | [Administrator Tools] | [Services]
    Scroll Down and [Start] the following Services
    SQL Server (InstanceName)
    SQL Server Agent (InstanceName)

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles