SQL Server 2005 Surface Area Configuration Tool

SQL Server 2005 Surface Area Configuration Tool

Share on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0Share on Reddit0
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


Recommended eBooks on SQL Server:

Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, Software Developer and a Microsoft Data Platform MVP. He has over 15 years of experience in the IT industry in various roles. Among other, via his initiative SQLEBooks.com, Artemakis authors and publishes eBooks on different topics 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). Additionally he is the founder of the SQLArtBits initiative that aims to provide the technical community with simple, yet powerful and high-quality SQL Server tools. Currently, the highlights of these tools are DBA Security Advisor and In-Memory OLTP Simulator. Artemakis's official website can be found at aartemiou.com. Artemakis's blogs can be found at: SQLNetHub.com and TechHowTos.com.