A SQL Server proxy login is a security principal, or entity that can be authenticated by Mekorma PowerApprovals application via the SQL Server cloud connector to access Microsoft Dynamics GP databases and run PowerApprovals 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.

To create a SQL Server login for Mekorma PowerApprovals, follow these steps:

If you are going to use a domain account as your PowerApprovals proxy account, contact your system administrator. We recommend setting up an identifiable account, i.e. domain\PowerApprovalsProxy

  1. In Object Explorer, expand the folder of the server instance in which you want to create the new login.
  1. Expand the Security folder. Right-click on Logins and choose New Login…
  1. In the Login – New dialog box, on the General page, enter the name of a user in the Login name box.


    Alternately, click the Search… button to open the Select User or Group dialog box. If you click the Search… button:
    1. Under Select this object type, click Object Types… to open the Object Types dialog box and select any or all of the following: Built-in security principals, Groups, and Users. Built-in security principals and Users are selected by default. When finished, click OK.
    2. Under From this location, click Locations… to open the Locations dialog box and select one of the available server locations. When finished, click OK.
    3. Under Enter the object name to select (examples), enter the user or group name that you want to find. For more information, see Select Users, Computers, or Groups Dialog Box.
    4. Click Advanced… for more advanced search options. For more information, see Select Users, Computers, or Groups Dialog Box – Advanced Page.
    5. Click OK.
  1. To create a login based on a Windows principal, select Windows authentication. This is the default selection.
  1. To create a login that is saved on a SQL Server database, select SQL Server authentication.
    1. In the Password box, enter a password for the new user. Enter that password again into the Confirm Password box.
    2. When changing an existing password, select Specify old password, and then type the old password in the Old password box.
    3. To enforce password policy options for complexity and enforcement, select Enforce password policy. For more information, see Password Policy. This is a default option when SQL Server authentication is selected.
    4. To enforce password policy options for expiration, select Enforce password expiration. Enforce password policy must be selected to enable this checkbox. This is a default option when SQL Server authentication is selected.
    5. To force the user to create a new password after the first time the login is used, select User must change password at next login. Enforce password expiration must be selected to enable this checkbox.
      p(banner tip). This is a default option when SQL Server authentication is selected, however it is recommended that this option remains disabled
  1. From the Default database list, select a default database for the login. We recommend you default this to the Microsoft Dynamics GP system database – DYNAMICS for default installations of Microsoft Dynamics GP.
  1. Click OK.
Last modified: Oct 09, 2020

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment