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?
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...
EXEC sp_changedbowner 'sa'
I would agree with Asrujit on this what else was done besides the upgrade?
Do you have SYSADMIN granted to your login?