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.googlegrou ps.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.
>