Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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