SSRS Deployment and Security Questions

  • Help me Obi-Wan-ReportSpecialist, you're my only hope!

    I have several questions that I need some help on.

    1. In Report Services Confirguration Manager, I have two URL addresses. One is a Web Services URL and the other Report Manager URL. The web service URL is ugly and has no "sex" appeal for the end user. In addition, I can only upload from Visual Studio to that URL. However, the Report Manager URL has a nice interface, looks appealing, and I really want to deploy that one to the end users. So my question is, which URL should I give my end users? (Question 2 is a continuation of this one)

    2. If I give the Report Manager URL, can I a) control access to certain areas (i.e. You can read and execute reports only and NO DELETE) and b) can I force a logon window to check network authentication or simply a user authentication created through SSRS?

    Guys and Gals,

    what I want is a nice clean page that when a user clicks on the magic report shortcut on thier desktop, they are redirected to a page that looks like the Report Manager URL. A nice window pops up and say, "Hey, who are you and should you be here?". The user then authenticates with a username and password. Then they see a lonely folder called Reports. They click on it and select the report they want run.

    I don't want to see connection strings, delete options security, etc. Just a sinmple read, execute, and save (to excel, pdf, word, etc.). Am I dreaming or does someone have a solution that would help me?

  • I figured it out. I found a great tutorial on MSDN that solved all of my problems. http://msdn.microsoft.com/en-us/library/aa337491(v=sql.105).aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply