Skip to main content

Posts

Showing posts with the label SQL Server Vulnerability Assessment

SQL Server Vulnerability Assessment

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. Here, you can see my results from the "chat"database. It has 3 failed items and 5...