sql server dts: Good day

Scenario
----------
DbServer (DTS packages) <--- AppServer (C# application
- Only Windows Authentication allowe
- Duplicate Windows user on both machine

What are the minimum permissions that I need to set on the user (on DbServer box) to enable this scenario? (i.e. enable public for this user on msdb database, etc.

Thank you

Regards

guest is already a user in msdb unless you've removed him/her.

You can therefore unless you've save the packages with a password simply
execute them.

Permissions then are based on what the package does. This is where your
permissions need to be watched

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
DbServer box) to enable this scenario? (i.e. enable public for this user on
msdb database, etc.)
[quoted text, click to view]

Thanks man

I've found out that the Oracle provider folder was not given NTFS permission. Problem solved

Thank you

Regards