SSRS not working with windows office account "Could not load folder contents"

Andrus Tamme 1 Reputation point
2021-09-29T09:15:46.16+00:00

I log to Windows with an MS Office account. We use SQL Report services with local domain users. The report services does not ask for a username but states that there is no right. How can you make that SSRS ask the account name?

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,785 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,576 Reputation points
    2021-09-29T10:01:19.747+00:00

    local domain users

    Local user or domain users?
    Anyway, have you/the admin granted access permissions to SSRS for the users; by default no one have?

  2. Andrus Tamme 1 Reputation point
    2021-09-29T13:46:16.747+00:00

    SQL servers are located in the Windows domain of the internal network. Access rights to the reporting environment are granted by this domain groups. My computer does not belong to this domain, and I use an Office account to sign in.
    I can use SSRS with Google Chrome in incognito mode, then ask for an account and password. But Edge doesn't ask for a username!

    0 comments
  3. Isabellaz-1451 3,611 Reputation points
    2021-09-30T06:40:41.817+00:00

    Hi @Andrus Tamme ，

    Did you mean that you can get access to the reporting manager，but the home folder is not visible ？ If in that situation ，maybe it's because you didn't add this user to the system role, please refer to these links：

    adding-local-user-account-to-windows-server-2019

    grant-user-access-to-a-report-server

    Best Regards,
    Isabella

    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.