2012年3月20日星期二

Disconnects from Sql Server

I have a VPN connection to my Sql Server at work.
It works fine most of the time. I actually use my Windows 2000 Server as my
client from home.
What happens is that I will usually have 2 instances of Sql Server EM ,
Query Analyser and the Profiler running at one time. Normally, there is no
problem. But then I will lose all my connections. Even if I restart the
programs it won't reconnect for about 3 or 4 minutes. Then it does and
everything is fine for awhile.
I find that on XP, I can't seem to get it to reconnect until I reboot the
machine.
It has nothing to do with actual connection between my machine at home and
the work machines through the VPN, as I can ping the machines at work fine.
Anyone know what could be causing this problem?
Thanks,
TomHi
Check the SQL Server Event log for any entries at the time.
What happens when you open a terminal server session against your server,
keep it open and use the SQL Server tools on your machine?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"tshad" <tfs@.dslextreme.com> wrote in message
news:%23UvrGF7oFHA.1048@.tk2msftngp13.phx.gbl...
>I have a VPN connection to my Sql Server at work.
> It works fine most of the time. I actually use my Windows 2000 Server as
> my
> client from home.
> What happens is that I will usually have 2 instances of Sql Server EM ,
> Query Analyser and the Profiler running at one time. Normally, there is
> no
> problem. But then I will lose all my connections. Even if I restart the
> programs it won't reconnect for about 3 or 4 minutes. Then it does and
> everything is fine for awhile.
> I find that on XP, I can't seem to get it to reconnect until I reboot the
> machine.
> It has nothing to do with actual connection between my machine at home and
> the work machines through the VPN, as I can ping the machines at work
> fine.
> Anyone know what could be causing this problem?
> Thanks,
> Tom
>|||"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OLwc%23N7oFHA.3552@.TK2MSFTNGP10.phx.gbl...
> Hi
> Check the SQL Server Event log for any entries at the time.
> What happens when you open a terminal server session against your server,
> keep it open and use the SQL Server tools on your machine?
Actually, I have another program (or 2) also accessing the server fine, just
Sql Server seems to have a problem.
Tom

> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "tshad" <tfs@.dslextreme.com> wrote in message
> news:%23UvrGF7oFHA.1048@.tk2msftngp13.phx.gbl...
as
the
the
and
>sql

没有评论:

发表评论