MS-SQL General Network Errors

Hello,

We currently have a VPN connecting our PA and TX offices.  Our domain controller is located in TX.  In our PA office we have two servers, and application server running our accounting software and an MS-SQL running the back end database for that software.  

We are receiving general network errors from our application server frequently when trying to perform a database operation.  We are thinking it is related to having the domain server running DNS in TX.  

A possible solution we found was to add direct mapping of the database server to the application server's DNS host file.  

Is this the correct approach?  It seems general network errors are common in MS-SQL.  If anyone has any other thoughts on the topic of things we should look for if the DNS does not seem plausible, then please share that as well.

Thank you.
compsol1993Asked:
Who is Participating?
 
Hemantgiri S. GoswamiModerator - MSDN ForumsCommented:
Hi,
Refer http://support.microsoft.com/kb/875285

Regards
Hemantgiri S. Goswami
Microsoft SQL Server MVP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.