August 13, 2012 at 10:08 am
HI,
We have sql server 2008 cluster which is insatalled on win 2003 server.
Sql is down and it is not comming up and in the eventvwer the error is logged as below.
Event Type:Error
Event Source:MSSQLSERVER
Event Category:Failover
Event ID:19019
Date:8/13/2012
Time:2:59:59 AM
User:N/A
Computer:M1812USPLN2
Description:
[sqsrvres] ODBC sqldriverconnect failed
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 0d 00 00 00 56 00 31 00 ....V.1.
0010: 38 00 31 00 32 00 53 00 8.1.2.S.
0018: 51 00 4c 00 32 00 30 00 Q.L.2.0.
0020: 30 00 38 00 00 00 00 00 0.8.....
0028: 00 00 ..
---------------------------------------------------------------
Event Type:Error
Event Source:MSSQLSERVER
Event Category:Failover
Event ID:19019
Date:8/13/2012
Time:2:59:59 AM
User:N/A
Computer:M1812USPLN2
Description:
[sqsrvres] checkODBCConnectError: sqlstate = HY000; native error = 8009030c; message = [Microsoft][SQL Server Native Client 10.0]Cannot generate SSPI context
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 0d 00 00 00 56 00 31 00 ....V.1.
0010: 38 00 31 00 32 00 53 00 8.1.2.S.
0018: 51 00 4c 00 32 00 30 00 Q.L.2.0.
0020: 30 00 38 00 00 00 00 00 0.8.....
0028: 00 00 ..
---------------------------------------------
Event Type:Error
Event Source:MSSQLSERVER
Event Category:Failover
Event ID:19019
Date:8/13/2012
Time:2:59:59 AM
User:N/A
Computer:M1812USPLN2
Description:
[sqsrvres] checkODBCConnectError: sqlstate = HY000; native error = 8009030c; message = [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: The logon attempt failed
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 0d 00 00 00 56 00 31 00 ....V.1.
0010: 38 00 31 00 32 00 53 00 8.1.2.S.
0018: 51 00 4c 00 32 00 30 00 Q.L.2.0.
0020: 30 00 38 00 00 00 00 00 0.8.....
0028: 00 00 ..
Please help us to recify the issue.
Many thanks.
August 13, 2012 at 10:21 am
It looks like the service account cannot connect to active directory. Maybe the account is gone, active directory is not accessible by this computer or the account is expired or the account password has been changed.
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply