Documentation forSQL Sentry

SQL Sentry Non-Windows Network Environment Security

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.

SQL Sentry select Monitoring Service Connection Properties from the Navigator

SQL Sentry Client

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.

SQL Sentry Monitoring Service

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. 

Important:  The service user account must exist both on the service target and all monitored targets, and the user name and password must match exactly.