Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Sql Server 2008 jobs -- whose running the show?

Respondido Sql Server 2008 jobs -- whose running the show?

  • Monday, February 18, 2013 5:32 PM
     
     
    Sign In to Vote
    0

    Recently I found a number of databases listed as owned by a member of our team (domain\user). I changed the database owner to "sa".  Then I started to wonder about our Sql Agent jobs......they were owned by the same user... so I changed those owners to "sa" and the jobs continue to run fine.  then I checked the service account that the Agent runs under. It is listed as "Local service" which is all-powerful locally. But when I right-clicked (in SSMS) the SQL Agent and went to properties it showed the "connection" property as using the domain user name!

    1. I guess, under these circumstances, I can change the "connection" property name to "sa" (as the jobs are being run by local service anyway). Does that make sense to you?

    2. Also some SSIS jobs run under a proxy agent. I presume that that account preempts "local service" for those jobs so we are still safe changing the connection to "sa". Do you agree?

    TIA,

    edm2

    P.S. Given our IS Team generally logs into servers using their domain name (for auditing purposes) this leads quite naturally to the situation described above.  We need to be diligent to change DB\SSIS owners to "sa" after they are created.




    • Edited by edm2 Monday, February 18, 2013 6:14 PM
    •  
     

All Replies

  • Wednesday, February 20, 2013 9:08 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi edm,

    We use SQL Server Agent Properties (Connection Page) to view and modify the settings for the connection from the Microsoft SQL Server Agent service to SQL Server.

    Do not select the Local Service account. The SQL Server Agent service cannot be run under this account. It is not supported. The name of this account is NT AUTHORITY\LocalService, and it accesses network resources as a null session with no credentials.

    Selecting an Account for the SQL Server Agent Service: http://msdn.microsoft.com/en-us/library/ms191543(v=SQL.100).aspx.

    If you have any feedback on our support, please click here.

    Thanks.

    Maggie Luo
    TechNet Community Support

     
  • Tuesday, February 26, 2013 9:33 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi edm,

    I’m writing to follow up with you on this post. Was the problem resolved?

    If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.  

    Thanks.

    Maggie Luo
    TechNet Community Support