SQL 2005 Surface Area Configuration

Posted on 2009-04-23
Last Modified: 2012-05-06

Windows 2003 ENT SP2 R2 x64
MS Cluster Services (2-node)
SQL 2005 ENT SP2 x64

Possibly a straight forward answer.
Everything is setup and working 100%.

Problem I am having is opening SQL Surface Area Configuration with a user that is not an administrator but does have SYSADMIN role within SQL?

***I connect to 'remote' server - The virtual cluster name for SQL***

SQLSAC works absolutely fine when opened with a user who is administrator.

The error I get is:

"Computer XYZ does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentations components and then try again."

I am thinking it has to be in the WMI security permissioning? I have checked, WMIMGMT.msc and the security but I though I would like to see what others may think before I go playing with the WMI permissioning.

As a secondary note, in SQL Server Configuration Manager, SQL Server 2005 Services has an error "The server threw an exception [0x80010105]".

As I say, this only affects users that are not administators (but have SYSADMIN role on SQL) so I do not want to have to test starting SQL browser etc.

Any help appreciated.


On a 2
Question by:BryanOakley

    Author Comment

    it may be possible that this is by design, in securing the config/management of MSCS and SQL 2005 you need to be local admin...

    LVL 39

    Accepted Solution

    The sysadmin role is something that you have within the database engine itself.  It doesn't mean that you have access to make changes to the physical server.  These things are not configured from within SSMS for a reason :).

    I can't explain the errors, but you have to be a local admin to modify the SAC.

    Author Closing Comment

    Hi BrandonGalderist

    Thanks for confirming what I thought may be the case... Certainly makes sense.
    I'll award the points, as you have confirmed this to be true :-)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now