SQL Server 2005 Surface Area Configuration Tool

SQL Server 2005 Surface Area Configuration Tool

An important security improvement in Microsoft SQL Server 2005 is that various of its features that could be potentially susceptible to security risks are turned off by default.

One of these features is that the built-in administrator of the machine on which SQL Server 2005 is installed, it is not automatically included in the SQL Server Administrators (SysAdmin role).

In the case you want to change this setting, you have to use the SQL Server 2005 Surface Area Configuration tool.

This tool can be found within the “Microsoft SQL Server 2005” program group (Configuration Tools –> SQL Server Surface Area Configuration) in Start Menu –> Programs.

When running the tool, you have to select “Add New Administrator“. Then you will be presented the available SQL Server privileges which you can grant to your Windows user. Such privileges can be SQL Server SysAdmin role, Analysis Services Administrator role, etc.

Additionally you can use the Surface Area Configuration Tool for SQL Server Services, Connections and Features.

In SQL Server 2008 the Surface Area Configuration tool has been removed. The features of the tool have been replaced and enhanced by the powerful Policy-Based Management features.

A future post will explain in detail the Policy-Based Management Framework in SQL Server 2008.

For more information on using Policy-Based Management in Microsoft SQL Server 2008 you can visit the following Microsoft TechNet link:

http://technet.microsoft.com/en-us/library/bb510667.aspx

Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Artemakis's official website can be found at aartemiou.com.