SQL Timeout error

Question

Guys

Getting this error,

NativeError = 258 Error = [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. SQLState = HYT00, NativeError = 0 Error = [Microsoft][SQL Native Client]Login timeout expired SQLState = 08001, NativeError = 258 Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in login response

Hope someone could help.

Cheers

Answer 1

Restart your sql server and check... Increase the pool size in your connection string...

Answer 2

Try setting the SqlCommand.CommandTimeout property to 0. For more info, there is a MSDN article here.

Answer 3

I think you might find this Microsoft KB article useful. If your login problem meets the criteria listed in that article, then it's a known SQL Server 2005 bug and there are workarounds.