Solved

Access denied on File Access from DTS of SQL 2005

Posted on 2008-10-24
3
298 Views
Last Modified: 2013-11-30
I am trying to import an csv file onto a SQL 2005 table.  The stored procedure works when I login with my credential.  However, the stored procedure fails when I try to schedule it to run.  I know it has to do with the credential of the SQLAgent services, but I still don't know how to get around it.  Can someone help?

Thanks
0
Comment
Question by:chaochenga
  • 2
3 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 22801301
You will have to change the starup account for the SQL Server Agent service to use a domain account that has the appropriate permissions.
0
 

Accepted Solution

by:
chaochenga earned 0 total points
ID: 22814064
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 22818086
Right, that is exactly what I said.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question