Forum Discussion

Copper Contributor

Jan 04, 2024

SSRS 2019 Report Services Prompting for username and password

I have installed SQL server 2019 reporting services, created my data sources and reports. Data sources are using SQL server authentication. I have set the service account to Network Service and even ...

olafhelper

Bronze Contributor

Jan 04, 2024

SSRS has it's own permission system, independent of your Windows AD permissions.

Start your browser with "Run as admin" and navigate to SSRS, there to "Side Setting" => "Security" and add your account to "Admin" role.

Nzemski

Copper Contributor

Jan 04, 2024

Thanks for the response.

My account is already added to the admin role and I still get the prompt to log in after an SSRS restart.

Do I need to enable Windows authentication via server manager?

olafhelper
Bronze Contributor
Jan 05, 2024
Which browser are you using?
E.g. FireFox don't pass your Windows authentication automatically to SSRS; here is the browser itself the problem. Set the checkbox to save your credential in browser cache.
- Nzemski
  Copper Contributor
  Jan 05, 2024
  Edge
  - Meraj_Asari
    Copper Contributor
    Feb 01, 2024
    Nzemski, I have experiencing the exact same issue!