Network error.

Hi,
I am facing a weird network problem. I am running a SQL 2000 SP2
enterprise edition over a Windows 2003 enterprise edition machine.
I am getting the network error messages (see below) while trying to
connect to the server. However if i am connected to the server before
the problem occurs i can continue running queries from the query
analyzer but cannot use the object browser to view the tables/ views
etc.
The problem is temporarily fixed if i restart the sql server service
but reappears after some times.
Seems to me it is is not a network problem otherwise the connection
would have broken.
Error 1:
[ODBC SQL Server Driver][DBNETLIB]General network error. Check your
network documentation.
Error 2:
[ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Any idea why this is happening?
Thanks in advance
Taw.Consider applying SP4, or at least SP3a, to your SQL 2000 instance.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Taw" <tawfiq.choudhury@.grameenphone.com> wrote in message
news:1185800793.766706.9030@.l70g2000hse.googlegroups.com...
> Hi,
> I am facing a weird network problem. I am running a SQL 2000 SP2
> enterprise edition over a Windows 2003 enterprise edition machine.
> I am getting the network error messages (see below) while trying to
> connect to the server. However if i am connected to the server before
> the problem occurs i can continue running queries from the query
> analyzer but cannot use the object browser to view the tables/ views
> etc.
> The problem is temporarily fixed if i restart the sql server service
> but reappears after some times.
> Seems to me it is is not a network problem otherwise the connection
> would have broken.
> Error 1:
> [ODBC SQL Server Driver][DBNETLIB]General network error. Check your
> network documentation.
> Error 2:
> [ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
> Any idea why this is happening?
> Thanks in advance
> Taw.
>