Permission to deploy an SSRS shared datasource

I'm having pemission errors trying to deploy an SSRS report template from MS Visual Studio.  We have a brand new outscoured IT department unfamiliar with Tessitura and they do not know where to update my permissions, is it on the report server, my local machine/windows login, etc.

Any help would appreciated

Thanks

Geoff

  • Former Member
    Former Member $organization

    Hi Geoff,

    In case you haven't already solved this issue: 

    Go to your Report Url (your_server_name/Reports),

    • From the Home folder, click on Folder Settings
    • If your login is not listed, click on New Role Assignment. If it is listed, click on Edit (to the left of your name)
    • Add your user name (if new). Select Contect Manager for your role.

    I hope that helps!
    Debbie

  • Hi Debbie, I’m getting back to trying to solve this issue.  Can we take a step back and help me determine what/where my “home server” is?

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Debbie Jacob
    Sent: Wednesday, May 17, 2017 1:29 PM
    To: Geoff Topalian <GTopalian@westportplayhouse.org>
    Subject: Re: [Tessitura Technical Forum] Permission to deploy an SSRS shared datasource

     

    Hi Geoff,

    In case you haven't already solved this issue: 

    Go to your Report Url (your_server_name/Reports),

    • From the Home folder, click on Folder Settings
    • If your login is not listed, click on New Role Assignment. If it is listed, click on Edit (to the left of your name)
    • Add your user name (if new). Select Contect Manager for your role.

    I hope that helps!
    Debbie

    From: Geoff Topalian <bounce-geofftopalian4839@tessituranetwork.com>
    Sent: 4/28/2017 1:01:45 PM

    I'm having pemission errors trying to deploy an SSRS report template from MS Visual Studio.  We have a brand new outscoured IT department unfamiliar with Tessitura and they do not know where to update my permissions, is it on the report server, my local machine/windows login, etc.

    Any help would appreciated

    Thanks

    Geoff




    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!

  • Hi Geoff,

    You should have the server name stored in SSRS_URL in T_DEFAULTS, for example, it might read something like http://WestportServer/ReportServer

    Adding to Debbie's instructions, log onto your production server, open a browser and type WestportServer/Reports in the address bar then follow the rest.

    Cheers,

    Kevin

  • Internet Explorer. An existing admin needs to access the web interface for SSRS to configure security and permissions.

    Here's a screenshot that may clarify things: http://d.pr/i/zZevQL/4rpqMvhk

    If you don't have access to SSRS admin, but you do have admin on the whole server instance, you can get in by launching Internet Explorer as administrator on the same machine, AND access the web interface by explicitly specifying localhost instead of the server's hostname. I had to do this when I started working with SSRS on our shiny new Tessitura instance because we didn't know any better in advance.

  • Ok, got that, now what piece of software should I use change the permission.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Madeira
    Sent: Wednesday, August 9, 2017 6:53 AM
    To: Geoff Topalian <GTopalian@westportplayhouse.org>
    Subject: RE: [Tessitura Technical Forum] Permission to deploy an SSRS shared datasource

     

    Hi Geoff,

    You should have the server name stored in SSRS_URL in T_DEFAULTS, for example, it might read something like http://WestportServer/ReportServer

    Adding to Debbie's instructions, log onto your production server, open a browser and type WestportServer/Reports in the address bar then follow the rest.

    Cheers,

    Kevin

    From: Geoff Topalian <bounce-geofftopalian4839@tessituranetwork.com>
    Sent: 8/8/2017 6:43:30 PM

    Hi Debbie, I’m getting back to trying to solve this issue.  Can we take a step back and help me determine what/where my “home server” is?

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Debbie Jacob
    Sent: Wednesday, May 17, 2017 1:29 PM
    To: Geoff Topalian <GTopalian@westportplayhouse.org>
    Subject: Re: [Tessitura Technical Forum] Permission to deploy an SSRS shared datasource

     

    Hi Geoff,

    In case you haven't already solved this issue: 

    Go to your Report Url (your_server_name/Reports),

    • From the Home folder, click on Folder Settings
    • If your login is not listed, click on New Role Assignment. If it is listed, click on Edit (to the left of your name)
    • Add your user name (if new). Select Contect Manager for your role.

    I hope that helps!
    Debbie

    From: Geoff Topalian <bounce-geofftopalian4839@tessituranetwork.com>
    Sent: 4/28/2017 1:01:45 PM

    I'm having pemission errors trying to deploy an SSRS report template from MS Visual Studio.  We have a brand new outscoured IT department unfamiliar with Tessitura and they do not know where to update my permissions, is it on the report server, my local machine/windows login, etc.

    Any help would appreciated

    Thanks

    Geoff




    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!