SQL Server Error : 916, Severity: 14. The server principal “%.*ls” is not able
SQL Server Error : 916 Details
SQL Server Error: 916 Severity: 14 Event Logged or not: No Description: The server principal “%.*ls” is not able to access the database “%.*ls” under the current security context. Severity 14 Description: Indicates security-related errors, such as permission denied.
Accessing the SQL server database using SQL Server Management Studio with a limited number of permissions (database read or write) may result in SQL Server Error 916, with the message “The server principal username is unable to access the database database name under the current security context.”
Reason or Cause of error
The login lacks the necessary permissions to connect to the specified database. Logins … Read the rest