Hi,
At One of our PC (Windows XP) we are using a VB Application and which
is connected to the SQL Server Remotely through VPN Setup. The
Application works fine for some forms and Fetches the records from the
database but on some of the forms either on insertion or displaying
the records from databse it shows the following error.
Error Number -2147467259
[DBNETLIB]ConnectionRead (recv()).General network error.
Check your network documentation.
Runtime Error –2147418113(8000ffff)
Connection Failure
This is happening while connecting to three Seprate PC (All are
Windows XP) which has SQL Server 2000 installed while for one PC
having SQL Server 2000 it works perfectly Fine.
I tried to compare both the SQL Server (The one which is giving errors
and the other one which is working fine) and found that they have
different DBOwner set then i changed the DBOwner to "SA" (earlier
Administrator) but that did not solve the purpose.
Both the SQL Servers (The one which is giving errors and the other one
which is working fine) are connected through Named Pipe Options set in
NetLibrary . I tried to change the option to TCP/IP but that did not
help.
Then in last I tried to Run the SQL Profiler to Capture the Error
events but Profiler is unable to Capture the Events. Even Profiler
Shows one particular SP ( SP_SqlAgent_get_perf_Counters )executed
several Times, I even tried to change the Registry for this SP and set
it to Zero but Profiler is still unable to capture the events .
Has any body any idea's that why this error is coming and why the SQL
Profiler is not able to capture these error events.
Can the size of Query (which are executing) be a problem while
connecting through VPN. Like is there any limit of in terms of Query
length which is sent to SQL Server through VPN and beyond a particular
limit it raises the error.
Any Suggestions from the any body will be highly appriciated.
Thanks in advance
Amit Kathuria