Post reply

error at connection at sql server

  • May 21, 2012 at 11:48 am

    #256156

    hello,

    I installed sql server 2008 recently, but it can't be connect to the server and the following error occur,

    can not connect to...

    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:Named Piped Provider, error:40, could not open a connection to sql server) (Microsoft Sql Server, Error:2)

    ======================================================

    please help,

    thank you

  • May 21, 2012 at 11:52 am

    #1490586

    Check whether SQL server service is running on your machine?

    GulliMeel

    Finding top n Worst Performing queries[/url]
    Improve the performance of Merge Join(special case)
    How to Post Performance Problem -Gail Shaw[/url]

  • May 21, 2012 at 11:54 am

    #1490587

    This message means you can't connect to the instance.

    1) Open SQL Server Connection Manager and Verify that SQLServer service is running on the server.

    2) If you are trying to connect over the network, varify that TCP/IP is enabled and port 1433 is not blocked by Windows Firewall.

    3) Did you install as a named instance or default instance? Make sure you're trying to connect to the correct name.

  • May 21, 2012 at 9:15 pm

    #1490796

    1/ Check SQL Server service is running or not

    2/ Check SQL Server Name you're connecting to. If you select Defaut Instance Name while installing, you only need to use the digit . when you connect.

    3/ Which type of authentication login you configured (Windown or SQL or Fixed)? ==> Check account you're using to connect.

  • May 22, 2012 at 2:02 am

    #1490891

    Can u connect successfully from local? Can you telnet port 1433?

  • May 22, 2012 at 4:31 am

    #1490964

    I can't connect either local, can you help me how can I check sql server service is running or not.

    I found some articles from the internet but it didn't help me.

    thank you,..

  • May 22, 2012 at 7:09 pm

    #1491505

    Please post your SQL Server error log first

  • Viewing 7 posts - 1 through 6 (of 6 total)

    You must be logged in to reply to this topic. Login to reply