November 7th, 2003, 05:46 AM
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??
November 7th, 2003, 09:37 AM
update: Fixed the problem, the SQLserveragent was runing under local administrator acount and not the computer administrator account