I built a SSRS 2005 report, which calls a stored proc on SQL Server 2005. The proc contains following code:
CREATE TABLE #promo (promo VARCHAR(1000))
--FIELDTERMINATOR = '',
ROWTERMINATOR = ''
SELECT * from #promo
It's ok when I manually execute the proc in SSMS.
When I try to run the report from BIDS I got following error:
*Cannot bulk load because the file "\aseposretail\c$z\promo_names.txt" could not be opened. Operating system error code 5(Access is denied.).*
Note: I have gooled a bit and saw many questions on this but they are not relevant because I CAN run the code no problem in SSMS. It's the SSRS having the issue. I am gussing it's related to the security of SSRS but know little about this.