DTS LoadFromSQLServer permissions -- sql server dts

brendan_gallagher_2001 NO[at]SPAM yahoo.co.uk
11/29/2005 2:23:55 PM

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

Rajesha
11/29/2005 9:42:03 PM

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

[quoted text, click to view]

Allan Mitchell
11/29/2005 10:36:04 PM

Does this article help?

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

Allan

"brendan_gallagher_2001@yahoo.co.uk"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : DTS LoadFromSQLServer permissions