-
Título
Getting error: "SQL Server Connection Failure: Cannot generate SSPI context. [0x80131904]" -
Descrição
Monitored Server - SQL Server Connection Failure: Cannot generate SSPI context. [0x80131904]
-
Resolução
WORKAROUND 1
Check if it is a DNS issue.
Here is a link to a Microsoft support note on how to troubleshoot this problem. It is a long and detailed explanation, and you will need to go through it very carefully. If you cannot obtain the cause of the problem by using the troubleshooting steps in this article, there is a section near the end of this article entitled "Information to collect to open a Microsoft Product Support (PSS) case"
<http://support.microsoft.com/kb/811889>
How to enable Kerberos event logging
<http://support.microsoft.com/kb/262177>WORKAOURND 2
Check the Quest Diagnostic Server service account is running on.
Check if Quest Diagnostic Server service is running with Local Service Account? If not then, try to change it to use Local Service account following these steps:
- Stop “Quest Diagnostic Server” service and altering it to use the local service account. (Please note of the original account for precautionary purposes)
- Restart it then try to connect again to Spotlight in Windows authentication. (Expect that it will still fail due to the change)
- Then Stop the service again and revert it to the proper account. Then try to connect again.