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.