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

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.

• An error has occurred during report processing. (rsProcessingAborted)
  • Cannot create a connection to data source 'Tessitura_Live'. (rsErrorOpeningConnection)
    • For more information about this error navigate to the report server on the local server machine, or enable remote errors

Any help would be appreciated

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!

Thanks Gloria

I ended up selecting edit in report builder from the SSRS website and selecting the proper data source.

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

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.

• An error has occurred during report processing. (rsProcessingAborted)
  • Cannot create a connection to data source 'Tessitura_Live'. (rsErrorOpeningConnection)
    • For more information about this error navigate to the report server on the local server machine, or enable remote errors

Any help would be appreciated

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!

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!

Thanks Chris

Yes, there is a lot of inconsistencies in the what everything is named.

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 Chris Hall
Sent: Monday, February 16, 2015 6:08 PM
To: Combs, Jason
Subject: RE: [Tessitura Technical Forum] My First SSRS Report - Conection Error

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.