RE: Connecting to SQL server Over Internet/ Phone line etc.
From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 04/13/04
- Next message: Mike: "'sp_addlinkedsrvlogin' requires sysadmin account"
- Previous message: Hernán Castelo: "Re: random connection error"
- In reply to: Lisa Jones: "RE: Connecting to SQL server Over Internet/ Phone line etc."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Apr 2004 20:45:49 GMT
Hi Lisa,
The same rules apply. If you're going to allow access via phone line,
then as long as the application can recover from a dropped line, there's no
reason why you couldn't do this. There may be some tcp parameters that you
might need to adjust to account for the slow line speed. You could also
experiment with changing the packetsize in SQL to 512.
Across the internet, you have much more bandwidth. The connection quality
and stability relies on the ISP provider.
Hope this helps
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
- Next message: Mike: "'sp_addlinkedsrvlogin' requires sysadmin account"
- Previous message: Hernán Castelo: "Re: random connection error"
- In reply to: Lisa Jones: "RE: Connecting to SQL server Over Internet/ Phone line etc."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
