Hi,

I have a ASP (classic) wepage the running a SQL Server 2000 DTS package
which creates a text file and drops it in a specified network folder.
I need to know which user needs to be given write permissions on this
folder so that they can drop the file in the folder once the DTS
package is executed from webpage (on the user's own network pc). Is it
the executing user i.e. domain\username or is the SQL Server Agent.
Any help is appreciated.

Thanks
Brendan

Does this article help?

http://support.microsoft.com/?kbid=252987

Allan

"brendan_gallagher_2001 (AT) yahoo (DOT) co.uk"
<brendan_gallagher_2001 (AT) yahoo (DOT) co.uk> wrote

Hi Brendan,
SQL Server Agent running under default SQL user.
"SQL Server Agent" user should have rights to copy file to specified folder.
by default SQL user no rights to copy or creat file to specified folder.

My suggesation is Change SQL server user for "SQL Server Agent" to windows
user.

start--> Settings-->Controlpanel--> Administrative Tools-->Services
select SQLSERVERAGENT services--> Proparties --> LOGON -->
select Local System Account to This Account. and spacify your account.

Then DTS packge will create file in to specified path.

I hope it's cleared.

Regards,
Rajesha

"Allan Mitchell" wrote: