• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

Job system in sql server agent properties

Looking at sql agent properties, I wonder what is use of "Non-sysadmins job step proxy account" I saw some server in my working office have checked and unchecked these values.  I notice when we unchecked the values the it require us to puyt new account, and question here can we know as well what is current account being used ?


sqljobsystems.bmp
0
motioneye
Asked:
motioneye
  • 7
  • 6
2 Solutions
 
RiteshShahCommented:
as per microsoft:

configure a Microsoft Windows-level SQL Server Agent proxy account to be used by SQL logins that are not members of the sysadmin fixed server role. Additionally, the article contains references to more information to help you solve problems that may occur when you try to set up a proxy account.

have a look at below link

http://support.microsoft.com/kb/890775
0
 
motioneyeAuthor Commented:
Ok,
If I check the box, and currently sql agent using domain account as service account which having sysamdins as server roles, is this the best configurations?
0
 
RiteshShahCommented:
well, I don't see any problem in this configuration as you are using domain user account and it has sysadmins server role, it works well.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
motioneyeAuthor Commented:
Hi,
Ok the reasons why I asked this such question bcoz every day, the job will failed and succeeded after several attempt of restart, when it failed the error msgs written as below in event viewer or job history, currently the box is unchecked and we set the proxy account similar with account use to start sql agent.
Will tis eliminate this such problem if I check the box ?

A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': Logon failure: account currently disabled.  The step failed.  
0
 
RiteshShahCommented:
are you sure you gave proper permission to your sqlagentcmdExec account? I guess you will be ok with the configuration you said in your post # 24154806
0
 
motioneyeAuthor Commented:
Yes it is, but now instead of the check box is checked it is does not, but we do have proxy account which actually sql agent account with sysadmin roles.
0
 
RiteshShahCommented:
well in that case, you are ok after selecting that checkbox.
0
 
motioneyeAuthor Commented:
Hi,
The error is still persist regardless of checking the values or not, I just don't understands we need to restart the job few time then only it go succeed, what is actually below errors means for ?

A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': Logon failure: account currently disabled.  The step failed.  
0
 
RiteshShahCommented:
I am sure you don't have full rights in SQLAgentCmdExec account.

anyway, have a look at below article

http://www.sqlservercentral.com/Forums/Topic287906-110-1.aspx#bm530272
0
 
motioneyeAuthor Commented:
Hi,
Its confirmed that the user account use to start sql agent services has "sysadmins" in server roles, I just dont get it why first run failed and work after that???
0
 
motioneyeAuthor Commented:
I have resolved the issue by creating local user, added into administrators group then assigned it onto Job system in sql agent, but I still couldnt find out why it was failed with domain user
0
 
RiteshShahCommented:
I had strong doubt for rights as I had explained in my last post
0
 
motioneyeAuthor Commented:
Hi RiteshShah
You did emphasized on the user has no sysadmins but it does and it used to start the sql services and agent, until now I still dont get it why it failed even now when I change it to use the previous account it still failed, and you did not able to help nor explained why it was always failed on first attempt but not subsequently
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now