916

Product Name

Event ID

916

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

NOTUSER

Message Text

The server principal ”%.*ls” is not able to access the database ”%.*ls” under the current

security context.

The login does not have sufficient permissions to connect to the named database. Logins that

can connect to this instance of SQL Server but that do not have specific permissions in a

database receive the permissions of the guest user. This is a security measure to prevent users

in one database from connecting to other databases where they do not have privileges. This

error message can occur when the guest user does not have CONNECT permission to the

named database and the trustworthy property is not set. This error message can occur when

the guest user does not have CONNECT permission to the named database.

When CONNECT permission to the msdb database is denied or revoked, SQL Server

Management Studio can receive this error when Object Explorer tries to show the Policy Based

Management status of each database. Object Explorer uses the permissions of the current

login to query the msdb database for this information, which causes the error. The following

error message also occurs:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

ﾉ

Expand table