Error: 18056 State: 29 The client was unable to reuse a session. The failure ID is 29 after upgrading SQL 2000 to SQL 2008 SP2

I want to share this troubleshooting scenario since it may help you: After upgrading SQL Server 2000 SP4 to SQL Server 2008 SP2, SQL Server experienced performance problems and many a times, connection failures SQL Server errorlog shows this message during the problem period: Error: 18056, Severity: 20, State: 29. The client was unable to…

2