V-40941 – SQL Server 2012 Database Instance DISA STIGs

If you have any additional questions that aren’t addressed in the blog, feel free to contact me. I’d be more than happy to help you out!

V-40941

Title: “SQL Server must have the SQL Server Data Tools (SSDT) software component removed from SQL Server if SSDT is unused.”

Severity = High

Details = Review the list of components and features installed with the database. Using an account with System Administrator privileges, from Command Prompt, open control.exe.

Navigate to Programs and Features. Check for the following entries in the ‘Uninstall or change a program’ window.

Microsoft SQL Server Data Tools – Database Projects – Web installer entry point – Prerequisites for SSDT

If SQL Server Data Tools is not documented as a server requirement, and these entries exist, this is a finding.

FIX: Document the requirement for SQL Server Data Tools to reside on this server.

If your organization requires SSDT to be installed then just document that and close the finding.

If it is not required, using an account with System Administrator privileges, from Command Prompt, open control.exe.

Navigate to Programs and Features. Remove the following entries in the ‘Uninstall or change a program’ window.

Removing SSDT

Microsoft SQL Server Data Tools – Database Projects – Web installer entry point – Prerequisites for SSDT

Removing SSDT 2

Once you click NEXT, you can choose the SSDT checkbox and click NEXT to remove it.

Removing SSDT 3

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.