January 20, 2009 at 3:58 pm
I have a user attempting to post a subscription to a file share but is receiving the error:
"Failure writing file 'filename.xls' : An impersonation error occurred using the security context of the current user."
I'm able to post to the share without any issues using my windows account. The user is able to access the share through windows explorer. Are there certain permissions that need to be applied to the user's account for her to be able to post the subscription to the file share?
Jim
January 21, 2009 at 5:34 am
You will need to use the UNC Path to the folder you are trying to write to with the appropriate permissions.
Eg if they are writing to a fileshare on a Server you will need to put
\\ServerName\C$\FileShare_Path
(Note the $ on C which is the default share; it won't work without this)
This can be tested from the users machine by typing the UNC path into the run box and seeing does it go to the folder you want (and the necessary permissions required)
January 21, 2009 at 2:31 pm
The user has access to the file share and can write to it locally. Also, we can access the share from the reporting server.
January 22, 2009 at 4:25 am
i have achieved this on many different Servers. Below is an example of a Data Driven Subscription to a FileShare. (Note the syntax)
It is a bit fiddly, but once you get it working it is safe as houses
--***SQL Start*****************************************
SELECT
CASE WHEN count(*) > 0 THEN '\\Server1\JOBS\Contractor Jobs\Pending'
ELSE '\\Server1\JOBS\Contractor Jobs\No Jobs' END AS Folder_Path,
CASE WHEN count(*) > 0 THEN 'Jobs'
ELSE 'No_Jobs' AS [FileName],
'DomainName\UserName' As UserName,
'Password' as [Password]
From
--Selection Criteria goes here
WHERE
--Where Clause Goes Here
--***SQL End *****************************************
If you are not using a data driven sub you should be able to extrapulate the values you need from the above Sql above
June 14, 2016 at 2:40 pm
Hi, I am having the same problem. Was this resolved? and how
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply