SQL Monitor - 2.3
SQL Monitor connection error: Cannot generate SSPI context
If the status of a SQL Server instance displayed 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:
Stop your SQL Server service
- Open the Services Microsoft Management Console (MMC) (Control Panel > Administrative Tools > Services).
- Double-click on the SQL Server service and on the General tab, click Stop.
Restart using the Local System account and 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.
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.
Retry the connection in SQL Monitor
At the Monitored servers page (Configuration > Monitored servers), select Retry connection from the Actions list for the SQL Server instance:
For more information, see http://blogs.msdn.com/b/sql_protocols/archive/2005/10/15/481297.aspx.
Was this article helpful?
Search support
Forums
Visit the SQL Monitor forum.
Using SQL MonitorSQL Monitor
- Example configuration of SQL Monitor using virtualization software
- Retrieving alert settings using SQL Data Compare
- Licensing issues with SQL Monitor
- Log files in SQL Monitor
- Upgrading to a later version of SQL Monitor
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Monitor
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
