I am building my first SSRS report and published it to our ssrs site. Building the report was fine and preview works but I am getting the following error when trying to view the report.
Any help would be appreciated
Thanks Gloria
I ended up selecting edit in report builder from the SSRS website and selecting the proper data source.
Jason Combs | Director of Information Technology |jason.combs@strazcenter.org
David A. Straz, Jr. Center for the Performing Arts |
1010 North W.C Macinnes Pl | Tampa, Florida 33602 O: 813.222.1092 F: 813.222.1057
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby Sent: Friday, January 23, 2015 9:09 AM To: Combs, Jason Subject: RE: [Tessitura Technical Forum] My First SSRS Report - Conection Error
Check the authentication of the data source. Make sure your credentials are correct. Also, in the server explorer you can double click the server you want to connect to. I’m guessing a credential error as that is what I’ve seen.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Combs Sent: Thursday, January 22, 2015 11:13 PM To: Gloria Ormsby Subject: [Tessitura Technical Forum] My First SSRS Report - Conection Error
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Jason,
What I would assume is happening is that the data source in your custom report solution is named Tessitura_Live, but the data source saved on your report server is named something else. If you match the name in your solution to the name of the data source on your report server this should alleviate the problem in the future.
If you have more than one data source saved on your report server, you will likely need to create corresponding data sources in your report solution.