Home » SQL Server » Surface Area Configuration tool available in SQL Server 2008 & onwards

Surface Area Configuration tool available in SQL Server 2008 & onwards

Surface area configuration is a security measure that involves stopping or disabling unused components. Surface area configuration helps to improve security by providing fewer avenues for potential attacks on a system.

Surface Area Configuration too is introduced in SQL Server 2005 & Direct access of Surface Area Configuration tool has been removed from SQL server 2008 onwards.

To access Surface Area Configuration tool from SQL Server 2008 onwards :-

1) Right Click on SQL server instance in SSMS & Go to Facets

2) Select “Surface Area Configuration” facet & have access of hidden Surface Area Configuration tool


1 Comment

  1. An outstanding share! I’ve just forwarded this onto a co-worker who was conducting a little homework on this. And he in fact bought me lunch because I stumbled upon it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanx for spending the time to discuss this issue here on your website – Surface Area Configuration tool available in SQL Server 2008 ….

Leave a Reply

%d bloggers like this: