SQL Server permissions error
Hi,
I have an AD account that i created and added to SQL Server Logins. It mapped it to a database with datareader role. Later I setup the account to have Execute permissions on a schema. When i go to the schema properties in the database(Security > Schemas) and select 'Effective' under permissions, I see this message:
*Cannot execute as the server principal because the principal "" does not exist, this type of principal cannot be impersonated, or you do not have permission.*
I have checked that it is not a orphaned login.
Users part of that AD group cannot access the objects part of the schema and they get the error message:
*The EXECUTE permission was denied on the object '', database 'ABC', schema ''.*
Can you please help in understanding what is happening and fix this?
Have a look on this:
https://dba.stackexchange.com/questions/159514/sql-server-error-cannot-execute-as-the-database-principal-because-the-princip Hope this works for you
Thanks Jason. I can see that the SQL User is associated with the login and the login exists at the server level as well and they are linked.
Try the following: Check the Schema owner for the schema in question: Schema > Properties With that owner name use the Database in question and try running the following query: select suser_sname((select sid from sys.database_principals where name = N'******')); Does this return a result? If no result is returned then I believe this may be the issue.
