SSRS security-Sharepoint vs Tessi

Security by default in SSRS is implemented using Windows Integrated Security.  Tessitura has its own security schema.  Passing the UserId or UserGroup to a report may be used for securing the data source (stored procedure or query) for control group security, but it does not apply to securing the report itself.  I suggest you look into setting up windows groups that mirror your Tessitura groups, assigning permissions to folders of reports on the Report Server.

The second thing to mention here is that Tessitura does not directly support running SSRS in Sharepoint-Integrated Mode, like it sounds you have here.  The structure of the Report Server is changed to a very different structure when installed in this manner, which does not lend well for direct integration using other software (like Tessitura).

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeri Henderson
Sent: Tuesday, November 09, 2010 9:26 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] SSRS security-Sharepoint vs Tessi

Hi,

We are starting to create custom reports after previously using outside resources.  A Sharepoint site was created to manage custom reports but all reports are currently open to all domain users in Sharepoint security.  Is security managed in both Sharepoint and in Tessitura?  The documentation mentions several ways of controlling but describes passing user ID group to each report.   Is this the best way to go?

Thanks for helping us along,

Jeri

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!

Security by default in SSRS is implemented using Windows Integrated Security.  Tessitura has its own security schema.  Passing the UserId or UserGroup to a report may be used for securing the data source (stored procedure or query) for control group security, but it does not apply to securing the report itself.  I suggest you look into setting up windows groups that mirror your Tessitura groups, assigning permissions to folders of reports on the Report Server.

The second thing to mention here is that Tessitura does not directly support running SSRS in Sharepoint-Integrated Mode, like it sounds you have here.  The structure of the Report Server is changed to a very different structure when installed in this manner, which does not lend well for direct integration using other software (like Tessitura).

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeri Henderson
Sent: Tuesday, November 09, 2010 9:26 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] SSRS security-Sharepoint vs Tessi

Hi,

We are starting to create custom reports after previously using outside resources.  A Sharepoint site was created to manage custom reports but all reports are currently open to all domain users in Sharepoint security.  Is security managed in both Sharepoint and in Tessitura?  The documentation mentions several ways of controlling but describes passing user ID group to each report.   Is this the best way to go?

Thanks for helping us along,

Jeri

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!