Setting up a SQL Server Proxy Login

A SQL Server proxy login is a security principal, or entity that can be authenticated by Mekorma Power Approvals via the SQL Server cloud connector to access Dynamics GP databases and run Power Approvals server-side business logic. You can create a login based on a Windows principal (such as a domain user) or you can create a native SQL Server login.

If you are going to use a domain account as your Power Approvals proxy account, contact your system administrator. Mekorma recommends setting up an identifiable account, such as domain\PowerApprovalsProxy. To create a SQL Server login for Mekorma Power Approvals, follow these steps:

1. Launch Microsoft SQL Server Management Studio and log in as the ‘sa’ user.
   

2. In Object Explorer, expand the folder of the server instance in which you want to create the new login.
3. Expand the Security folder. Right-click on Logins and choose New Login.
   

4. Create the user as shown below.
   
   1. Login Name = MekormaProxy
   2. Mark SQL Server authentication
   3. Unmark Enforce password policy
   4. Default database = DYNAMICS
5. In the left-hand navigation pane, navigate to User Mapping.
6. The proxy user must have access to Dynamics GP’s system database.
   • Mark the system company. Typically, this is DYNAMICS, but it may be named something else.
   • In the lower section, Database Role Membership, mark DYNGRP.

7. Repeat steps 1-6 for each company that will use Mekorma Power Apps.
   • Mark the company database
   • Mark the DYNGRP role
8. Once complete, you should have something similar to the screenshot below:
   

9. In the example above, we have many Dynamics GP companies; however, we are restricting access to only the LIVE1 and PROD1 companies. These are the two companies that will be using the Mekorma Power Apps product(s).
10. Click OK to complete the process.