Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Multiple non-sysadm users can't schedule packages?

Author  Topic  ra1814 Starting Member 6 Posts Posted - 2002-09-26 : 18:21:35 Can multiple, non-sysadmin, users create and schedule DTS packages on an SQL2000 server? There are several dbcreator role users on this server that are not sysadmins. When modifying the SQL Server Agent -> Properties -> Job System -> Non-SysAdmin job step proxy account, it only allows for one user,password,domain to be specified. What happens if you have multiple users creating DTS packages that need to be able to independently schedule their own packages? So, you couldn't create a group and give it access b/c it requires a password.. right? Thanks, Rob Edited by - ra1814 on 09/26/2002 18:22:09