Solved

Failed to run job with "run as"

Posted on 2011-09-20
3
986 Views
Last Modified: 2012-05-12
I have a job which should exe3cute the stored procedure, when I execute the job with "run as user" in job properties, I got the error message like below. But when I empty the "run as user" it work fine to execute the job. what is wrong here ?


Executed as user: domian1\kamry. Cannot find the object "%" because it does not exist or you do not have permissions. [SQLSTATE 42000] (Error 1088).  The step failed.
0
Comment
Question by:motioneye
3 Comments
 
LVL 21

Expert Comment

by:JestersGrind
Comment Utility
Are you sure that the user domain1\kamry has execute permissions for that stored procedure?

Greg

0
 
LVL 21

Expert Comment

by:Alpesh Patel
Comment Utility
to execute job with sepcific use need permission to execute sp.
0
 
LVL 5

Accepted Solution

by:
VENKAT KOKULLA earned 500 total points
Comment Utility
Here you need to give Complete Admin Rights for SQL and also add the local account to logins with granting full rights..

might it will helpout
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now