Solved

Reporting Services Error - rsCredentialsNotSpecified

Posted on 2013-01-02
2
3,288 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

713 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