Thursday, 2 February 2017

Cannot alter the role ‘db_Owner’, because it does not exist or you do not have permission

You may have experienced the issue whereby you see the error

Cannot alter the role ‘db_Owner’, because it does not exist or you do not have permission

Infact this can be any role... the problem can occur when the role name is specified in the wrong case and the SQL server is using a case-sensitive collation, in this example the role should be 'db_owner' rather than ‘db_Owner’.



No comments:

Post a Comment