SQL Monitor 11

SQL Monitor Connection Error – Cannot generate SSPI context

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", there are two approaches.

Approach 1

1. Stop your SQL Server service

  1. Open SQL Server Configuration Manager.
  2. On the left, select the SQL Server that hosts the service.
  3. On the right, right-click the SQL Server service and select Stop.

Alternatively:

  1. Open the Services Microsoft Management Console (MMC) (Control Panel > Administrative Tools > Services).
  2. 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

  1. In the Log On tab, select Local System account and click OK.
  2. On the General tab, click Start.
  3. Once the Service status is confirmed as Started, click Stop.

3. Switch back to your domain account and restart

  1. In the Log On tab, select This account.
  2. Enter your SQL Server domain account details and click OK.
  3. On the General tab, click Start.

4. Retry the connection in SQL Monitor

On the Monitored servers page (Configuration > Monitored servers), under the Actions menu for the SQL Server instance, select Retry connection:

Approach 2

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.


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?