Solved

Credential errors in ssrs

Posted on 2011-09-15
6
568 Views
Last Modified: 2012-06-22
Hello,

I've created a Report Server Project that imports Access reports.  I am able to deploy the reports but when I attempt to open the reports I get the following message
"The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)  "

I am teaching myself SSRS so I a new to reporting services.  I am using VS 2008 with a MS SQL 2008 server.  Thanks
0
Comment
Question by:chtullu135
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:SThaya
ID: 36547356
Hi,

   create a Data Source in the Reportserver with alllCredential.and connect the same source in the respective RDL .. it will work
0
 
LVL 11

Accepted Solution

by:
SThaya earned 500 total points
ID: 36547395
Please find the screen shot datasource
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36547803
After loading reports in SSRS please set the credentials and save it (Check save password checkbox)
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:chtullu135
ID: 36554834
Okay, I'm not sure where to set the credential or how to create a data source with all credentials.  This is the first time that I've been working with ssrs
0
 

Author Comment

by:chtullu135
ID: 36554848
Never mind I just figured it out.  Thanks
0
 

Author Closing Comment

by:chtullu135
ID: 36554851
Thanks,  Your screen shot really helped
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question