EXECUTE AS

Last Post 22 Jun 2006 10:41 AM by bemall. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bemall
New Member
New Member

--
14 Jun 2006 12:47 PM
Msg 15406, Level 16, State 1, Procedure SPName, Line 12
Cannot execute as the server principal because the principal "Domain\Accountname" does not exist, this type of principal cannot be impersonated, or you do not have permission.


I am looking for input on fixing the error above. I have gone through all checks and flags listed in the BOL.
bemall
New Member
New Member

--
22 Jun 2006 10:41 AM
Yes, all accounts are valid and non-expired accounts. I have verified this. I have also revied all BOL items for this i.e cross db ownership, trustworthy and relevant permissions. The account being impersonated is a sysadmin account with dbo access on the affected database while the impersonating account has dbo access in the database.
You are not authorized to post a reply.

Acceptable Use Policy