• Replies 6 replies
  • Subscribers 8 subscribers
  • Views 4870 views
  • Users 0 members are here
Options
Related

Issue running Powershell Module for Spotlight on SQL Server Enterprise

MichaelD
over 4 years ago

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
  • over 4 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.

  • over 4 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

Reply
  • over 4 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

Children