SQL Server Performance

SQL Agent Job - Problem trying to select user to "Run As"

Discussion in 'SQL Server 2005 General DBA Questions' started by dso808, Apr 11, 2011.

  1. dso808 New Member

    I have a job that runs a script. I want the script to "RUN AS" a login account that has been added to the instance. The problem is, in the window that lists all the available user names, that user that I want to run the job is not there. In fact, a lot of users are not in the list - even though I've verified that the logins are in the instance. How do I get the login I need to appear in the list so I can get this job step to RUNA AS" with that login/user? Thank in advance to all who reply!
  2. Luis Martin Moderator

    That job was created after or before those users?
  3. dso808 New Member

    Hi Luis and thanks for replying! Agh - finally found out what to do! You just go to login account properties > User Mapping and map the account to the master database. The account will then shows up in the list of users. Thanks again!

Share This Page