Templates
Uncategorized
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
Access and privileges:
9
Check the SQL Server privilege level
10
Clean up unused accounts
11
Restrict group access
12
Ensure login restrictions are applied
13
Review administrator settings
14
Data protection:
15
Encrypt sensitive data files
16
Remove unnecessary shared folders
17
Server security:
18
Disable all protocols except TCP/IP
19
Configure server ports
20
Events logs:
21
Check SQL Server login audit
22
Check system event log configuration
23
Check SQL Server triggers
24
Create a new SQL Server Audit
25
Flag the server for restart
26
Sources:
27
Related checklists: