SQL Server Express 2005 freezes

25 pts.
Tags:
SQL Server 2005 Express
SQL Server errors
SQL Server Express
SQL Server Express 2005
I have a server machine running Windows Server 2003 and SQL Server Express 2005 for a client-server application. All clients machines access the server through a router fine with good response time but if the internet connection fails suddenly the SQL Server freeze. Any SQL command takes a long delay. What could be the reason? What is the relation between Internet and SQL Server express? Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi, this may be due to CRL (Certificate Revocation List) check that is performed by SQL against the Internet, you can disable it.

If the users are accessing the SQL Server through a router then they are probably accessing the SQL Server over the internet. If the Internet goes out then they won’t be able to access the SQL Server until the Internet comes back up.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Navegante212
    Thanks Alessandro. Im going to try that and let you know what happened.
    25 pointsBadges:
    report
  • Navegante212
    I solve the problem using fixed IP's (disable dhcp) in the router and in the clients PC's.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following