How to add new servers to monitor for Spotlight on SQL Server Enterprise
Adding servers to SoSSE to monitor is only a matter of creating connections in the Connection Manager. SoSSE does not have an agent running on the monitored server. To add new connections in SoSSE, go to the Connection Manager by right-clicking on "Connections" on left side of screen and select "Connection Manager". On the dialog that comes up, click on the "SQL Server" icon on the left, then double-click on the "Add new connection" icon. Select the server name from the dropdown list (or type it in), and be sure that the user which runs the Diagnostic Server service has permission on that SQL Server instance, or you can uncheck "Windows Authentication" and provide SQL authentication credentials. Also be sure to create an OS connection and link it to the SQL Server connection via the "Linked OS Connection" dropdown on the same page.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center