Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Property IsLocked is not available for Login Expand / Collapse
Author
Message
Posted Friday, February 21, 2014 8:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:24 PM
Points: 17,807, Visits: 15,728
I can see memory issues causing (memory dumps) blocking logins. I haven't seen it actually change a login to be expired. I guess it's not much of a reach.

The next time it happens (hopefully it doesn't happen again), you might want to also check the sys.dm_os_ring_buffers for the logon failures. You might be able to procure a bit more information.

And since you saw the memory dumps, what is your max memory setting?

Is this a VM or a physical box?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1544013
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse