Re: Connecting from outside world

• Previous message: Thank You: "Use SQL statements in Excel VBA to query SQL Server Data Problem"
• In reply to: Steve Thompson: "Re: Connecting from outside world"
• Next in thread: Steve Thompson: "Re: Connecting from outside world"
• Reply: Steve Thompson: "Re: Connecting from outside world"
• Messages sorted by: [ date ] [ thread ]

Date: Sat, 20 Nov 2004 06:31:07 -0800

Mr. Thompson...perhaps you can help me. I have set up SQL server 2000 on a
dual processor machine in a WAN/LAN environment. After several hours of being
"idle", SQL server begins transmitting "Chatter" accross both the LAN and
WAN, flooding the router and bringing the network to its knees. Subsequent
pings either time out or are finally successful yet at very high ms counts.

I also have SQL server 2000 running in a single processor environment where
this is not an issue.

Have you encountered this before? Can you offer any suggestion as to how to
address this problem?

Thanks,

Steve S

"Steve Thompson" wrote:

> "Neil Jarman" <neil@tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cmtfbd$qi5$1$8302bc10@news.demon.co.uk...
> > I have just set up SQL server on our system.
> >
> > I would like to be able to connect from accross the internet, like I can
> > with exchange. (Using EM)
> > What do I have to do in order to do this?
>
> The most efficient way would be a server (or desktop) that you could run
> remote desktop with a copy of EM tools. In this way the MMC is local to SQL
> Server and screen and keyboard updates are sent over the WAN. I'd recommend
> a VPN solution for connectivity to the remote device.
>
> Steve
>
>
>

• Previous message: Thank You: "Use SQL statements in Excel VBA to query SQL Server Data Problem"
• In reply to: Steve Thompson: "Re: Connecting from outside world"
• Next in thread: Steve Thompson: "Re: Connecting from outside world"
• Reply: Steve Thompson: "Re: Connecting from outside world"
• Messages sorted by: [ date ] [ thread ]