GP Manufacturing - SQL Permissions error

GP Manufacturing - 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

    • GP Manufacturing Setup

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

    • SQL Error is displayed: OpenAccessException

      Symptom "OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATEDATABASE Panatracker'; already exists." Cause This error occurs after the Panatracker transaction database has been modified or moved. The Panatracker SQL ...

    • Manufacturing User Guide

      Download the Manufacturing User Guide from the attachments tab.

    • SQL Errors while running MO Receipt Entry automation

      Symptom When MO Receipt Entry automation runs in Dynamics GP, you receive one or more of the following error messages related to a constraint error in older SQL tables for Manufacturing automation: (Panatrack) GPS Error: 65 GPS Error 65 dialog ...

    • Manufacturing Configuration

      Configure PanatrackerGP to work with GP Manufacturing, Vicinity Manufacturing, or Horizon Manufacturing. These settings control how component issues and finished goods receipts are recorded. GP Manufacturing requires a .cnk file installed and ...