Network error

When I unplug my server from the network, I lose connection to SQL Server. I
don't understand why it is happening. All my applications have to be closed
and reopened to talk to the database again. Can anyone please let me know why
this is happening?
I am using SQL Server 2005 SP1 and Windows Server 2003.
Any help is appreciated.FYI: I am connected to the local server and not to a server on the network.
"KMP" wrote:
> When I unplug my server from the network, I lose connection to SQL Server. I
> don't understand why it is happening. All my applications have to be closed
> and reopened to talk to the database again. Can anyone please let me know why
> this is happening?
> I am using SQL Server 2005 SP1 and Windows Server 2003.
> Any help is appreciated.|||Please verify on your sql server what protocol is using if is using tcp/ip as
default thats why. also you can create a local host file with the localip or
just 127.0.0.1
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"KMP" wrote:
> FYI: I am connected to the local server and not to a server on the network.
> "KMP" wrote:
> > When I unplug my server from the network, I lose connection to SQL Server. I
> > don't understand why it is happening. All my applications have to be closed
> > and reopened to talk to the database again. Can anyone please let me know why
> > this is happening?
> >
> > I am using SQL Server 2005 SP1 and Windows Server 2003.
> >
> > Any help is appreciated.|||Thanks. But I don't understand what you are trying to tell me. Yes, SQL
Server is using TCP/IP. Can you be more specific on the host file thing?
"Santos Martinez" wrote:
> Please verify on your sql server what protocol is using if is using tcp/ip as
> default thats why. also you can create a local host file with the localip or
> just 127.0.0.1
>
> --
> Santos Martinez,MCSE, MCDBA, MCTS
> IT Community Staff of Puerto Rico
> http://www.itcspr.org
>
> "KMP" wrote:
> > FYI: I am connected to the local server and not to a server on the network.
> >
> > "KMP" wrote:
> >
> > > When I unplug my server from the network, I lose connection to SQL Server. I
> > > don't understand why it is happening. All my applications have to be closed
> > > and reopened to talk to the database again. Can anyone please let me know why
> > > this is happening?
> > >
> > > I am using SQL Server 2005 SP1 and Windows Server 2003.
> > >
> > > Any help is appreciated.|||KMP wrote:
> Thanks. But I don't understand what you are trying to tell me. Yes, SQL
> Server is using TCP/IP. Can you be more specific on the host file thing?
>
When you connect to a TCP/IP networked computer, you either do it by
specifying the IP address of the machine, or the hostname of the
machine. If you specify the hostname, then your computer will talk to a
DNS or WINS server to find out what IP address that hostname equates to.
If your machine is disconnected from the network, it can't communicate
with a DNS or WINS, and therefore can't figure out that MACHINEX = IP
10.10.10.1, for example. Since you're connecting back to your own
machine, you can avoid this by specifying an IP address of 127.0.0.1, or
a machine name of "localhost" - either one will loop back to your own
machine. Basic networking stuff...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||So can you please tell me where and how I would be making the changes?
"Tracy McKibben" wrote:
> KMP wrote:
> > Thanks. But I don't understand what you are trying to tell me. Yes, SQL
> > Server is using TCP/IP. Can you be more specific on the host file thing?
> >
> When you connect to a TCP/IP networked computer, you either do it by
> specifying the IP address of the machine, or the hostname of the
> machine. If you specify the hostname, then your computer will talk to a
> DNS or WINS server to find out what IP address that hostname equates to.
> If your machine is disconnected from the network, it can't communicate
> with a DNS or WINS, and therefore can't figure out that MACHINEX = IP
> 10.10.10.1, for example. Since you're connecting back to your own
> machine, you can avoid this by specifying an IP address of 127.0.0.1, or
> a machine name of "localhost" - either one will loop back to your own
> machine. Basic networking stuff...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Hi, Can someone help me get past this stumbling block? Thanks.
"KMP" wrote:
> So can you please tell me where and how I would be making the changes?
> "Tracy McKibben" wrote:
> > KMP wrote:
> > > Thanks. But I don't understand what you are trying to tell me. Yes, SQL
> > > Server is using TCP/IP. Can you be more specific on the host file thing?
> > >
> >
> > When you connect to a TCP/IP networked computer, you either do it by
> > specifying the IP address of the machine, or the hostname of the
> > machine. If you specify the hostname, then your computer will talk to a
> > DNS or WINS server to find out what IP address that hostname equates to.
> > If your machine is disconnected from the network, it can't communicate
> > with a DNS or WINS, and therefore can't figure out that MACHINEX = IP
> > 10.10.10.1, for example. Since you're connecting back to your own
> > machine, you can avoid this by specifying an IP address of 127.0.0.1, or
> > a machine name of "localhost" - either one will loop back to your own
> > machine. Basic networking stuff...
> >
> >
> > --
> > Tracy McKibben
> > MCDBA
> > http://www.realsqlguy.com
> >|||KMP wrote:
> So can you please tell me where and how I would be making the changes?
>
I'm not sure what you're looking to change. As I stated, if you simply
connect to "127.0.0.1" or "localhost", things should work whether you're
on the network or not. Query Analyzer and/or Management Studio will
prompt you for a server name, use "localhost". In Enterprise Manager,
you'll have to register a new server to represent "localhost".
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||have you try to modify the hosts on %windir%\system32\drivers\etc.
put localhost = 127.0.0.1 or yourmachinename = 127.0.0.1
also have you take a look into the network client network utility and server
network utility.
regards,
--
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"Tracy McKibben" wrote:
> KMP wrote:
> > So can you please tell me where and how I would be making the changes?
> >
> I'm not sure what you're looking to change. As I stated, if you simply
> connect to "127.0.0.1" or "localhost", things should work whether you're
> on the network or not. Query Analyzer and/or Management Studio will
> prompt you for a server name, use "localhost". In Enterprise Manager,
> you'll have to register a new server to represent "localhost".
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>sql