PGP-GP Manufacturing integration - SQL Permissions error

PGP-GP Manufacturing integration - SQL Permissions error

Symptom

The GP Manufacturing integration (.cnk file) fails due to permissions in the PanatrackerGP database.

Solution

Grant the appropriate database permissions in SQL Server:

  1. Open SQL Server Management Studio.
  2. Find and double-click the user account.
  3. Select the User Mapping tab.
  4. Select the PanatrackerGP database.
  5. In the Database role membership section, check: - db_datawriter - db_datareader
  6. Apply the changes.

    • Related Articles

    • PGP-GP Manufacturing integration - SQL Permissions error

      Symptom The GP Manufacturing integration (.cnk file) fails due to permissions in the PanatrackerGP database. Solution Grant the appropriate database permissions in SQL Server: Open SQL Server Management Studio. Find and double-click the user account. ...

    • PGP-GP Manufacturing integration - SQL Permissions error

      Symptom The GP Manufacturing integration (.cnk file) fails due to permissions in the PanatrackerGP database. Solution Grant the appropriate database permissions in SQL Server: Open SQL Server Management Studio. Find and double-click the user account. ...

    • Manufacturing integration .cnk setup in Dynamics GP

      To use transactions for GP Manufacturing, a .cnk file needs to be installed and additional configuration completed within GP. GP Manufacturing requires a dedicated desktop with GP open to process transactions. Install Instructions Open and run ...

    • Finding your version number for PGP and GP Manufacturing integration

      You can find the Panatrack Manufacturing version number in Dynamics GP. Steps In Dynamics GP, navigate to Microsoft Dynamics GP > Help > About Microsoft Dynamics GP. Accessing the About dialog from the Help menu The Panatrack Manufacturing version is ...

    • Finding your version number for PGP and GP Manufacturing integration

      You can find the Panatrack Manufacturing version number in Dynamics GP. Steps In Dynamics GP, navigate to Microsoft Dynamics GP > Help > About Microsoft Dynamics GP. Accessing the About dialog from the Help menu The Panatrack Manufacturing version is ...