Sample Header Ad - 728x90

Trying to view database properties and getting a cannot impersonate `guest` error

1 vote
0 answers
787 views
One of my DBAs is trying to look at the database properties of a database by right clicking and selecting properties and is getting the following error: > Cannot show requested dialog. (SqlMgmt) > > An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) > > Cannot execute as the database principal because the principal "guest" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Microsoft SQL Server, Error: 15517) Points of interest: - The guest account has been disabled (no connect permission) - The DBA is a member of db_owner on the database, but not sysadmin on the instance. - He has this permission through a role, but does not have a user directly in the instance let alone the database. - This is a windows authenticated login. - I tried creating a SQL Id and testing but couldn't replicate. - The version of the instance is SQL Server 2016 (SP1) - 13.0.4001.0 (X64) - On Windows Server 2012 R2 Standard 6.3 What I don't understand is why he would be impersonating anything since he is a member of db_owner, particularly when trying to open the properties dialog. I've checked here: https://dba.stackexchange.com/questions/134026/cannot-execute-as-the-database-principal-because-the-principal-guest-does-not but the service account running the named account has sysadmin access so this shouldn't be a problem.
Asked by Kenneth Fisher (24317 rep)
May 3, 2018, 10:26 PM