December 10, 2009 at 10:31 am
Hello,
Last night for brief 4 minutes, all the application servers, sharepoint servers lost connectivity to our main production database server.
All the servers have the same error.
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: xx.xx.xx.xx]
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: xx.xx.xx.xx]
All 15 servers were able to resume connection after 4 minutes.
Meanwhile, sql server seemed to be functioning completely ok.
In our environment, anything happens, 'Database is down' chaos is spread and DBA is put on the hot seat.
When there is nothing changed on the database server side, all the app servers are virtulized in last 2-3 weeks period.
However, nothing explains why it happened last night and that too just for 4 minutes.
I would like to either take athe blame as a dba or clear out myself after figuring out why this happened and what could be done to prevent this.
Could you tell me where to start digging for the cause? Is this really a database issue?
Thanks
N
December 10, 2009 at 3:59 pm
There could be a lot of reasons for this. Are there any errors in the SQL log or the event logs? Any networking errors or outages at that time? If it happens around the same time or frequently I would try collecting perfmon counters to see what is happening on your server around that time.
Then again, it may not be anything on your server itself at all. I have seen issues like this when local DCs are having issues and authentication is lost until the service comes back online. Are there any problems with your AD environment?
Joie Andrew
"Since 1982"
December 10, 2009 at 7:21 pm
Agree with some points that Joie made. Was there any sort of AD or network issue?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply