Connection problems after upgrade to SQL 2005 resolved.

[barnowl]

Recently I posted a question re connection failures after upgrading to SQL
2005 from 2000 with an ADP front end (now removed from forum). Sylvain
Lafontaine was able to give me some useful things to try but did not cure the
problem. (thanks anyway Sylvain - useful stuff - will use the Alias which I
was not aware of.)

They had initially reported incorrectly that only my app had problems. On
discovering problems on another app, the customers' hardware support people
were eventually able to discover that there was a fimware problem in the new
server which was fixed by disabling the Chimney Offload feature

Netsh int ip set chimney DISABLED

as explained in
http://support.microsoft.com/kb/942861/en-US

 

[meskiana]

Recently I posted a question re connection failures after upgrading to SQL
2005 from 2000 with an ADP front end (now removed from forum). Sylvain
Lafontaine was able to give me some useful things to try but did not cure
the
problem. (thanks anyway Sylvain - useful stuff - will use the Alias which
I
was not aware of.)

They had initially reported incorrectly that only my app had problems. On
discovering problems on another app, the customers' hardware support
people
were eventually able to discover that there was a fimware problem in the
new
server which was fixed by disabling the Chimney Offload feature

Netsh int ip set chimney DISABLED

as explained in
http://support.microsoft.com/kb/942861/en-US