Principle dbo does not exist in Sql Server

Question

While fetching data through a stored procedure in SQL Server I am getting error like

Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.

I am getting this error only for accessing a particular stored procedure, not for all SP's.

Answer 1

Give your database a valid owner. Try this:

ALTER AUTHORIZATION 
ON DATABASE::[YourDatabaseName]
TO [LoginUser];

or you can try to set it like

USE [dbname]
GO
sp_changedbowner 'someLogin'

Answer 2

ALTER AUTHORIZATION ON DATABASE::Example TO sa;