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

About these ads

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 189 other followers

%d bloggers like this: