SQL Server connections to backend server failing
-
Given 2 machines, one running IIS, the other SQLServer, with connections to SQLServer via named pipes (as opposed to TCP/IP) on a LAN, is there any way to determine why a connection to the SQLServer from the Web server would be failing at random times? The error messages reported by SQLServer and IIS are less than inspiring. Just wondering if anyone else has come across this random fail situation before. cheers, Chris Maunder
-
Given 2 machines, one running IIS, the other SQLServer, with connections to SQLServer via named pipes (as opposed to TCP/IP) on a LAN, is there any way to determine why a connection to the SQLServer from the Web server would be failing at random times? The error messages reported by SQLServer and IIS are less than inspiring. Just wondering if anyone else has come across this random fail situation before. cheers, Chris Maunder
Just chage the client on both machines to use TCP instead of Named Pipes and the problem is gone :) (I hope) Well, at least, if the errormessages is something about a "Overlapped Result" it works... - Anders