Spotlight on SQL Svr
One of the basic connection requirements for Spotlight on SQL Server is to access the SQL Server's registry.
If the user does not have access to the target machine's registry, then the SecurityWizard.exe needs to be run on the remote server.
WORKAROUND
Windows Permissions
In order to collect all its performance information, Spotlight requires that the user be authenticated to the server using a windows account that has the permissions to retrieve windows performance counters and has at least read access to the server's registry.
The easiest way to do this is to use an account that is a member of the Administrators group on the server they are connecting to, however Spotlight does not require an Administrator account.
For people who do not have access to an Administrator account, it is relatively simple for their administrators to assign the required access to specific groups or users. All they need to do is give the Spotlight user?s windows account (or any group it belongs to) read access to the following registry keys on the server:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurePipeServers\Winreg
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib
This can be achieved using a registry editor such as REGEDT32.EXE, locating each key in turn and assigning your group or user read access to each key. This gives that user read access to the entire registry, and the ability to view all windows performance counters.
Please note:
The above information is also mentioned in the release notes.
SOLUTION
Occasionally having Administrator access doesn't work or if you know that you don't have explicit access to performance counters, please run the attached Security Wizard to enable access to the remote registry. The Security Wizard also works with Spotlight on Oracle.
