No Surface Area Configuration Tool in SQL Server 2008 – Facets!

Ive never been a big user of the SAC tool in SQL Server 2005. Always prefered to make the changed via sp_configure. However, on looking for it on one of our SQL Server 2008 instances, i couldnt find it. At first i thought it might be an incorrect installation issue, but on investigation it seems that the Surface area configuration tool has been deprecated!

The tool has now been divided up into different sections available via SSMS itself. In a way, this is where this tool should exist anyway, not as a seperate entity.

a) Instance and Database Engine Features:

This will now be done through SSMS (SQL Server Management Studio).  Right click on the instance and select Facets as shown in the image below:





And you can pick and choose what you want to confgure.  Surface Area configuration is one of the facets.  Another thing that you would note in the above image at the bottom right hand side is “Export Current State as Policy” – using this, one can then use that policy across the group in order to have a consistent environment.

And likewise, for the database parameters, you right click on the database in question and select facets and will get a similar screen where you can set the parameters for the database:

Connections, Protocols and StartUp options:

These are done via the SQL Server Configuration Manager.  This remains the same as before.

Advertisements

One Response to No Surface Area Configuration Tool in SQL Server 2008 – Facets!

  1. Someone essentially assist to make severely posts
    I would state. That is the first time I frequented your website page and up to now?

    I amazed with the research you made to make this actual submit amazing.

    Fantastic task!

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

%d bloggers like this: