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
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?
USE [<dbname>]
GO
EXEC sp_changedbowner 'sa'
GO
https://stackoverflow.com/questions/13823354/sql-server-principal-dbo-does-not-exist
I would agree with Asrujit on this what else was done besides the upgrade?
Do you have SYSADMIN granted to your login?