I have a project to remove admin rights from our users. An application we use, during upgrades, runs a query against WMI:
Namespace: root\Microsoft\sqlserver\computermanagement10 Class: sqlserviceadvancedproperty
Since I've removed admin rights from the user, it fails to return any data when querying that namespace and class and thus fails the install saying the appriopriate SQL Server version is not installed.
I've attempted adding permissions to the namespace from top to bottom and no luck. If I add admin rights back to the user account on the device, the query works again.
I'm using powershell to test:
gwmi -namespace root\Microsoft\sqlserver\computermanagement10 -class sqlserviceadvancedproperty
When I run this without admin rights, it doesn't give an error or anything at all. It just returns null and drops me back to the command prompt. Ran with admin rights, I get a whole heap of data.
Does anyone have any idea what specific items in Windows a user needs access to in order to be able to query a specific WMI namespace?