Solved

MS-SQL General Network Errors

Posted on 2007-04-04
1
177 Views
Last Modified: 2010-03-19
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.
0
Comment
Question by:compsol1993
1 Comment
 
LVL 7

Accepted Solution

by:
Hemantgiri S. Goswami earned 500 total points
ID: 18853580
Hi,
Refer http://support.microsoft.com/kb/875285

Regards
Hemantgiri S. Goswami
Microsoft SQL Server MVP
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question