Hey guys,
quick question to the remote sql installation:
I've found this solution:
"Set a new Group policy to grant the user with proper permission to access and view the service.
Please perform the following steps on the domain controller.
1. Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
2. Find and locate the organizational unit which contains the user, Right-click on it and click Properties
3. Click the Group Policy tab, and then click New, or find existing policy. Type a name for the new Group Policy object (for example, use the name of the organizational unit for which it is implemented), and then press ENTER.
4. Click the new Group Policy object in the Group Policy Objects Links list (if it is not already selected), and then click Edit.
5. Expand Computer Configuration -> Windows Settings -> Security Settings -> System Services
6. In the right pane, double-click the target service to that you want to apply permissions. The security policy setting for that specific service is displayed.
7. Click to select the "Define this policy setting" checkbox.
8. Click "Edit Security"
9. Add the user account and grant it with "Start, stop and pause" and "Read" permissions to the user account that you want to access the service remotely, and then click OK.
10. Under "Select service startup mode", click "Automatic" startup mode option, and then click OK.
11. Close the Group Policy Object Editor, click OK, and then close the Active Directory Users and Computers tool.
12. Please run "gpupdate /force" on both the DC and the client to make the GPO settings come into effect.
13. Reset the problematic client and then check if the issue can be resolved."
What i need to know is, which service do i need to enable / give the user the permissions here?
"6. In the right pane, double-click the target service to that you want to apply permissions. The security policy setting for that specific service is displayed."
what is the name of the specific service? i dont see a sql service here as this probably targets the domain controller and not the sql server
thank you in advance