eConnect Error: Cannot Find a Stored Procedure in the Microsoft Dynamics GP Database

Hello:

When using eConnect for GP 2010 to import Project Accounting projects into the Project Cards, I get an error that says, "The stored procedure taPAProjects doesn't exist."

But, we took a look in the company database in SQL.  Indeed, this stored procedure is there.  How can we convince eConnect of that?

Thanks!  Much appreciated!

TBSupport
LVL 1
TBSupportAsked:
Who is Participating?
 
Steve EndowConnect With a Mentor Microsoft MVP - Dynamics GPCommented:
Hi,

I have run into this error before.

There are three possible reasons that I'm aware of for this error, and there may be others.  Do you have any other eConnect integrations that work properly for this particular database?


First, you should output / display your eConnect connection string to double check that you are sending the correct SQL instance name and correct database name.

Data Source=SERVERNAME;Initial Catalog=COMPANYDB;Integrated Security=SSPI


Next, verify that the company database DYNGRP role includes EXEC access to the stored procedure


If that looks correct, open SQL Server Management Studio, expand Security -> Logins and locate the eConnect login, then double click on the eConnect login.

Select the User Mapping page.  Verify that the Default Schema is set to "dbo" for all of the mapped GP databases.  If there is a Default Schema other than dbo for any of the databases, you will need to delete the eConnect user schema from all databases, and then delete the eConnect SQL login.  You can then re-created the eConnect login and users, making sure that the Default Schema is dbo.

Please let me know one of these seems relevant to your issue.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
eConnectLoginSchema.jpg
0
 
TBSupportAuthor Commented:
Hi Steve:

Yes, the client did not have the correct DSN being used.  Therefore, I was not connecting to the correct server nor the correct database.

Thanks, so much!

TBSupport
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.