#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Sheffield UK
    Posts
    69
    Rep Power
    11

    SQLserveragent problems


    I'm setting up a new web server with 2003 server

    I've set up all my sites, and all the apps I need to run and up until now everything was fine, but now I'm getting problems with SQLserveragent, which I really need.

    I installed MS SQL server 2000 with windows only security (this is on a standalone web server) When I service packed it, I gave a password for the sa and changed the server to run on mixed mode authentication.

    I created some DTS packages, scheduled them, came into work the next day and they failed to run. The log file gives no indication as to why and I'm totally stuck now as to what to do. The SQL server runs under the computer admin account as does the SQLserveragent and the schedules and DTS packages do too.

    Please can someone tell me why all the schedules are failing??

    M3ckon
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Sheffield UK
    Posts
    69
    Rep Power
    11
    update: Fixed the problem, the SQLserveragent was runing under local administrator acount and not the computer administrator account

IMN logo majestic logo threadwatch logo seochat tools logo