reporting-servicesworkgroup

File share delivery of SSRS without domain

I am trying to schedule the delivery of a report to a shared folder in a workgroup(without domain). But I keep getting the error message of

Failure writing file: A logon error occurred when attempting to access the file share. The user account or password is not valid.

I have tried several combinations of acounts with or without ComputerName:

And I have created an identical account with same password on both side. Also, have tried set and unset unattended execution account with server administrator account. I am sure the shared folder can be accessed with the same UNC path and account in windows explorer. Not sure what else I can try.

Is there anybody successfully do the file share delivery without domain? Or any other way I can schedule to export a report?

Solution

  • This feature works fine in SSRS so it is your settings which are wrong.

    You will also want to have the subscription run as a specified user. Create a local user on the computer to where you wish to save your report. Call it ReportUser. For the purposes of this answer, we will call the the computer where you wish to save the report FileServer.

    ReportUser needs write access to the share you are trying to use.

    Try your report - if it still doesn't work then:

    1. Launch Windows Explorer but Run As your new ReportUser - you will need to enter the password you have just created.
    2. Navigate to the share by typing \\computername\fileshare - this proves your share is setup correctly.
    3. Right click in the folder and create a new text document. this proves you have write permission to the folder.

    Successfully completing those steps will mean that SSRS will be able to write to the share.

    Within SSRS you need to be writing to:

    \\computername\fileshare

    The username will be \FileServer\ReportUser with a password that you have just created.

    One more thing - run the schedule straight after your test - to prove something isn't happening to the network, e.g. overnight maintenance etc.