Results 1 to 5 of 5

Thread: How to detect Connection has failed with SQL Server

  1. #1
    Join Date
    Oct 2008
    Posts
    86

    How to detect Connection has failed with SQL Server

    I am trying to connect to the sqlserver, I have followed step by step a instructions and I have chosen SQL server authentication, but I received this error that is :
    "Connection failed", SQL State: 08001
    SQL Server Error: 6
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL Server Not Found.

  2. #2
    Join Date
    Feb 2006
    Posts
    159

    Re: How to detect Connection has failed with SQL Server

    I think you should Make sure that you are using the latest SQL Server service pack available. Check to make sure both your server and your application are using the same authentication. That is, Check that the client and server are running the same network protocol. Then Verify that the client and server are using the same Net-Library.

  3. #3
    Join Date
    Oct 2008
    Posts
    180

    Re: How to detect Connection has failed with SQL Server

    Right click on server registration and choose 'edit sql server registration properties'. check connection properties are correct. That means if there is version problem means If you are trying to register sql2005 instance for sql2000 using enterprise manager you cannot do that, use sql server management studio (the 2005 client tool)

  4. #4
    Join Date
    Oct 2008
    Posts
    80

    Re: How to detect Connection has failed with SQL Server

    The client connected to SQL Server 2000 must use a client Net-Library that matches one of the server Net-Libraries to which the server is currently listening. I have experienced the same problem, But the interesting part is that it only happened after I installed the XP Pro 64 bit and reinstalled VS 2005 and SQL developer version. While VS works fine I can't access or create SQL database because every time I click at server name combibox I get a blank field and the massage no Server connection.

  5. #5
    Join Date
    Oct 2008
    Posts
    180

    Re: How to detect Connection has failed with SQL Server

    Connections to databases are managed using database drivers, which enable applications written in different programming languages to interact with the database management system. But I will provide the way where you could make connections through SQL manager, Open The SQL Server Enterprise Manager Expand the tree-control until you can your server, Right click on the server name and "SQL Server Properties (Configure)" window will open Select the Security tab, For "Authentication", select "SQL Server and Windows".

Similar Threads

  1. Connection to the Server failed in Anno 2070
    By Sanaka in forum Video Games
    Replies: 11
    Last Post: 04-12-2011, 02:33 PM
  2. connection to server failed socket error 10013
    By leijen in forum Windows Vista Mail
    Replies: 1
    Last Post: 25-04-2011, 11:04 AM
  3. Failed to make connection by Primary DNS Server
    By Erakna in forum Networking & Security
    Replies: 5
    Last Post: 04-04-2011, 07:22 AM
  4. Connection to the server failed or was dropped - Entourage 2008
    By Kingfisher in forum Networking & Security
    Replies: 3
    Last Post: 12-11-2009, 08:01 PM
  5. Replies: 3
    Last Post: 11-06-2009, 10:46 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,695,948.15500 seconds with 17 queries