Home > Uncategorized > Specified owner name 'dbo' either does not exist or you do not have permission to use it

Specified owner name 'dbo' either does not exist or you do not have permission to use it

I found this error when I try to get or insert into Microsoft Dynamics Great Plains through eConnect.

Problem: {System.Data.SqlClient.SqlError: Specified owner name ‘dbo’ either does not exist or you do not have permission to use it.} object {System.Data.SqlClient.SqlError}

Solution: First of all domain user should be added in your SQL Server Logins. Give db_owner Role to that domian user in SQL Server through which you give call to SQL Server via eConnect, this is the same user through which you install eConnect service when installing eConnect. I found it as a one time problem you can revert it after the sucessful calls of all entities, probebly first time it is create some db object for which it requires some extra previllages, this is the same user with which you install eConnect service and your GP transaction are done by this user.

, ,

Comments are closed.

TOP