Results 1 to 3 of 3

Thread: SQL 2000 agent

  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    169

    Unanswered: SQL 2000 agent

    Hi,

    I am trying to set the account the SQL agent uses to a domain account so I can use SQL mail. The account works ok for the SQL service but not the agent.

    I have tried re-installing SQL 2000, and even in the installation it will not allow the agent to use the domain account.

    Anyone have any ideas as to what could be causing this.

    Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    What errors are you getting?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Well doing the re-install seems to have fixed it, the agent now starts with the domain admin account I have given it.

    I assume something must have got screwed up in the registry.

    Oh well I will have to service pack and restore master + msdb databases...........


    Ho hum

    Thanks anyway

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •