Connection Issue

The computer I work on has Sql Server on it. We also have a main server in
the office with sql server on it. The sql server on my computer has test
data that I do my development with but part of the data needs to be kept up
to date by copying it from the main server. This is done by the main server
connecting to my laptop and giving me the lastest data. Every so often this
stops working for an unknown reason because it can no longer connect to the
sql server on my computer. I connect from my computer to the main sql
server but not the other way around. Its like my sql server has become
invisible. The main server will connect to other remote sql servers though
and it will even connect to my computer through the network just not sql
server. What could be causing this? Why does it randomly happen and then
randomly goes away? This is very very annoying...any help that anybody
can provide would be greatly appreciated. This server is running Sql Server
2000 SP3 on Windows 2000 Server with the lastest service pack which I put on
just a week and a half ago.
Thanks,
BrandonHi
Do you get a specific error message when this occurs?
If the servers are close you may want to add network cards to each server
and create a dedicated link, or possibly a VLAN or dedicated sub-net to join
the two machines. If you have any firewalls or intrusion detection in between
make sure that they are running when this occurs. Check that there is no
other process that would make the network unresponsive (such as a networked
backup)
John
"Brandon Owensby" wrote:
> The computer I work on has Sql Server on it. We also have a main server in
> the office with sql server on it. The sql server on my computer has test
> data that I do my development with but part of the data needs to be kept up
> to date by copying it from the main server. This is done by the main server
> connecting to my laptop and giving me the lastest data. Every so often this
> stops working for an unknown reason because it can no longer connect to the
> sql server on my computer. I connect from my computer to the main sql
> server but not the other way around. Its like my sql server has become
> invisible. The main server will connect to other remote sql servers though
> and it will even connect to my computer through the network just not sql
> server. What could be causing this? Why does it randomly happen and then
> randomly goes away? This is very very annoying...any help that anybody
> can provide would be greatly appreciated. This server is running Sql Server
> 2000 SP3 on Windows 2000 Server with the lastest service pack which I put on
> just a week and a half ago.
>
> Thanks,
> Brandon
>
>