Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4005
  • Last Modified:

Reporting Services Error - rsCredentialsNotSpecified

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
ejctechnologies
Asked:
ejctechnologies
1 Solution
 
becraigCommented:
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
 
ejctechnologiesAuthor Commented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now