Solved

Credential errors in ssrs

Posted on 2011-09-15
6
567 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
Comment Utility
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
Comment Utility
Please find the screen shot datasource
0
 
LVL 21

Expert Comment

by:Alpesh Patel
Comment Utility
After loading reports in SSRS please set the credentials and save it (Check save password checkbox)
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:chtullu135
Comment Utility
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
Comment Utility
Never mind I just figured it out.  Thanks
0
 

Author Closing Comment

by:chtullu135
Comment Utility
Thanks,  Your screen shot really helped
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now