Where is “SQL server Surface Area configuration” in SQL Server 2008 R2 ?

Hello friends,

Many times you need to do SQL Server related configuration like, CLR enable, Xp_cmdShell, Remote Access etc.

 I am able to set this configuration in SQL server 2005 using “SQL server Surface Area configuration”. But I was surprised when I did not find this exe in SQL Server 2008 R2.

After little research I found how to get this “SQL Server Surface Area Configuration” in SQL server 2008 R2.

Step 1:- Right click the SQL Server 2008 Server in SQL Server Management Studio.

 Step 2:- Choose option “Facets

Image

 Step 3:- You will get below screen. You just need to select “Surface Area Configuration” option from dropdown.

Step 4:- Once you have selected the “Surface Area Configuration “ then you will get following screen.

 

So now it is good to go and configure your setting.

Thanks & Best Regards

Rajat Jaiswal