Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 23-09-2009
Member
 
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.
Reply With Quote
  #2  
Old 23-09-2009
Member
 
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.
Reply With Quote
  #3  
Old 23-09-2009
Member
 
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)
Reply With Quote
  #4  
Old 23-09-2009
Member
 
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.
Reply With Quote
  #5  
Old 23-09-2009
Member
 
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".
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to detect Connection has failed with SQL Server"
Thread Thread Starter Forum Replies Last Post
Connection to the Server failed in Anno 2070 Sanaka Video Games 11 04-12-2011 02:33 PM
connection to server failed socket error 10013 leijen Windows Vista Mail 1 25-04-2011 11:04 AM
Failed to make connection by Primary DNS Server Erakna Networking & Security 5 04-04-2011 07:22 AM
Connection to the server failed or was dropped - Entourage 2008 Kingfisher Networking & Security 3 12-11-2009 08:01 PM
Login failed, not associated with a trusted SQL server connection Mentos Software Development 3 11-06-2009 10:46 AM


All times are GMT +5.5. The time now is 10:48 PM.