One of the reasons for that error when is when the owner of Quest Diagnostic service on Diagnostic Server machine is not in the administrators group.
You can go to services, right click on Quest Diagnostic Server service , select logon tab and type the user name and password. Then restart that service.
It is required for the Spotlight user from client machine to be a member of the Quest Diagnostic Administrator group on DiagosticServer-machine.
This group is used for providing access to connections stored on Diagnostic Server.
You should add your Spotlight-user into the list of Quest Diagnostic Administrators on DiagonstServer machine.
To check if Spotlight-user has proper rights to connect to DS, on DS-machine run the
C:\Program Files\Quest Software\Diagnostic Server\Agent\bin\GroupTest.exe utility with the following parameter in the command prompt:
GroupTest.exe domain\username > GroupTest.txt
where domain\username - credentials which customer uses to run Spotlight.
It might show wether authentication mechanism works fine for this user or not. Here is an exmple of successfull output from default location on C drive:
H:\>C:
C:\Program Files\Quest Software\Spotlight on SQL Server\Diagnostic Server\Agent\
bin>grouptest.exe questprod\tommacko
======================================================================
checking group "Quest Diagnostic Administrators" for domain "questprod" user "tommacko"
- checking user: "questprod\tommacko" - ** matched **
*** questprod\tommacko is an administrator ***
======================================================================
C:\Program Files\Quest Software\Spotlight on SQL Server\Diagnostic Server\Agent\
bin>