Sunday, February 26, 2012

File Share Subscription

I have been trying, unsuccessfully, to set up a File Share Subscription. (The path is a location not on the report server.) On the destination server, the network permissions are set to full and the NTFS permissions are set to modify.

I found a post that said a Shared Schedule had to be used for this to work, so I tried that with no luck either. This is the error message I'm receiving:

"Logon failure: unknown user name or bad password. "

However, I can manually map a drive from my machine to that network drive.

And we've also been able to set up the File Share subscription to deliver to a different location on the network w/o issue.

I found something on a blog but I'm not sure that it is accurate. I can't find anything in the help files that indicate this is true. Can anyone confirm or deny?

"...if it fails using any account other than the account that the account Reporting Services is running under

just run your app pools and the reporting services windows service under the same account.

then change the Reports (Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager) and ReportServer (Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer) web.config files so the “impersonation” is to false."|||

In the file share subscription,use your login name and your password as stored credentials, and test the subscription.

Local server accounts may not be in Active Directory and they may not have permissions to write files on another share.

No comments:

Post a Comment