Not able to connect to SQL Server after removing it from network

13 May 2005 10:44 PM

Vikas

I have my application that is running against MS SQL 2000 database (both on
the same machine). If I unplug the network cable from that machine then my
application is not able to connect to SQL Server. If I take my machine and
plug it in the network but a difefrent IP than earlier then also my
application is not able to connect.

The only solution then is to restart SQL Server and everythimng seems to
work fine from there on.

Any ideas as to why does SQL Serevr behave like this? Any workarounds so
that my application is able to connect to the SQL 2000 database irrespective
if it is on network or off network (especially if they are on the same
machine).

--
Vikas

14 May 2005 9:00 AM

John Bell

Hi

Is enable shared memory protocol enabled in the machine?

How do you connect to it?

John

Show quoteHide quote

"Vikas" <Vi***@discussions.microsoft.com> wrote in message
news:EACD5A00-765A-4E12-9FC6-6548A382C187@microsoft.com...
>I have my application that is running against MS SQL 2000 database (both on
> the same machine). If I unplug the network cable from that machine then my
> application is not able to connect to SQL Server. If I take my machine and
> plug it in the network but a difefrent IP than earlier then also my
> application is not able to connect.
>
> The only solution then is to restart SQL Server and everythimng seems to
> work fine from there on.
>
> Any ideas as to why does SQL Serevr behave like this? Any workarounds so
> that my application is able to connect to the SQL 2000 database
> irrespective
> if it is on network or off network (especially if they are on the same
> machine).
>
> --
> Vikas