If you're not using Windows Active Directory for domain management, take additional steps to ensure SQL Sentry works properly by using Windows Pass-through Authentication.
SQL Server authentication can be used for any Watched SQL Server instance in a non-Windows network using an instance's Monitoring Service Connection Properties context item. Access an instance's Monitoring Service Connection Properties by right-clicking on the desired instance in the Navigator pane (View > Navigator), and then selecting Monitoring Service Connection Properties from the context menu.
In non-Windows networks, connect to watched SQL Servers using the SQL Sentry client by doing one of the following:
- Use SQL Server authentication for any SQL Server registrations, or the SQL Server instance.
- Use Windows Pass-through Authentication, meaning the Windows user using the SQL Sentry client must also exist on the target SQL Server computer. The user name and password on each target must match exactly.
Pass-through authentication is the only means by which the SQL Sentry monitoring service collects Windows performance counters or watches Windows Task Scheduler in a non-Windows network environment.