Post reply

Problem with Sql Server Agent with a non administrative account

  • March 7, 2005 at 2:55 am

    #85558

    I've changed the SQl Server Service Account with a non-administrative account (ref. http://support.microsoft.com/default.aspx?scid=kb;en-us;283811) but the service don't start.

     

    Can anyone help me?

     

    Thanks

     

    PS. I've my SSQL Server Standard on a win 2000 std service pack 4 and the user is SysAdmin on Sql Server security.

     

  • March 7, 2005 at 4:52 am

    #545683

    Are there any relevant entries in the application log for your Windows install? That would be my first port of call. You may well find an entry about not being able to access certain system resources.

  • March 8, 2005 at 4:28 am

    #545838

    none for install.

    In case of start of sql server agent there is the following message:

     

    Source Service control manager

    Event ID 7000

    Message: the sqlserveragent service failed to start due to the following error: the service did not respond to the start or control request in a timely fashion.

    Any ideas?

    Thanks

  • March 8, 2005 at 10:20 am

    #545932

    Does the service account you used have sysadmin rights within the SQL Server?

    K. Brian Kelley
    @kbriankelley

  • March 9, 2005 at 2:27 am

    #546064

    yes the account have sysadmin right.

    I've installed an other machine with Sql Enterprise edition with the same account and the installation program has been created the privileges right for the domain account used.

    The problem is get the necessary rights without new installation....

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

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