Home » cannot use the special principal 'dbo'

cannot use the special principal ‘dbo’

SQL Server Error : 15517, Severity: 16. Cannot execute as the database principal

SQL Server Error : 15517 Details

SQL Server Error: 15517 Severity: 16 Event Logged or not: No Description: Cannot execute as the database principal because the principal “%.*ls” does not exist, this type of principal cannot be impersonated, or you do not have permission. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1,
Read the rest