''Execute As Login'' failed for... During Restore Database???

• DBADave

  SSChampion

  Points: 10962

  More actions

  November 8, 2006 at 10:16 pm

  #116182

  I receive the following error when I try to execute a restore database job while connected as the job owner.

  Sql Severity  14

  Sql Message ID  916

  'EXECUTE AS LOGIN' failed for the requested login 'DBA'.  The step failed.

  The login id 'DBA' is a member of db_owner in the database I am restoring.

  It is also a member of DBCreator server role, is owner of the SQL job and is a member of the msdb role SQLAgentUserRole.

  The job step is executed from master and is a simple restore command.

  What am I missing?

  Thanks,   Dave

• DBADave

  SSChampion

  Points: 10962

  More actions

  November 8, 2006 at 10:46 pm

  #670765

  Please disregard.  I resolved the problem.  Chalk it up to lack of sleep.

  Dave