SQL 2008 surface area configuration

  • Hi all,

    Under SQL Server 2005, there was a tool called surface area configuration that was used for surface area reduction. I somehow can not find out this tool under SQL server 2008. I was wondering if anyone can give me a clue about where to find this tool.

    Regards

    Niyala

  • Introduced in SQL Server 2005, the Surface Area Configuration allowed you to enable or disable features which granted access to SQL Server components and configuration options.

    Beginning in SQL Server 2008, the Surface Area Configuration tool has been removed. The features of the Surface Area Configuration tool that control SQL Server behavior have been replaced and greatly enhanced in the Policy-Based Management feature. This feature enables you to create policies for SQL Server components and granularly apply them to principals and roles within SQL Server. For more information about the Policy-Based Management feature, see Administering Servers by Using Policy-Based Management.

    The connectivity management features of the Surface Area Configuration tool are available by using the Configuration Manager tool. For more information about this tool, see SQL Server Configuration Manager

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • The surface area configuration tool has been removed from SQL 2008 as a separate utility. You can now manage these things by using Policies. There's a facet called surface area configuration which you can use to create a policy.

    Another option is of course using sp_configure to apply the required settings.

    [font="Verdana"]Markus Bohse[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply