Re: error on DTS scheduling
From: sql rookie (anytasks_at_gmail.com)
Date: 01/11/05
- Next message: JIM.H.: "Q: number of parameters in stored procedure"
- Previous message: plane123: "Removing SQL server 2000 from Cluster"
- In reply to: Danijel Novak: "Re: error on DTS scheduling"
- Messages sorted by: [ date ] [ thread ]
Date: 11 Jan 2005 08:57:54 -0800
There is a new developement on this:
I tried to change the sqlserver and agent service account to Local
systems and then the scheduling was working fine. I created a new
domain account , added it to the admin group to the server, made that
domain user the service account for sqlserver and agent. Gave sysadmin
privelege to the domain user. Now when I schedule it , I doesn't work.
I gives the same error
Am I doing something wrong ?
Please help
- Next message: JIM.H.: "Q: number of parameters in stored procedure"
- Previous message: plane123: "Removing SQL server 2000 from Cluster"
- In reply to: Danijel Novak: "Re: error on DTS scheduling"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|