|
|
Posted by Erland Sommarskog on 06/21/05 01:06
David C. Barber (david@NOSPAMdbarber.com) writes:
> My problem has become that we have some users at remote locations that
> VPN into our network who also want to use this application. When it's
> installed locally on their machines, or even on file servers at their
> locations, everything works fine. However, when they run the .exe off
> of my file server the SQL Server connections times out on the initial
> connection open after the default 30 seconds every time. Run from their
> own desktops or file servers it connects within 2 seconds every time.
> This is on both Windows 2000 and XP Pro machines. Even when I tell the
> shortcut to use their local drive for the working directory the same
> problem happens.
Sounds indeed very strange, and I suspect that is is not really SQL
Server problem. But I don't really have a clue.
The one thing I can think off is that loading of the EXE across the
write uses up the network bandwidth. But for 30 seconds? I don't really
believe in that myself.
What does your connection string look like?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|