sccm 2012 subscription report will not save to file share

rdefino
rdefino used Ask the Experts™
on
I have a report that I'm trying to setup a subscription so it will save it to a share location on a 2003 server. The subscription is setup to use an account that has access to the share. I can open the share by typing \\server\share in the explorer window.

But when I run the subscription I get an error:  A log on error occurred when attempting to access the file share. The user account or password is valid.

Now I can open the share with the account and create a file and folder.

What am I missing
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Toni UranjekConsultant/Trainer

Commented:
User account: is it local or domain user account?

Author

Commented:
Domain account.
Toni UranjekConsultant/Trainer

Commented:
Which account do you user for Reporting Services?
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Author

Commented:
How can I verify the account? Where would I look?
Toni UranjekConsultant/Trainer

Commented:
services.msc

Author

Commented:
I see sql server reporting services using the account reportserver. Looks like a built in sql account.
Toni UranjekConsultant/Trainer

Commented:
OK, find Reporting Services Configuration Manager in your programs. First setting will display full name of service account.

If there isn't DOMAIN\ in front of username in services.msc, can you check if you have such local account in Computer Management?

Author

Commented:
That shows it's using the built in account "reportserver"

I check computer management and there is no local account.
Toni UranjekConsultant/Trainer

Commented:
Which version of Reporting Services do you have installed?

Author

Commented:
standard edtion
11.0.3128.0
Consultant/Trainer
Commented:
This is 2012.

Reporting Services can run under these accounts:
Least-privileged Windows user account
NetworkService
LocalSystem
LocalService

Configure the Report Server Service Account
https://msdn.microsoft.com/en-us/library/ms160340(v=sql.110).aspx

If you would use local account you would likely have problems when running scheduled reports.

Run this command from command prompt: net user and paste results here, remove any security sensitive information.

Author

Commented:
Ran thecommand output net user command.

Now we can run subscriptions for reports to email out, haven't setup any other subscription to save to a folder though.
Toni UranjekConsultant/Trainer

Commented:
Thanks, mate.

I still do not get it where is your "reportserver" account coming from.
Reporting Services need Windows account (or built-in account to run) as explained in posted article.

Who set up your Reporting server, or better part of the question, who knows this account's password and what happens if you try to log on to files erver with its credentials?

Author

Commented:
I know we are talking about if this is an account problem. But I can run the subscription and save the report, so it does work fine.

Problem is, if I run the subscription again, it fails to save the file. So why does it work sometimes and most of the time it fails?

this is where I;m lost.
Toni UranjekConsultant/Trainer

Commented:
If YOU run subscription again, or it runs scheduled?
Top Expert 2015

Commented:
Hi tofino. I Quickly read what are you talking with Toni.

I have a suggestion that is not by the book. Give the share everyone full control, just to test if the report will save on the share.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial