Unable to fetch SQL services without administrator permissions
I tried below script to fetch services Get-Ciminstance -className win32_Service -OperationTimeoutSec 15 -ComputerName ‘xyz’
I got access denied error
For resolving above issue
- I have granted Remote Management Users to my account
- Given permission to class_32_Service to my account
After granting above permissions i am able to see services remotely with non admin account. Unfortunately i am not able to see SQL services as the need of own sddl permissions rights
Due to security issues i am unable to set sddl rights.
Hence is there any other solution to get the SQL services details without administrator rights.