Avatar of rdefino
rdefino
Flag 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
SCCMWindows Server 2003

Avatar of undefined
Last Comment
Benjamin Voglar

8/22/2022 - Mon
Toni Uranjek

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

ASKER
Domain account.
Toni Uranjek

Which account do you user for Reporting Services?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
rdefino

ASKER
How can I verify the account? Where would I look?
Toni Uranjek

services.msc
rdefino

ASKER
I see sql server reporting services using the account reportserver. Looks like a built in sql account.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Toni Uranjek

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?
rdefino

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

I check computer management and there is no local account.
Toni Uranjek

Which version of Reporting Services do you have installed?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
rdefino

ASKER
standard edtion
11.0.3128.0
ASKER CERTIFIED SOLUTION
Toni Uranjek

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rdefino

ASKER
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 Uranjek

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?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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.
Toni Uranjek

If YOU run subscription again, or it runs scheduled?
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.
Your help has saved me hundreds of hours of internet surfing.
fblack61