Solved

SQL Server Agent

Posted on 2013-05-21
6
373 Views
Last Modified: 2013-06-05
Created a job in Sql Server Agent.  I can not execute the job with myself as owner even though I am sysadmin on the database.   If I change the owner to and owner that has other jobs in the database  job executes perfectly.  What permission setting am I missing?
0
Comment
Question by:countyprob
  • 3
  • 2
6 Comments
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39185039
What does the job do when you execute it as yourself?  Does it error out?  And if so, could you provide the error?
0
 
LVL 11

Assisted Solution

by:Guru Ji
Guru Ji earned 250 total points
ID: 39185140
It isn't a server role so sysadmin won't do anything

It is one of the "SQL Server Agent Fixed Database Roles" in msdb

See "How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)" on MSDN
0
 
LVL 1

Author Comment

by:countyprob
ID: 39185459
When I execute the job as myself I get the following error.  

Message
The job failed.  Unable to determine if the owner (K*******\user) of job SRA Sheriff report daily has server access (reason: Could not obtain information about Windows NT group/user 'KERNPROBATION\joemunch', error code 0x5. [SQLSTATE 42000] (Error 15404)).
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 8

Accepted Solution

by:
didnthaveaname earned 250 total points
ID: 39187685
That's an odd error.  It would seem to indicate that the account the SQL Server Agent service is running under doesn't have permissions to query AD for permissions.  Which begs the question as to how those jobs are running at all, regardless of the owner/user that it executes under.  Unless those other users are SQL Server authenticated accounts or local accounts to that server.  Check and see what account the SQL Server Agent service is running under.
0
 
LVL 1

Author Comment

by:countyprob
ID: 39223334
Had to use a high privilege account
0
 
LVL 1

Author Comment

by:countyprob
ID: 39224112
I've requested that this question be closed as follows:

Accepted answer: 0 points for countyprob's comment #a39223334

for the following reason:

after tinkering around, the past DBA had a higher privileged account and we started using that.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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

816 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

11 Experts available now in Live!

Get 1:1 Help Now