The specified schema name "dbo" either does not exist or you do not have permissions to use it.

... Cannot find the object 'taRequestorBrittenford...

 

This error is almost certainly related to the eConnect service user not being a sysadmin in the SQL Server. Take these exact steps.

 

Method 1:

1. Make the eConnect service user a sysadmin in the SQL Server temporarily

2. From the GP folder double-click the file BuildEConnectObjects.bat (install the latest version of EC/IC if this script does not exist) to recreate all needed SQL Server objects

3. If successful (runs without red text), you can now remove the sysadmin permissions from the eConnect service user (it will still need DYNGRP) permissions in DYNAMICS and all company databases

3a. If not successful (short circuits with red text), double check permissions and retry from step 1

 

Alternate Method 2:

1. Make the eConnect service user a sysadmin in the SQL Server temporarily

2. Delete the record from the table DYNAMICS..BEC000020 (DYNAMICS..BIC000020 for InvoiceConnect)

3. Do a full reinstall of EC including running as Administrator and logging in as sa

3. You can now remove the sysadmin permissions from the eConnect service user (it will still need DYNGRP) permissions in DYNAMICS and all company databases

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk