Solved

Reporting Services Error - rsCredentialsNotSpecified

Posted on 2013-01-02
2
3,170 Views
Last Modified: 2013-01-02
We recently moved office locations for a Windows Server 2008.  We are running IIS7, SRSS and SQL 2008. The whole application uses an ASP.net front-end. Since hooking it back up our SSRS isn't working correctly.

When using report builder to test a report, I get the error in the attacked jpg, telling me my connection string hasn't been initialized, when testing the datasource.

-Where do you initialize connection strings in SRSS?

When I attempt to run the report from the website, I get the error in the attached htm file, "One or more data source credentials required to run the report have not been specified. (rsCredentialsNotSpecified)"

Nothing should have changed in the application. We changed some IP addresses and DNS settings since we were in a new location, but nothing in IIS or SRSS. I am at a loss. Thanks for your help.
error.jpg
SQL-Server-Reporting-Services.htm
0
Comment
Question by:ejctechnologies
2 Comments
 
LVL 29

Accepted Solution

by:
becraig earned 500 total points
ID: 38738524
Here is a good spot on how to update these settings from the report server url:
http://msdn.microsoft.com/en-us/library/ee248632%28v=vs.100%29.aspx
0
 

Author Closing Comment

by:ejctechnologies
ID: 38738587
Thank you. The section titled: "To verify or correct credentials or to enable data sources for Reporting Services" is what I was looking for. Somehow the credentials in the data source were blank.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
space used inside SQL data file- PerfMon counter.. 2 25
FTP Directory Permissions 3 26
How can i use WITH CTE for checking exist value? 3 33
Sql Server group by 10 27
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
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