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
Open the wizard
Navigate to Menu → Create SQL Server Monitoring Job.
- 2
Enter the instance
Enter your SQL Server name.
- 3
Choose Windows Authentication
Select Windows Authentication as the connection type.
Step 2: Authenticate the domain user
- 1
Enter credentials
Enter the domain user credentials.
- 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.
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.
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.
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.
