Skip to main content
SQL Planner

Configuration

Windows Authentication and limited permission with SQL Planner

Configure SQL Server monitoring with Windows Authentication and limited VIEW SERVER STATE permissions using a domain user.

1 min readUpdated

Many users prefer Windows Authentication with limited permissions (VIEW SERVER STATE) for SQL Server monitoring. Below are the steps to configure this within SQL Planner using a domain user.

Step 1: Create the monitoring job

  1. 1

    Open the wizard

    Navigate to Menu → Create SQL Server Monitoring Job.

  2. 2

    Enter the instance

    Enter your SQL Server name.

  3. 3

    Choose Windows Authentication

    Select Windows Authentication as the connection type.

Choose Windows Authentication, then use Create Monitoring Login for a limited-permission user.

Step 2: Authenticate the domain user

  1. 1

    Enter credentials

    Enter the domain user credentials.

  2. 2

    Connect

    Click Connect.

Step 3: Configure permissions

If the domain user lacks a login or the required permissions on the target server, follow the instructions below to resolve the access issue.

Set the SQL Planner application pool identity to the same Windows account used for monitoring.

If the domain user lacks login access or the necessary permissions on the target SQL Server, you must grant them. You can do this by clicking “Create Monitoring Login,” entering the server details, and assigning permissions. Alternatively, click “Generate Script” and execute it directly on the SQL Server you intend to monitor.

Create Monitoring Login — generate and review the limited-permission script before you execute it.

Extended Events folder

Once permissions are in place, return to the Monitoring Job screen and click Connect. SQL Planner will ask you to create a folder (SQLPlanner_dir_Deadlock_detect) under the C: drive or another path, where Extended Events temp files can be saved.

For non-SysAdmin users, create the Extended Events folder on the monitored SQL Server before continuing.

Save the job and repeat

At the end, customize all alert settings and save the job. Repeat the same process for every server you wish to monitor.

How to create a SQL Server monitoring job

Full walkthrough of the Create Monitoring wizard, thresholds and notifications.