Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Location
    Locked in side a tiny room with a keyboard and many monitors glowing away in the dark...
    Posts
    25

    Unanswered: Issue with SSRS 2005 User acces

    We have created a website that has linkes to reports on our SSRS 2005 report server. It works well for people that have access to the server, but no one else. We have tried using report manager to store credentials on the report server, still does not work.

    Any ideas on how we can allow access to the reports with out allowing access to the server?

    Thanks!!
    Torchwood
    "understand, in a sick and twisted sort of way?"

  2. #2
    Join Date
    Aug 2009
    Posts
    16
    Are you giving access to the users on IIS? They need to have access to the website for reporting services.

  3. #3
    Join Date
    Jul 2009
    Location
    Locked in side a tiny room with a keyboard and many monitors glowing away in the dark...
    Posts
    25
    There is not an issue with them pulling up the website, that is fine, but when they click on the link for the reoprt it connects to the report viewer (sitting on the report server) it throws an error. We have given a few people server/db access and now they can run the reports. But we would rather not have to give everyone that access, but it seems the only way to go at the moment.
    Torchwood
    "understand, in a sick and twisted sort of way?"

  4. #4
    Join Date
    Aug 2009
    Posts
    16
    Have you checked your event log to see what the error is when a user tries to run a report? I have recently setup SQL server 2008 and all the processing of the reports is done by the service account I believe, that your reporting services service is running. To give access to a large group of people that need access to the reports we created a group that has access to the reporting services website and when a report is processed, the service account is the one that executes the query. Make sure that account has proper permissions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •