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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2009-07-23 : 10:53:28
|
| Hello, i'm having an issue where when i try to connect form My Server2008 Terminal Server to SQL 2008, it delays about 30-60 seconds before it establishes the connection. odd thing is we have two DB servers that are identical Configurations, one works fine, the other delays... any ideas?Oh, also i've tried using the SA account, IP address (instead of DNS name) disabling IPv6, and it even still does it on some old tools like 2000's Import/Export Wizard and Query Analyzer. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2009-07-23 : 17:25:25
|
| any ideas on where to start? all other machines work fine with the problem server, and as i also mentioned, the server2k8 box can access our secondary DB server just fine, just not the primary. i've also noticed that even pulling up file shares is sluggish... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2009-07-24 : 17:40:19
|
| we figured it out last night, GOOGLE FTW!it happened to have something to do with the TCP/IP STACK. disabling some weird setting with netsh was did the job. we figured it wasnt anything to do with SQL when Share-browsing and RDP had the same snail-ish results.Thanks though! |
|
|
|
|
|
|
Slow Opening Connection