Spotlight on SQL Server 10.0.3 - Getting Started Guide

Connection Properties Dialog - Details Page

View / modify the properties of a connection.

To open the Connection Properties dialog

1. Right-click the connection in the Spotlight browser or the Spotlight Connection Manager and select Properties.

2. Make changes as appropriate.

   Note: The fields displayed depend on the type of connection.

   Show all

   SQL Server connections

   Field	Description
   Target SQL Server Instance
   Address	Enter the connect string used to link to a server (that is, the Server Name, Server Instance Name, or IP address). Note: For a Microsoft Cluster Server (MSCS) enter the virtual name of the cluster.
   Windows Authentication (using Diagnostic Server credentials)	Select this option to use the user name and password configured on the Spotlight Diagnostic Server to connect to the SQL Server instance.
   Database User	A valid user that enables Spotlight to connect to the target system.
   Password	The password required to connect the specified user to the target system.
   Linked OS Connection
   Connection	Select the Windows machine to connect to. For a Microsoft Cluster Server (MSCS) select Cluster (monitor active node). Note: For a Microsoft Cluster Server (MSCS) Spotlight uses the current host node name to select the operating system connection. Therefore each Windows node in the cluster must be monitored by Spotlight. Check that each Windows node is in the list of available OS connections in the Linked OS Connection drop down field. See Windows Connections (page 1) to add a Windows node (connection) to the list. Click Create New to create a new connection to a Windows machine. If you do not want to monitor an associated Windows machine, select Do not monitor.
   Create New	Click to create a new connection to a Windows machine. You will need to complete the following: Address The IP address, hostname, or URL of the Windows machine you want to connect to. Use Diagnostic Server credentials Select this option to use the user name and password configured on the Spotlight Diagnostic Server to connect to the Windows machine. User A valid user account on the target system. Note: Spotlight on Windows needs to use an account with the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the target machine allows this. Password The password required to connect the specified user to the Windows machine.

   SQL Server Replication connections

   Note: This feature is available only in Spotlight on SQL Server Enterprise.

   Field	Description
   Address	Type the connect string for a distributor database in the replication environment (that is, the Server Name, Server Instance Name, or IP address).
   Windows Authentication (using Diagnostic Server credentials)	Select this option to use the user name and password configured on the Spotlight Diagnostic Server to connect to the SQL Server instance.
   User	A valid user account on the target system.
   Password	The password required to connect the specified user to the target system.

   High Availability

   Monitor Always On Availability Groups.

   Note: This feature is available only in Spotlight on SQL Server Enterprise. High Availability requires SQL Server 2012 or above.

   Field	Description
   Address	The High Availability Listener address: IP address, hostname, or URL.
   Windows Authentication (using Diagnostic Server credentials)	Select this option to use the user name and password configured on the Spotlight Diagnostic Server to connect to the High Availability listener.
   User	A valid user account on the High Availability listener. Note: Ensure the account has sufficient privileges to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the listener allows this.
   Password	The password required to connect the specified user to the High Availability listener.

   Analysis Services connections

   Field	Description
   Address	Select the connect string used to link to a server (that is, the Server Name, Server Instance Name, or IP address).
   Linked OS Connection
   Connection	The IP address, hostname, or URL of the Windows machine you want to connect to.
   Create	Click to create a new connection to a Windows machine. You will need to complete the following: Address The IP address, hostname, or URL of the Windows machine you want to connect to. Use Diagnostic Server credentials Select this option to use the user name and password configured on the Spotlight Diagnostic Server to connect to the Windows machine. User A valid user account on the target system. Note: Spotlight on Windows needs to use an account with the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the target machine allows this. Password The password required to connect the specified user to the Windows machine.

   Windows connections

   Field	Description
   Windows Connections
   Address	The IP address, hostname, or URL of a Windows machine you want to connect to.
   Use Diagnostic Server credentials	Select this option to use the user name and password configured on the Spotlight Diagnostic Server to connect to the Windows machine. Note: Select this option when connecting to the Windows machine that hosts Spotlight on SQL Server.
   User	A valid user account on the target system. Note: Spotlight on Windows needs to use an account with the privileges required to retrieve server information, query the registry, and access WMI and performance monitor objects. An account with administrative rights to the target machine allows this.
   Password	The password required to connect the specified user to the Windows machine.
   VM Name	If the Windows machine is hosted on a virtual machine, select the name of the virtual machine.
   Host	Select the name of the ESX Server or VirtualCenter server that hosts the virtual machine.
   Create New	Click to create a new connection to an ESX Server or VirtualCenter server. See the following section on VMware connections for more information.

   VMware connections

   Field	Description
   Address	The IP address or hostname of the ESX server or VirtualCenter server that hosts the Windows machine. Tip: If you have a VirtualCenter server then connect to that in preference to the ESX host. That way if the virtual machine migrates from one host to another the VirtualCenter server can still be interrogated for data for the Virtual Machine.
   User	A valid user account on the target system. Note: For Spotlight to monitor a VMware server, the username specified must have at least a read-only role for the ESX server or VirtualCenter server that you want to connect to.
   Password	The password required to connect the specified user to the server.

   SQL Azure Database connections

   Field	Description
   Target SQL Azure Database
   Address	Enter the URL used to link to a SQL Azure database.
   Database	Enter the name of the database you want to connect to.
   User	A valid user that enables Spotlight to connect to the target system.
   Password	The password required to connect the specified user to the target system.

Related Topics

Spotlight Connection Manager (page 1)

Spotlight Browser (page 1)

Connection Properties Dialog - Tags Page (page 1)

Connection Properties Dialog - Monitoring Page (page 1)