SQL 2005 Surface Area Configuration
Posted on 2009-04-23
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