Solved

Reporting Services Error - rsCredentialsNotSpecified

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 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

19 Experts available now in Live!

Get 1:1 Help Now