Error: 18056, Severity: 20, State: 46.

Question

Post reply

Error: 18056, Severity: 20, State: 46.

aprathour.89

Default port

Points: 1495
More actions
February 19, 2015 at 4:59 am

#294791

Hi Everyone,
i am getting the following error message in sql server error log.
Error: 18056, Severity: 20, State: 46.
The client was unable to reuse a session with SPID xxx, which had been reset for connection pooling. The failure ID is 46. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
What may be the possible causes for this error and how we can troubleshoot to find the root cause.
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

this link seems to imply the default database for a user might be null?

http://www.sqlservercentral.com/Forums/Topic1259661-146-1.aspx

do either of these return any data?

SELECT *

FROM sys.server_principals

WHERE default_database_name IS NULL

AND type_desc IN( 'SQL_LOGIN', 'WINDOWS_LOGIN','WINDOWS_GROUP' )

SELECT *

FROM sys.server_principals

WHERE default_database_name NOT IN(SELECT name

FROM sys.databases)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

aprathour.89 Default port Points: 1495 More actions · Answer 2

Thanks for reply

Sir,

I have run both the scripts , but could not get any result.

But i diagnose the dm_os_ring_buffer exception records , i found there are many errors with code 2627 (which means can not insert duplicate records ,violation of unique key or primary key) , and sudden server's cpu utilization spikes up to 100%. After 2-3 minutes it automatically goes down.

-----------------
Aditya Rathour
SQL DBA

Not Everything that is faced can be changed,
but nothing can be changed until it is faced.