SQL SVR Agent <jobname> The job failed. The owner <ownername> does not have server access.

Question

SQL SVR Agent <jobname> The job failed. The owner <ownername> does not have server access.

thepotplants

Hall of Fame

Points: 3079
More actions
January 26, 2011 at 7:15 pm

#232791

Hi
Windows Server 2008/SQL Server 2008 R2.
I'm trying to get sql server agent running so I can add a basic backup script/job.
I am getting the following error: "01/27/2011 12:54:35,Argent DB Backup Job,Error,0,HAUORA\HAUORA,Argent DB Backup Job,(Job outcome),,The job failed. The owner (<Server>\Administrator) of job Argent DB Backup Job does not have server access"
"<date/time>,<Jobname> Job,Error,0,<Servername\<dbname>,<jobname> ,(Job outcome),,The job failed. The owner (<Server>\Administrator) of job <Job name> does not have server access"
The Agent Service has been configured to use our Domain administrator account. (I don't know if this ideal or not but this is used elsewhere on other servers without a problem.)
Other than the account to use, do I need to configure anything else to allow SQL Agent to run?
Any searches related to SQL Agent and that error discuss renamed SA accounts which we haven't done and aren't using.
Is stopping and starting the agent sufficient after making changes or is a reboot required before changes take effect.
Any help or suggestions would be greatly appreciated.
Regards
Peter

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

thepotplants Hall of Fame Points: 3079 More actions · Answer 1

More info.

I've just tried using the built it accounts "Local system", "Local service" and "Network service" and they all fail with the same message.

I also tried using SA & SYSADMIN usernames but the window wouldn't authenticate them.

Peter

crazy4sql SSCoach Points: 19590 More actions · Answer 2

there are 2 things which I would like to ask :-

1) Is your sql agent service running? go in services and check the account which is configured for agent services.

2) Who is the owner of the job? Check the job properties and if its some other account who doesnt have permission to run the job then change the account to sa or some proper account.

----------
Ashish

thepotplants Hall of Fame Points: 3079 More actions · Answer 3

Figured it out... Yay :satisfied:

For others struggling with this, i'll try and clarify. I don't know if I am using the correct terminology but i'll explain as best I can.

SQL Server agent can/does use 2 different users. The first for running and the second for database access.

My windows service is running as Administrator,

but the individual jobs under are running as "sa".

crazy4sql SSCoach Points: 19590 More actions · Answer 4

SQL Server agent can/does use 2 different users. The first for running and the second for database access.

sqlserveragent is a service and a service always configured only on one specific account.

The other account you saying is the one configured for job and its not necessary that it need to be configured on sqlagentservice account.

You can configure the job on any account which have the enough permission to run the job.

----------
Ashish

thepotplants Hall of Fame Points: 3079 More actions · Answer 5

crazy4sql (1/26/2011)
there are 2 things which I would like to ask :-
1) Is your sql agent service running? go in services and check the account which is configured for agent services.
2) Who is the owner of the job? Check the job properties and if its some other account who doesnt have permission to run the job then change the account to sa or some proper account.

Thanks Ashish, I discovered my mistake before I saw your reply, but yes you were exactly right. 🙂