Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you try to run an integration by using a Microsoft Dynamics GP eConnect destination adapter in Integration Manager for Microsoft Dynamics GP: "DOC X ERROR: eConnect error – The stored procedure [procedure_name] doesn't exist"

Error message when you try to run an integration by using a Microsoft Dynamics GP eConnect destination adapter in Integration Manager for Microsoft Dynamics GP: "DOC X ERROR: eConnect error – The stored procedure [procedure_name] doesn't exist"

Symptoms

When you try to run an integration by using a Microsoft Dynamics GP eConnect destination adapter in Integration Manager for Microsoft Dynamics GP, you receive the following error message:
DOC X ERROR: eConnect error – The stored procedure procedure_name doesn’t exist.
Note In this error message, procedure_name is a placeholder for the name of the eConnect SQL stored procedure that is used in the integration.

↑ Back to the top

Cause

This problem occurs because the user account that is specified in the eConnect 10 for Microsoft Dynamics GP Microsoft COM+ component does not have the required permissions for the Microsoft Dynamics GP databases in Microsoft SQL Server.

↑ Back to the top

Resolution

The user account that is specified in the eConnect 10 for Microsoft Dynamics GP COM+ component must be a member of the DYNGRP role for the DYNAMICS database and for the company databases in SQL Server. This user account must be a member of the DYNGRP role to have the Execute permission for the required eConnect SQL stored procedures.

To determine which user account is specified in the eConnect 10 for Microsoft Dynamics GP COM+ component, follow these steps:
  1. Click Start, click Run, type dcomcnfg in the Open box, and then click OK.
  2. In Component Services, expand Component Services, expand Computers, expand My Computer, and then expand COM+ Applications.
  3. Right-click eConnect 10 for Microsoft Dynamics GP, and then click Properties.
  4. Click the Identity tab.

    The user account that is configured under This user is the user account that connects to SQL Server.

↑ Back to the top

Keywords: kbnosurvey, kbexpertiseadvanced, kberrmsg, kbmbspartner, kbexpertisebeginner, kbtshoot, kbmbsmigrate, kbprb, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 951775
Revision : 1
Created on : 3/3/2017
Published on : 1/17/2015
Exists online : False
Views : 81