SSRS Subscription Error - Error writing file
I have just started experiencing an error with my Fil开发者_StackOverflow社区e Share subscriptions. The log file tells me the following:
subscription!WindowsService_68!1da4!06/01/2011-15:00:06:: i INFO: Error writing file Next Day 2011_06_01_150006.xls to path \\server\share$\folder
There is nothing more in the log that gives me any clues as to why it is failing.
I have made sure that the execution account and the user account has access to the share with full permissions and ensured that the file path is exactly correct.
Any further ideas guys?
SSRS report subscriptions must have valid owners otherwise they error out. We recently had a DBA quit and started getting this error. Fixing the subscriptions was achieved by the following blog on MSDN Change Subscription owner
Edit:
Link to answer was deleted, here it is in all it's glory:
https://web.archive.org/web/20190203054104/https://blogs.msdn.microsoft.com/miah/2008/07/10/tip-change-the-owner-of-sql-reporting-services-subscription/
精彩评论