SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation

Microsoft has turned off all the potential features of SQL Server 2005 that could be susceptible to security risks and hacker attacks. Many features of SQL Server 2005 i.e. xp_cmdshell, DAC etc comes disabled by default, this makes the vulnerable surface area less visible to potential attacks. The Surface Area Configuration tool provides DBAs with a single, easy-to-use method of configuring external security of SQL Server. Use SQL Server Surface Area Configuration to enable, disable, start, or stop the features, services, and remote connectivity of your SQL Server 2005 installations. You can use SQL Server Surface Area Configuration on local and remote servers.

Following are the features of the SQL Server Surface Area Configuration Tool, which can be turned on and off as needed by application.

Analysis Services Features

  • Ad-hoc Data Mining Queries
  • Anonymous Connections
  • Linked Objects
  • User-Defined Functions

Database Engine Features

  • Ad-hoc Remote Queries
  • CLR Integration
  • Database Mail
  • HTTP Access
  • OLE Automation
  • Service Brokerenables
  • SMO and DMO
  • SQL Mail
  • Web Assistant
  • xp_cmdshell

Reporting Services Features

Solarwinds
  • HTTP and Web Service Requests
  • Scheduled Events and Report Delivery

Following are the services of the SQL Server Surface Area Configuration Tool, which can be turned on and off as needed by application. Not all services are available in all the edition of SQL Server.

  • Analysis Services
  • Database Engine
  • Full-Text Search Service
  • Integration Services Service
  • MSSQLServerADHelper Service
  • Notification Services Service
  • Reporting Services Service
  • SQL Server Agent Service
  • SQL Server Browser Service
  • SQL Server Writer Service

Following diagrams explains the methods to enable the features and services using SQL Server Surface Area Configuration Tool.

1) On the Start menu, point to All Programs, Microsoft SQL Server 2005, Configuration Tools, and then click SQL Server Surface Area Configuration.

SQL SERVER - 2005 - SQL Server Surface Area Configuration Tool Examples and Explanation sacsmall

2) Click the change computer link adjacent to Configure Surface Area for. The default value is localhost. This can be changed and connected to any other SQL Server node.

SQL SERVER - 2005 - SQL Server Surface Area Configuration Tool Examples and Explanation sac1

SQL SERVER - 2005 - SQL Server Surface Area Configuration Tool Examples and Explanation sac2

3) After selecting the computer to configure, you can launch either of services.

  • Surface Area Configuration for Services and Connections

SQL SERVER - 2005 - SQL Server Surface Area Configuration Tool Examples and Explanation sac3

SQL SERVER - 2005 - SQL Server Surface Area Configuration Tool Examples and Explanation sac4

  • Surface Area Configuration for Features

SQL SERVER - 2005 - SQL Server Surface Area Configuration Tool Examples and Explanation sac5

SQL SERVER - 2005 - SQL Server Surface Area Configuration Tool Examples and Explanation sac6

Reference : Pinal Dave (https://blog.sqlauthority.com) , BOL, All the image are protected by copyright owned by SQLAutority.com

Solarwinds
,
Previous Post
SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards
Next Post
SQL SERVER – Three Rules to Use UNION

Related Posts

20 Comments. Leave new

  • Full Text Indexing and security at the file level?

    We have some FULL Text indexes on semi-sensitive datacolumns – and info could be gleaned from looking for just specific words (presense or absence of them).

    I have not found anything that tells me how concerned I should be (or not be) with locking down the files from being seen/read/copied.

    They are binary, to my basic editor, but are they readablehackable?

    Also are there any stats on how much overhead is involved in the maintenance of a FULL Text index on a table that is updated frequently?

    Reply
  • I’m using Vista Home Premium and I installed already MS SQL Server 2005 in it and also the SQL Server Management Studio Express.

    I need to enable remote connections in order to succesfully connect to my local database and I can do that by going to SQL Server Surface Area Configuration. But after installing all these (also SQL Server 2005 SP2) I can’t find that option. Did I missed something?

    Only the SQL Error and Usage Reports Settings appears under the Configuration Tools.

    Reply
  • I have a problem like this at the moment.
    Please send me your quick advice.

    Reply
  • make sure you have installed SQL Server 2005 Express Edition as well as the Management Studio Express. At first I thought MSE included SQL Server but it doesn’t, once both are installed the start menu icons you’re missing will appear.

    Reply
  • I am helping a friend that has a log file that is 16gb. When i went to use the surface config tool in sql 2005, it is simply not there. how do i install this feature? thanks for your help!

    Reply
  • Thanks for taking the time to write-up this fix.
    We had just done an upgrade from SQL 2005 Eval to SQL 2005 Std and I would have been spinning my wheels trying to resolve what I thought were upgrade issues.

    Reply
  • I am getting ‘failed to connect localhost\ACT7 (Microsoft.sqlserver.connectioninfo)’ and not able to login when i am clicking ‘surface area configuration for features’. Please help me. Thanks

    Reply
  • hi i have sql server 2005 in my pc.I am getting the following error while click on surface area configurations for services and connections,computer cannot be configured remotely make sure remote computer has windows instrumentation management and try again.wats this?

    Reply
  • Ganesh,

    I have done database on server 2003, but the same is not working on client machine, showing error : sqlserver not supporting.

    kindly advise

    Reply
  • hello, each time I try to launch SQL Server 2005 – Surface Area Configuration For Services and Connections I get the following error listed below, how can I resolve it?

    C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (Microsoft.SqlServer.Smo)

    Reply
  • This was a great wizard-based tool. How is the same managed in SQL Server 2008? Anything new in R2?

    Reply
  • hey give me pass my email here sql server 2005 area configuration tool plzzz??????????????/

    Reply
  • Imran Mohammed
    June 5, 2010 9:40 am

    @Alvin

    Surface Area Configuration Tool is installed as part of SQL Server Client tools in any edition of SQL Server (2005 and 2008), not for SQL Server 2000.

    If you have installed SQL Server Client Tools, then follow below path to open Surface Area Configuration Manager.

    Start – All Programs – Microsoft SQL Server 2008 – Configuration Tools – Surface Area Configuration Manager.

    ~IM.

    Reply
  • Please help me! Thank you very much!
    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database “db_quanlihocvien” requested by the login. The login failed.
    /qlhv/Untitled-4.asp, line 5

    Reply
  • Thank you for such a good site that has very good info…I was able to connect to my database again…

    Reply
  • Lots of thanks to help …..With good Explanation

    Reply
  • Thanks for the update. Do you know if these values that are set in the Surface Area Configuration are reflected in a registry value of sorts? Can I obtain this information elsewhere without having to execute the SAC?

    Reply
  • i installed sql server 2005 but the surface area configuration is not coming i tried it several times what is the resolution for this….? please help me

    Reply
  • Hey team,

    This is the error I am receiving when launching Surface Area Configuration for Services and Connections in SQL Server 2005:

    ===================================

    Index was outside the bounds of the array. (SQLSAC)

    ——————————
    Program Location:

    at Microsoft.SqlSac.MainPanel.FormServicesAndProtocols.AddNotificationServiceByInstance()
    at Microsoft.SqlSac.MainPanel.FormServicesAndProtocols.InitInstanceView()
    at Microsoft.SqlSac.MainPanel.FormServicesAndProtocols.ProcessClassConstructor()

    Reply
  • Hi,

    I’m have followed these insructions and and another page that walks enable remote connection to SQL Server 2005 Express. I’m still having trouble accessing my work database from home. I had read somewhere about making sur the port was set but haven’t come across where I do that. If anyone could help that would be great.

    Reply

Leave a Reply

Menu