Setting up a SQL Server Proxy Login

Before you import the Power Approvals solution package, you must create 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.

The Power Aprovals SQL Server proxy login does not require any special server roles. The default selection is public.

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. The proxy user must have access to the company database.
   • Mark the company database.
   • Mark the DYNGRP role.

You must mark each company database, and the DYNGRP role for that database, for all companies that will use Mekorma Power Apps.

8. 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).

9. Click OK to complete the process.