Problem with DTS running from | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem with DTS running from

Hopefully someone can help. I am trying to run a DTS package from a aspx web page. The job sees the DTS package. It successfully runs step 1, but failes on the datapump task. I was able to determine that that it is failing due to a permissions, but I can’t determine what account it is trying to use. See error below.<br /><br />Step ‘DTSStep_DTSDataPumpTask_1′ failed<br /><br />Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider<br />Step Error Description:Error opening datafile: Logon failure: unknown user name or bad password.<br /><br />Step Error code: 80004005<br />Step Error Help File<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />TSFFile.hlp<br />Step Error Help Context ID:0<br /><br />I am running IIS5 on my local workstation with a project. I configured IIS with only "Integrated Windows Authentication". The code in the web page is using windows authentication with the &lt;identity impersonate="true" /&gt;. SQL is running with a domain account that has local admins rights to the server and have rights to the share read/write/modify. (I know this is working, it was able to write the DTS package error log to the same share!!) <br /><br />When I use profiler to see what the server is doing, I see that it is using the "sa" account. I don’t see how I still am using a wrong account or don’t have enough rights.
Are you trying to run the actual DTS package or a scheduled job of the DTS package?
Where is this file located, on the network or the local server?
Does it work when you execute the DTS package (or job) manually? In any case the user executing the DTS package, I assume the user logging in to your website with Windows Authentication (since you use impersonate), need to have rights to read/write to the file. If it’s a sql job you are executing then the sql agent account need to have access. This post might help: ASP. Net Identity Matrix: