SSRS and Windows Authentication

serhio 96 Reputation points
2021-02-27T23:37:01.603+00:00

I try to build the simplest report with SSRS via asp.net core application.

The asp.net core application has windows authentication, and I would like that any domain identified user could generate a report.

I downloaded the latest to day SSRS version, installed it but then lost in configuration.

('PP-09...' is the machine name taken by default by the SSRS wizard):

enter image description here

then

enter image description here

here, I don't know what account to put, I let as is the default built-in.

It ask me for encryption key backup... I am new in this, don't really understand what for, I created a new folder and saved there an encryption key, provided a strong password, and then it completed the task:

enter image description here
enter image description here
enter image description here

however, when I try to access the /reportServer page I see

enter image description here

also acceeding http://localhost/reports/ does not really work

enter image description here

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
{count} votes

Accepted answer
  1. serhio 96 Reputation points
    2021-03-01T11:34:23.837+00:00

    normally I use Chrome, but this time, as you can see from screens there is IE (in admin mode) I could not have access to the "Manage" anything, even as admin.

    So I needed to change the account as "Network Service" (from the "built-in" one). I have no idea why that restricted me the access.

    For anyone wondering how I resolved the problem, please see more details here https://serverfault.com/a/1055372/312894


2 additional answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-03-01T07:18:37.987+00:00

    Hi @serhio ,
    You need to set permissions within SSRS in two places to give yourself initial access. The set-up program only gives access to Builtin\Administrators, to gain access in order to do this you need to right click you browser link and choose Run as administrator.

    1. Run internet explorer as Administrator
      72893-01.jpg
      1. Open the report Manager URL, this time you should get in
        72836-02.jpg
      2. Go to Site Settings in the top right
      3. Click Security then New Role Assignment
        72905-03.jpg
      4. Enter your domain\username and select System Administrator, click ok
        72885-04.jpg
      5. Add other users as necessary
      6. Click home, Folder Settings, then New Role Assignment
        72876-05.jpg
      7. Enter your domain\username and select Content Manager, click ok
      8. Add other users as necessary
      9. Re-open internet explorer (non-admin) and recheck the url.

    Hope this helps.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Olaf Helper 42,386 Reputation points
    2021-03-01T09:18:19.817+00:00

    I don't see in your post that you setup the ReportServer database, what is mandatory to get SSRS running.
    Have you a database engine installed & running? Have you setup SSRS database successful?

    0 comments No comments