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”
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