Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-05 : 08:34:27
|
| Matthew writes "I have a machine in the DMZ of a firewall that can connect to SQL Server inside the LAN. However the initial connection for Enterprise Manager takes nearly a minute to establish, once connected performance is pretty good. There is also a website that uses this method and as the connection drops when not used for a while it takes ages for users to reconnect. So can I improve the speed of making a connection? or can I get the SQL keep the connection open for longer (nothing else uses the database)?OS Win2k Server SP4 on both machines, SQL 8.00.194" |
|
|
|
|
|
Slow connection across firewall