topic Re: Cannot execute as the de db principal, because the principal dbo does not exist. in Geodatabase Questions

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

DiegoLlamas — Fri, 24 May 2019 20:36:11 GMT

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‌

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

Asrujit_SenGupta — Sun, 26 May 2019 04:21:02 GMT

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 principal because the pri…

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

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

George_Thompson — Tue, 28 May 2019 14:01:29 GMT

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

Do you have SYSADMIN granted to your login?

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

GrigoryKuvshinnikov — Wed, 03 Mar 2021 18:04:30 GMT

USE [<dbname>]

EXEC sp_changedbowner 'sa'

https://stackoverflow.com/questions/13823354/sql-server-principal-dbo-does-not-exist