I just installed SP1 for windows 7 and I have severe performance degradation when connecting to SQL Server 2005 since then. Establishing connection takes more than 30 seconds while it's instantaneous on another computer. Firewall is disabled and I didn't make any change to the configuration.

What can cause such a problem?

Thankds in advance!

link|improve this question
Try to check for any dns settings and use ip instead of name – Pitto Mar 8 '11 at 15:51
It doesn't fix the problem unfortunately – Julien Mar 8 '11 at 16:01
feedback

2 Answers

up vote 1 down vote accepted

To fix, run the following in an elevated Command Prompt:

netsh interface tcp set global autotuninglevel=disabled

Hopefully this is not too late to help.

This is not my answer, it comes from Smiley1244 from the MSDN forums but it is THE answer.

link|improve this answer
It'd be great if you could provide a link for future reference! – slhck Jun 3 '11 at 17:08
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.