Поделиться через

SSRS File Share provider in a Workgroup

  • Статья

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!

Comments

  • Anonymous
    February 27, 2008
    PingBack from http://www.biosensorab.org/2008/02/27/ssrs-file-share-provider-in-a-workgroup/
  • Anonymous
    March 07, 2008
    The comment has been removed
  • Anonymous
    March 07, 2008
    The comment has been removed
  • Anonymous
    February 04, 2016
    If the SSRS server and the server with the share are in different domains you can use pass-through authentication.  Create a local account on both servers with the same user name and password.  Enter the username on the subscription with out the domain name or back slash and the common password.