Solved

SQL Server Agent

Posted on 2013-05-21
6
389 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
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

728 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