INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- Turn Off Ad Banners
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...I have tons of books, have book marked tons of tutorials, which have helped, but this forum has answered those "impossible to find" solutions. I am thrilled with this site..."
Geography
Where in the world do Tek-Tips members come from?
|
Microsoft SQL Server: Programming FAQ
|
Scheduling DTS Packages
|
How can I ensure that my scheduled DTS Packages will execute correctly?
Posted: 14 Nov 00
|
When your DTS packages get scheduled, a thing to keep in mind is that the SQL Server Agent executes them and they may not work as you intended due to the fact that the Agent is most likely running under a different security context.
Here is a checklist you can use to ensure a smooth transition for packages where the security context changes from the creators context to the Agents context:
* The package is owned by you
* The agent account is a domain account being authenticated by a DC in, say, DOMAIN2
* The SQLAgent is being run under the context of a domain account
* The SQLAgent account and your account are both members of BUILTIN\administrators on the SQL Server
* The SQLAgent account and your domain account are members of the sysadmin fixed server role
* The directory in which the files reside is shared, with
"Change" and "Read" permissions granted to BUILTIN\administrators
* The SQLAgent account and your domain account have been permitted access to the SQL Server database
* These users have not been explicitly DENIED access to any object being "touched" by the DTS package in the database.
I hope this helps...
Tom |
Back to Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum
My FAQ Archive
 Email This FAQ To A Friend |
|
 |
|
