Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Microsoft SQL server 2005 connection error..need help!


  • Please log in to reply
2 replies to this topic

#1 daredavel

daredavel

  • Members
  • 25 posts
  • OFFLINE
  •  
  • Local time:05:44 PM

Posted 03 March 2016 - 07:17 AM

Hello,

 

We have a running windows server 2003 with microsoft SQL server 2005 for 2 years with no problem. No recent changes was made in the server, but few days ago our client computers are having problems accessing the database of the SQL server and got an error of SQLSTATE=08001. Physical connections are in good condition and we can ping the server. The client computers are using a 3rd party application and access the database. (the 3rd party software/application handles the connection in the client computers)

 

7KC9zmj.png

 

The services of the SQL server are running and both TCP/IP and namedpipes are enabled.

 

gMrjPal.png

 

vcEPxhC.png

 

Sometimes the client can successfully connect to the database, sometimes they can't, and sometimes when they are trying to connect or when they are connected, the application freezes and not responding, then the error prompts.

 

Can someone please point me to the right direction in resolving this issue? I would appreciate any help.


Edited by daredavel, 03 March 2016 - 07:22 AM.


BC AdBot (Login to Remove)

 


#2 Wand3r3r

Wand3r3r

  • Members
  • 2,027 posts
  • OFFLINE
  •  
  • Local time:02:44 AM

Posted 03 March 2016 - 11:29 AM

review the sql log for possible pointers to the problem

https://technet.microsoft.com/en-us/library/ms187885(v=sql.90).aspx

 

review the servers event viewer logs for errors that maybe related



#3 daredavel

daredavel
  • Topic Starter

  • Members
  • 25 posts
  • OFFLINE
  •  
  • Local time:05:44 PM

Posted 03 March 2016 - 06:23 PM

review the sql log for possible pointers to the problem

https://technet.microsoft.com/en-us/library/ms187885(v=sql.90).aspx

 

review the servers event viewer logs for errors that maybe related

 

Thank you. I reviewed the logs and the error seems like a login issue. But the users can sometimes log-in successfully then the application will freeze and reconnecting to the database will not give error. Changing the password doesn't also work, the error is still there.

 

server.png






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users