If this is your first time using Add2Exchange or you are upgrading or migrating, post here.

1/22/2014 11:02:56 AM
Gravatar
Total Posts 2

Remote SQL Installation

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

1/22/2014 11:05:20 AM
Gravatar
Total Posts 159

Re: Remote SQL Installation

true, it is that remote instance of SQL Service you need to grant access to

1/23/2014 3:01:21 AM
Gravatar
Total Posts 2

Re: Remote SQL Installation

hi,

 

thanks for the quick response!

what is the name of the service? i dont see a sql service there - the only listed services are the services running on the exchange server (where the program would be installed) and there is no sql server installed locally.

1/23/2014 9:09:59 AM
Gravatar
Total Posts 159

Re: Remote SQL Installation

Normally  you don't have to do this, so setting this is an exception, any you have to be able to test the remote service called SQL SERVER and your instance.  .

You get into this kind of issue if you didn't let the program create a new instance of the database within your existing sql server. If you created our database within your instance, then you would specify the main instance and have to give owner/creator permissions to the main SQL database instance. Let's take a closer look at this though support: http://support.diditbetter.com/support-request.aspx

Live Help for Exchange Sync