Issue running Powershell Module for Spotlight on SQL Server Enterprise

I am getting an error when trying to use powershell module for Spotlight on SQL Server Enterprise 12.4.0.24

1. browse to "E:\Program Files (x86)\Quest Software\Spotlight Enterprise\Console\"
2. execute ds-cli.cmd
3. get-connection

error:

get-connection : The system cannot find the file specified
At line:1 char:1
+ get-connection
+ ~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (System.Collecti...nnectionEntry]]:List`1) [Get-Connection], Exception
    + FullyQualifiedErrorId : GetConnections,DiagnosticServer.Install.Utilities.PS.GetConnectionCommand

Parents

MichaelD over 5 years ago

It turns out you need to be in the local windows group "Spotlight Diagnostic Administrators" as an individual and not within another Active Directory group.
Cancel
Up 0 Down

Reply

Cancel

Reply

MichaelD over 5 years ago

It turns out you need to be in the local windows group "Spotlight Diagnostic Administrators" as an individual and not within another Active Directory group.
Cancel
Up 0 Down

Reply

Cancel

Children

Gita Sharifi over 5 years ago in reply to MichaelD

Thanks for sharing Michael. Yes, our team has logged this as a future product change.
Just for your information on any future Spotlight PS command issues, you can look at the below log file in order to obtain more details about the nature of the issue:

C:\Users\<user name>\AppData\Roaming\Quest Software\Spotlight\<latest folder>\Support\DSClientLogs\DiagnosticServer.Install.Utilities_xxxxxxx_Errors.txt
Cancel
Up 0 Down

Reply

Cancel
MichaelD over 5 years ago in reply to Gita Sharifi

Thanks!
Cancel
Up 0 Down

Reply

Cancel