Cannot execute as the de db principal, because the principal dbo does not exist.

1220
3
05-24-2019 01:36 PM
DiegoLlamas
Esri Contributor

Hello,

After upgrade database to 10.6.1 from 10.4 I was able give permission to user so they can see some layers. this sis SQL server 2014. After upgrade, I am able to access my DB but when I try to grant privileges to a user I got his error.

I know my username and password is correct because I can see my layers and use it as admin, editor or user.

I checked my DB and I can see my gisadmin user there with the correct privileges. What could it be?

Regards,

Diego Llamas

George Thompson

Tags (2)
0 Kudos
3 Replies
Asrujit_SenGupta
MVP Regular Contributor

During the upgrade, did you migrate to a different server? or to a different SQL Server instance?

The "GISADMIN" user has 'sysadmin' server role granted to it?

Error: Bad login user [Microsoft SQL Server Native Client 10.0: Cannot execute as the database princ... 

https://community.esri.com/thread/17312 

0 Kudos
GrigoryKuvshinnikov
New Contributor
0 Kudos
George_Thompson
Esri Frequent Contributor

I would agree with Asrujit on this what else was done besides the upgrade?

Do you have SYSADMIN granted to your login?

--- George T.
0 Kudos