Local clients loose connection to local SQL Server when system network drops connection to HQ.

5 pts.
Tags:
Active Directory
SQL Server 2005
SQL Server 2005 connectivity
SQL Server connectivity
VB
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database.  For some clients, the application still works just fine.

The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication by the local domain controller should not be affected by dropping the network connection to the HQ Primary Domain Controller. Our VB/SQL application is set for Windows authentication and works fine in that mode. Until we drop the line to HQ.

One clue I had is that both the SQL Server and the Domain Controller (active directory) are on the same Server.   We moved the SQL Server to another Server, not the one with the Active Directory on it. Again, while the network is up, everyone can connect, but when we bring down the network, some users could connect to the SQL Server database and others received an error:

Error Message:

Problem in mdlFindServer.FillTable: Trying to read UpdateHistory.

ex = System.Data.SQLClient.SqlException: Timeout expired. The timeout period dlapsed prior to completion of the operation or the server is not responding.

Any help will be appreciated. Please and Thank you. 

Tom Helm

 



Software/Hardware used:
WIndows Server 2003, Visual Basic express, SQL Server Express, Dot Net 2.0
ASKED: March 18, 2010  9:14 PM
UPDATED: March 19, 2010  4:33 PM

Answer Wiki

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

Is it always the same clients that are having the problem connecting?

If it is then make sure that those clients are using the local DNS server, and that they have the correct default gateway configures so that they aren’t trying to access anything in the remote site.

Discuss This Question:  

 
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

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