Post reply

SQL Agent not running as domain account and Jobs getting hang in SQL 2000

  • June 20, 2006 at 11:03 am

    #114556

    Hi,

    I have a SQL Server 2000 Std Ed. (SP4) running on Windows 2000 Server (SP4). The sqlserver service is running under a domain account whereas sqlagent service is running under a local system account. The domain account is also present as a login in sql server and has system administrator server role. I am facing the following two problems:

    1. Whenever I try to use the same domain account for sqlagent, it does not start the agent service at all and unfortunately I have to go back to local system account.

    2. All the jobs created through maintenance plans does not run on their scheduled time. When invoked manually they start but then gets hang indefinitely, does not responds and then I have restart the agent service to stop them. They don't make any entry in error log, agent log and maintenance output reports. Surprisingly, the jobs created manually runs fine (also on scheduled time and logs the info also).

    I am using Windows Authentication, not using SQLmail, BUILTIN\Administrators has grant access assigned and also has System Admin server role.

    Responses will be highly appreciated.

    Regards,

    Nitin

  • June 23, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 30, 2006 at 9:03 am

    #646997

    Hi,
     
    Can some one please reply or provide a solution to this problem. Where are the MSSQL gurus??
     
    I am still facing this strange problem, where jobs created through Maintenance Plans are getting hang when executed. They are not logging any info anywhere (job history, msdb tables etc). When I right-click to view job history, it says that no history present. I have given full-access file permissions where it is performing backups and writing history. I have added the user through which I am running the job in the database also.  
     
    All other jobs (not created through maintenance plans) runs fine with the same user name and credentials.
     
    Please help.
     
    Regards,
     
    Nitin

  • July 26, 2006 at 1:53 am

    #651542

    I would like to know how to solve it as well. Our server acts in the same way, we have to use another program to backup our databases.

     

    regards

    ijme

     

  • July 26, 2006 at 9:49 am

    #651681

    When the jobs were created they would have been given the same owner as the user that registered the server in Enterprise Manager, check that the owner of the jobs (properties) is changed to say sa or another that has full administration rights.

    Regards

     

     

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • July 26, 2006 at 9:54 am

    #651686

    We have no issues with this. We even use a separate accounts for SQL Server and the SQL Agent. You say that the SQL Server Service domain account is a SQL login. Fist question is it in the 'sysadmin' role ? Second question: When changing from LocalSystem to a domain account for the SQL Agent, how are you doing it ? Through EM or through Services under Computer Management ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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