question

serhio avatar image
0 Votes"
serhio asked UdhavJaybhay-9523 commented

SSRS and Windows Authentication

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Serhio,

You need to add your account to administrator group on your local system so that you will be able to access the reporting site as an administrator. Built-in administrators are by default admins on the reporting sites.

0 Votes 0 ·
serhio avatar image
0 Votes"
serhio answered serhio edited

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I would note, that it not really normal that we should always use IE for special task like this, any other browser is not capable to do it.

There should be a Windows Settings, not the IE one to manage security of the internet pages, trusted sites etc...

Bu the way, I should also add the localhost (http, not https) as trusted site in IE settings...




0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered serhio converted comment to answer

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

  2. Open the report Manager URL, this time you should get in
    72836-02.jpg

  3. Go to Site Settings in the top right

  4. Click Security then New Role Assignment
    72905-03.jpg

  5. Enter your domain\username and select System Administrator, click ok
    72885-04.jpg

  6. Add other users as necessary

  7. Click home, Folder Settings, then New Role Assignment
    72876-05.jpg

  8. Enter your domain\username and select Content Manager, click ok

  9. Add other users as necessary

  10. 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.



01.jpg (18.7 KiB)
02.jpg (41.6 KiB)
03.jpg (35.7 KiB)
04.jpg (73.4 KiB)
05.jpg (75.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.