Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pgmr1998
Yak Posting Veteran
66 Posts |
 Posted - 2010-06-30 : 16:14:05
|
| I am getting this error. Does anyone know what the problem might be?Access denied.Error in File c:\temp\temp_1757bae0-1401-4171-964b-b44f0190aa10 {F6CEE573-81D9-4E97-9EFB-A1C212E65D5C}.rpt:Access to report file denied. Another program may be using it. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-07-01 : 02:39:24
|
| How are you getting this error? Are you sure that the account running sql server has access to the c:\temp-filder?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
pgmr1998
Yak Posting Veteran
66 Posts |
Posted - 2010-07-01 : 09:20:52
|
| Yes. I have tried to run it myself, and I get the same error. I do have full access to that dir. When I log into the SQL server remotely and look into the directory, I see several temp files with simular names, but I do not see the one named in the error. Shouldn't it reside in that dir also? I can't find it. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-07-01 : 09:33:30
|
| Where are you seeing this error?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
pgmr1998
Yak Posting Veteran
66 Posts |
Posted - 2010-07-01 : 09:53:47
|
| I am generating a Crystal Report from a sql database table. Apparently, Crystal builds a temp file in the c:\temp directory on the sql server when a report is generated. The report does get generated, however, when I attempt to Export it to Word, Excel, or PDF, I get the same error - always it has a dirfferent temp file name ofcourse. |
|
|
|
pgmr1998
Yak Posting Veteran
66 Posts |
Posted - 2010-07-01 : 10:53:52
|
| I have solved it!User's must be given 'Modify' access to the temp directory on the server. I simply loged into the server, right clicked on the temp folder, selected 'Sharing and Security', selected the 'Security' tab, and gave modify access to all users by checking the Modify check box when the user's group was selected.Thanks to everyone who has assisted me... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-07-02 : 02:54:47
|
| Excellent, and kudos for posting your solution :) It shouldn't be necessary to give the permissions to all users though...the user running the crystal reports service should suffice I think.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
|
|
SQL Error: Access denied