Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Windows Server | Connection Details

Open this screen from the Spotlight Client

  1. Click Configure | Connections.

  2. Select the Windows connection type.
  3. Click Add a new connection or to edit, right click the connection and select Properties.

    TIP: Spotlight can add Windows Server via discovery or by importing details from a file.

Specify the operating system connection details

Field Description

Address

The IP address, hostname, or URL of the Windows Server.

If the Windows Server is in a different domain to the Spotlight Diagnostic Server host then specify the address as a fully qualified address (for example, machine1.domain.company.corp). The connection may work intermittently if the address is not fully qualified.

Spotlight can only connect to Windows servers in a domain. Spotlight cannot connect to Windows servers in a workgroup. Spotlight cannot connect to databases hosted on Windows servers in a workgroup.

Authentication

The authentication for Spotlight to use to connect to the Windows server.

Select Use Diagnostic Server credentials to use the Windows user configured to run the Spotlight Diagnostic Server. You are required to select this option for the Windows Server that hosts the Spotlight Diagnostic Server. If you select this option and the Windows Server is remote from the Spotlight Diagnostic Server then ensure the Windows user running the Spotlight Diagnostic Server can access the Windows Server. (By default the Spotlight Diagnostic Server runs under the "Local System" account, which will not have privileges on a remote Windows Server). If you select this option and the Windows Server is in a different domain from the Spotlight Diagnostic Server then ensure the domain the Windows Server is in trusts the domain of the user running the Spotlight Diagnostic Server.

Alternatively, fill in the User and Password fields. Include the Windows domain in the user name. For example, “domain\johnsmith”, instead of “johnsmith”. The account must have the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the Windows server allows this. Alternatively an account can be configured with the necessary privileges as per How to configure WMI with minimum required user permissions.

Virtualization details

Field Description

Connection

If this Windows server is hosted by a virtual server then select the name of the virtual server.

TIP: Click Create to add a virtual server to the list.

VM Name

Select the name of the virtual machine from those hosted by the virtual server.

 

TIP: When done, click Test to verify Spotlight can successfully establish a connection with the details provided. If there are connection problems see Monitoring Windows Servers and hosts of database connections.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating