asked on

You must configure the unattended report Processing Account

I am trying to automate my report procces and I am getting this error on one of my reports and not sure where or how to config this

I get this under perview

An error Occurred during local report processing
an error has occurred during report processing
cannot creat a connection to data source "trulinx'
you have specified integrated security or credentials in the connection string forthe data source is configured to use a differeent credential type. to use values in the the connection string , you must config the unattenede report processing account for the report server.

Hadush

You need to change the datasource proporties into "Credentials stored securely in the report server" and give it User name and Password.

Auric1983

That user & password should ONLY be a domain member with read only access to the databases you wish to query as well

Gabe Lebron

ASKER

Ok where would that be I right click on data connections and properties and cant seem to find it

Auric1983

Where is the datasource setup? is it a shared datasource thats located on the SSRS server or is it stored local on the RDL File?

if its on the RDL file you need to open in BIDS or Visual studio. If its shared on the server, navigate to the reports server in IE and find the datasource, it would be under the Properties page of the datasource.

Gabe Lebron

ASKER

Now my question is this. I want to set up auto email on reports would it be better to use local or sharded to do this? the one i have setup now I local for this report

Auric1983

My vote's for a shared datasource, reason being is if for some reason i ever had to change that password, i only have one place to change it rather than N+1 reports that need to be modified

Gabe Lebron

ASKER

good point ! can I change it to a shard data soruce ?

Gabe Lebron

ASKER

if its local where in BIDS do i update the user pass .. cant seem to locate it

ASKER CERTIFIED SOLUTION

Auric1983

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Hadush

you can change it on the shared datasource on report manger too. And point the rport to the shared datasource

Gabe Lebron

ASKER

ok Auric ... Sorry i dont pick it up quick .. new to sql reports no training just learning as I go..
ok click on edit data set then edit data source then i have the
General and Credentials Tab
I cant make a Shared soruce from here it seems but, right now its using windows Auth (integrated Security) should i be using this?
this is how i change the user pass right!

Now if i want to make it a shared source do go to drop down and make new data source the check use data source refrence?

Gabe Lebron

ASKER

I also have an issue with email but i used a diffrent thread so i wont tie you up to long on this one

SOLUTION

Hadush

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gabe Lebron

ASKER

Ok i am assuming this is what you mean by it asking for a authontication.. when i try and deploy. I tried all my users and passwords and nothing seems to work. I tried going to data tab edit dataset , datasoruce and used shared data soruce refrence is checked and credentials is all grayed out .. I can log on to the tables just fine now... there are like 3 set of credentials i should be using .. one for datasource one for depoly and one for subcriptions dont make sence
Report-login.bmp