If the status of a SQL Server instance on the Monitored servers configuration page is Connection failed - Cannot connect, and the exception message in the log file contains "Cannot generate SSPI context", do the following:
1. Stop your SQL Server service
- Open SQL Server Configuration Manager.
- On the left, select the SQL Server that hosts the service.
- On the right, right-click the SQL Server service and select Stop.
Alternatively:
- Open the Services Microsoft Management Console (MMC) (Control Panel > Administrative Tools > Services).
- Double-click the SQL Server service and, on the General tab, click Stop.
2. Restart the service using the Local System account, then stop it again
- In the Log On tab, select Local System account and click OK.
- On the General tab, click Start.
- Once the Service status is confirmed as Started, click Stop.
3. Switch back to your domain account and restart
- In the Log On tab, select This account.
- Enter your SQL Server domain account details and click OK.
- On the General tab, click Start.
4. Retry the connection in Redgate Monitor
On the Monitored servers page (Configuration > Monitored servers), under the Actions menu for the SQL Server instance, select Retry connection:
For more information, see “Cannot Generate SSPI Context” error message, more comments for SQL Server on MSDN.
Alternatively you can also try troubleshooting with the MS Kerberos tool.
Download and run the Microsoft Kerberos Configuration Manager tool. The tool can be downloaded onto any machine on the domain. Connect to the monitored server that is showing the error using the tool using a domain account that is an administrator on the machine, and fix any SPN errors indicated.
Was this article helpful?
Articles in this section
- Redgate Monitor migration guide to version 14
- "Your browser does not seem to be accepting cookies." error message
- Setting up OpenID Connect (OIDC) with Entra ID in Redgate Monitor
- Proxy Configuration in Redgate Monitor
- WMI error after DCOM hardening patch
- Redgate Monitor alert tuning
- Redgate Monitor set up for optimal performance
- Redgate Monitor Base Monitor Service Account
- Configuring Metrics and Alerts in Redgate Monitor
- Getting started with Redgate Monitor