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

Question

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‌

GrigoryKuvshinnikov · Answer

USE [<dbname>]

GO

EXEC sp_changedbowner 'sa'

GO

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

George_Thompson · Answer

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

Do you have SYSADMIN granted to your login?

Asrujit_SenGupta · Answer

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