May 20, 2013 at 9:58 pm
Hi.
Error messages,
The client was unable to reuse a session with SPID 246, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
I have checked sp_who2 , it was showing more than 50 session not yet closed automatically also all the sessions are same select statement in particulare table..
How to close the existing connection?
1. I close the application but still apper all the session..
2. how to close connection instead of using KILL command?
3. restart service is not good method?
But I have done restart the sevice and all the connection was closed. could you suggestion me any alternative way for the same?
thanks
ananda
May 21, 2013 at 1:04 am
There is info on connect about this issue.
Problem solved in SQL 2008 SP2 CU1: http://support.microsoft.com/kb/2289254
May 21, 2013 at 1:32 am
In SQL SERVER 2008 R2 64 bit, I had installed SP2, Not for CU1..
should I download SP2 CU1 and apply that patch..?
thanks
ananda
May 21, 2013 at 2:15 am
Ok, check out this link:
May 21, 2013 at 2:37 am
Thanks for reply.. could you pl.confirm which patch number should be download?
(http://support.microsoft.com/kb/2720425/ )
2720425
Cumulative Update package 1 for SQL Server 2008 R2 Service Pack 2
2703280
Cumulative Update package 14 for SQL Server 2008 R2
I thought patch number 2720425 need to be download for which already installed SP2 on SQL Server 2008 R2 64 bit...
May 21, 2013 at 2:57 am
You are correct 2720425 is for SQL 2008 R2 SP2, click on the resolution link in the article, there you have all the info about which patch for which edition and version.
May 21, 2013 at 10:45 pm
Thanks for reply .. please confirm
I have download file name is : SQLServer2008R2-KB2720425-x86, it can apply for 32 bit not for 64 bit..
I could not able to download 64 bit patch from microsoft sites..
thanks
ananda
May 22, 2013 at 4:19 am
Hi,
Thanks for your help.. I had successfully updated CU1 on SQL2K8R2 64 bit.
File name downloaded: SQLServer2008R2-KB2720425-x64
Existing Version: SQL2K8R2 SP2 version - 10.50.4000
Current version: SQL2K8R2 SP2 CU1 version - 10.50.4260
I have noticed : during update patch at instance Database Mirror was disconnected with principal server after that mirror state is start automatically once patch was completed..
Thanks
ananda
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply