Templates
Quality Assurance
SQL Server Audit Checklist
SQL Server Audit Checklist

SQL Server Audit Checklist

Run this checklist as part of a routine SQL Server Audit to ensure compliance standards are met.
1
Introduction:
2
Preparation:
3
Record basic details
4
System maintenance:
5
Uninstall unused programs on Windows
6
Uninstall unused programs on Linux
7
Install latest service packs and patches
8
Approval:
9
Access and privileges:
10
Check the SQL Server privilege level
11
Clean up unused accounts
12
Restrict group access
13
Ensure login restrictions are applied
14
Review administrator settings
15
Approval:
16
Data protection:
17
Encrypt sensitive data files
18
Remove unnecessary shared folders
19
Approval:
20
Server security:
21
Disable all protocols except TCP/IP
22
Configure server ports
23
Approval:
24
Events logs:
25
Check SQL Server login audit
26
Check system event log configuration
27
Check SQL Server triggers
28
Create a new SQL Server Audit
29
Flag the server for restart
30
Approval:
31
Sources:
32
Related checklists: