The following error may appear when trying to run the data collect job in Capacity Manager for SQL Server.
Message
Executed as user: SQL Server Network Interfaces: The logon attempt failed [SQLSTATE 42000] (Error 780) OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Cannot generate SSPI context". [SQLSTATE 01000] (Error 7412). The step failed.
Corrupt Registry on the monitored SQL Server.
WORKAROUND:
1. Please go to start | Run | type in Regedit
2. Please go to the following registry key: HKeyLocalMachine\Software\Microsoft\MSSQLServer\Client\SNI9.0
