Post reply

SQLSERVER 2005 - UNABLE CONNECT

  • August 6, 2011 at 11:00 am

    #254943

    I have problem while connecting SSMS sql server 2005 instance..

    Errorr msg: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)."

  • August 7, 2011 at 2:06 am

    #1364861

    Try restarting the sql services esp the SQL Browser service. Make sure TCP/IP is enabled in network configurations.

    Do you face this issue every time your connecting using SSMS ?

    Have you tried connecting using any other methods?

    Jayanth Kurup[/url]

  • August 8, 2011 at 3:31 pm

    #1365555

    You can try the below option to detect the issue and able fix it accordingly.

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

    1) If SQL is a named instance check that the SQL browser is running (SQL configuration manager)

    2) Check the remote connection and TCPIP is enabled (SQL configuration manager)

    3) Try to ping the SQL server by IP and also by full domain name. Are you getting the reply?

    4) Try to provide the full domain name in SSMS Domain.server\instance name and click on connect.

    5) Check the windows firewall

    If still you are unable to connect. Open notepad and then save the file as "test.udl". Now right click and select property. Under the provider tab select SQL NATIVE CLIENT 10.0. Then under the connection tab d provide the required information and click on the TEST CONNECTION

    You should able resolve the issue. If not then let us know

Viewing 3 posts - 1 through 2 (of 2 total)

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