Surface Area Configuration in SQL Server 2008

I got an email from one of my reader and He is asking me that where is SAC in SQL Server 2008. Microsoft has removed the Surface Area Configuration tool that was shipped in SQL Server 2005. The Services and Connections which were previously managed using Surface Area Configuration tool is now managed using the SQL Server Configuration Manager.

To manage the database engine features you have to use Policy Based Management. For that you have to use Surface Area Configuration facet.

You can follow below steps to configure the Database Engine features.

  1. Right Click on Server Name and Select Facets from pop up windows
  2. Select “Surface Area Configuration” from facets windows and do the appropriate desired settings

Thanks for the comment, will get back to you soon... Jugal Shah

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s