Today I was a lurker in a "news to me" conversation about the SSRS file share delivery provider – thought I’d pass this interesting (to me) tidbit along.
When using the file share extension on a box which was NOT part of a domain, the user kept on getting the following error when trying to process a subscription:
Failure writing file: A logon error occurred when attempting to access the file share. The user account or password is not valid.
The user did standard testing and found that the file share was accessible from the console using the same username/password, etc.
Turns out that file share delivery provider doesn’t currently support challenge-response authentication. Instead, It impersonates the user before making the connection to the underlying machine. Because of this, in a workgroup environment, the file share deliveries will not work.
Thanks to Neeraja Divakaruni!