none
SQL Server 2008R2 Manager's error occured when login seeesion established.

    Question

  • Hi, everyone...

    A error on me has been occured during SQL Server 2008R2's Management established a login connection to daabase instance.

    The message in daialog as follows, when login criteria is that

    login criteria....

    Servr type:Database Engin

    Server name:(loval)

    Authentication:Windows Authentication

    Message....

    "Cannot connect to (local)

    Additiona information:

    A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. ..... provider:Named Pipes Provider,error:40- ..... Microsoft SQL Server, Error:2"

    How to solve this error and what caused it on me?

    SQL server running environment ....

    Windows Server 2008 r2 std with SP1 under VMwear.

    Thank you for cooperation.

    Wednesday, November 27, 2013 12:20 PM

Answers

  • Hello,

    Can you please check whether SQL server service is up and running.You can check it from SQL server configuration manager

    See this link for help

    http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Wednesday, November 27, 2013 12:26 PM

All replies

  • Hello,

    Can you please check whether SQL server service is up and running.You can check it from SQL server configuration manager

    See this link for help

    http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Wednesday, November 27, 2013 12:26 PM
  • Hi, thank you for information.

    I had resolved my issue by the information.

    Friday, November 29, 2013 12:25 PM