SQL Server Vulnerability Assessment in SQL Server Management Studio 17 or later lets SQL Server scan your databases for potential security vulnerabilities and it can be run against SQL Server 2012 or higher. If you are not using a new version of SQL Server Management Studio, you can download it from here.
The process is designed to meet the data privacy standards and compliance using knowledge base rules that look for deviations from Microsoft’s best practices. Using this you can improve your SQL Server’s security.
To run an assessment simply choose a database, right-click and choose Tasks. Here, you will see Vulnerability Assessment choose that and Scan for Vulnerabilities. If you have run one previously, you can access it here by choosing Open Existing Scan.
It will pop up a window to choose where you want the results saved. Once you click ok, the process will run.
The process is designed to meet the data privacy standards and compliance using knowledge base rules that look for deviations from Microsoft’s best practices. Using this you can improve your SQL Server’s security.
To run an assessment simply choose a database, right-click and choose Tasks. Here, you will see Vulnerability Assessment choose that and Scan for Vulnerabilities. If you have run one previously, you can access it here by choosing Open Existing Scan.
It will pop up a window to choose where you want the results saved. Once you click ok, the process will run.
Here, you can see my results from the "chat"database. It has 3 failed items and 52 have passed. It lists each item and assigns an appropriate risk level.
Clicking on one of the listed items under failed gives you more details and remediation steps with scripts to fix it. Let’s look.
In this example, I chose an easy one. You can see below it gives us a description of the best practice rule not followed.
SQL Server Vulnerability Assessment is a great non-third party starting place for evaluating data privacy, security and compliance standards.
Clicking on one of the listed items under failed gives you more details and remediation steps with scripts to fix it. Let’s look.
In this example, I chose an easy one. You can see below it gives us a description of the best practice rule not followed.
SQL Server Vulnerability Assessment is a great non-third party starting place for evaluating data privacy, security and compliance standards.
Comments
Post a Comment