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

05-24-2019 01:36 PM
Esri Contributor


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?


Diego Llamas

George Thompson

Tags (2)
0 Kudos
3 Replies
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... 

0 Kudos
New Contributor
0 Kudos
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