Implementing Fastpath’s Assure Suite: Run minimum permissions script

FastpathThis post is part of the series on Implementing Fastpath's Assure Suite.

One of the components of the installation of Assure Suite is the Hybrid Connector; this is what allows the Fastpath Assure portal to communicate with the on-premise Dynamics GP databases. Before we can install the Hybrid Connector, we need to create the SQL login which it will use to connect and provide the required permissions.

Fortunately, Fastpath provide a GPHybRidGrants.sql script which both creates the login and assigns the minimum level of permissions required for the Hybrid Connector to connect. The script is available via a link on one of the emails sent by Fastpath.

GPHyrbidGrants.sql

There are three variables in the script to change which you can do with a global find and replace:

  • dbreplace which is the GP system database (called DYNAMICS by default).
  • userreplace which is the SQL login to be created.
  • pwdreplace which is the password for the SQL login.

Once the script has been run, the Hybrid Connector can be installed which I will be doing in the next post.

Click to show/hide the Implementing Fastpath's Assure Suite Series Index

Implementing Fastpath’s Assure Suite
Implementing Fastpath's Assure Suite: Who are Fastpath?
Implementing Fastpath's Assure Suite: What is Assure Suite?
Implementing Fastpath's Assure Suite: Pre-installation steps
Implementing Fastpath's Assure Suite: Sign Into Support Portal
Implementing Fastpath's Assure Suite: Download Assure Suite
Implementing Fastpath's Audit Trail: Configuration
Implementing Fastpath's Identity Manager: Configure AD Settings
Implementing Fastpath's Assure Suite: Run minimum permissions script
Implementing Fastpath's Assure Suite: Install the Hybrid Connection Manager
Implementing Fastpath's Assure Suite: Configure Hybrid Connection Manager
Implementing Fastpath's Assure Suite: Setup cloud connection
Implementing Fastpath's Assure Suite: Schedule security import
Implementing Fastpath's Assure Suite: Schedule security import
Implementing Fastpath's Assure Suite: Schedule Audit Trails data collection
Implementing Fastpath's Audit Trail: Grant AT Access
Implementing Fastpath's Audit Trail: Select company to audit
Implementing Fastpath's Audit Trail: Select tables to audit
Implementing Fastpath's Audit Trail: Create Triggers
Implementing Fastpath's Audit Trail: Apply templates
Implementing Fastpath's Audit Trail: Apply triggers to other companies
Implementing Fastpath's Audit Trail: Transfer between systems
Implementing Fastpath's Assure Suite: Create new portal user
Implementing Fastpath's Assure Suite: Assign Permissions
Implementing Fastpath's Audit Trail: Ad hoc data collect
Implementing Fastpath's Audit Trail: Review data changes
Implementing Fastpath's Audit Trail: View reports