Link to home
Start Free TrialLog in
Avatar of rdefino
rdefinoFlag for United States of America

asked on

sccm 2012 subscription report will not save to file share

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
Avatar of Toni Uranjek
Toni Uranjek
Flag of Slovenia image

User account: is it local or domain user account?
Avatar of rdefino

ASKER

Domain account.
Which account do you user for Reporting Services?
Avatar of rdefino

ASKER

How can I verify the account? Where would I look?
services.msc
Avatar of rdefino

ASKER

I see sql server reporting services using the account reportserver. Looks like a built in sql account.
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?
Avatar of rdefino

ASKER

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

I check computer management and there is no local account.
Which version of Reporting Services do you have installed?
Avatar of rdefino

ASKER

standard edtion
11.0.3128.0
ASKER CERTIFIED SOLUTION
Avatar of Toni Uranjek
Toni Uranjek
Flag of Slovenia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rdefino

ASKER

Ran theUser generated image 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.
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?
Avatar of rdefino

ASKER

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.
If YOU run subscription again, or it runs scheduled?
Avatar of Benjamin Voglar
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.