Bulletin ID A2E_220
Last Review 01/05/2024
Revision 1.0
Previous IDs None
Obsoletes None
—————— ————
Permissions needed for adding the A2E sync service account to an existing remote SQL instance
DidItBetter.com Software has prepared a release of Add2Exchange Enterprise which will allow the Add2Exchange database to be installed and managed on an existing, non-local SQL Server instance. if you are moving the Add2Exchange SQL database to a remote server, then these procedures will apply. Add2Exchange will support single or clustered SQL Server configuration. These instructions show how to add the service account user to the remote SQL instance so it can create its database during the installation process.
Tip:
We suggest you download and install the SQL Management Studio Tools on the replication server to help with the configuration. This step is not required, but certainly makes life easier and will save you time and effort since you can manage the instance from here if need be. The current SMS is available from the Diditbetter Support Menu.ps1 (powershell utilities) run as Powershell.
Instructions
- Start Microsoft SQL Server Management Studio
- Use the Object Exporer to log onto the remote SQL server with a SQL SA administrative account.
- Expand the Security folder in the Object Explorer tree
- Right-click the Logins folder and select New Login…
- In the default General tab, for Login name either enter the name of the service account (by default
zAdd2Exchange) or click Search and find the service account from your Active Directory
- Leave the rest of the options on that page as default
- Click Server Roles from the Object Explorer
- Select dbcreator, db owner, connect as SA - In order for Add2Exchange to test the status of the remote SQL Server, you will need to grant the service account permissions to detect services on the remote SQL computer
Your SQL Server is now configured to allow the service account to complete the Add2Exchange installation.
References: http://msdn.microsoft.com/en-us/library/windows/desktop/ms685981(v=vs.85).aspx
Even more on Rights: http://serverfault.com/questions/55961/is-it-possible-to-use-group-policy-to-grant-the-permission-to-manage-windows-ser
Continue with the installation procedures.
Applies To
- Add2Exchange Enterprise Edition