question

AndrusTamme-9900 avatar image
0 Votes"
AndrusTamme-9900 asked IsabellaZhangMSFT-7746 commented

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

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
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 AndrusTamme-9900 edited

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?

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

SQL servers are located in the Windows domain of the internal network. Access rights to the reporting environment are granted by the 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 Votes 0 ·
AndrusTamme-9900 avatar image
0 Votes"
AndrusTamme-9900 answered AndrusTamme-9900 published

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!

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.

IsabellaZhangMSFT-7746 avatar image
0 Votes"
IsabellaZhangMSFT-7746 answered IsabellaZhangMSFT-7746 commented

Hi @AndrusTamme-9900

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.


· 2
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 login to my computer with an MS Office user, this computer is not a member of our internal domain. The report server is in our internal domain, and the rights to use it are granted to groups in the internal domain.
When I open the Report Server web page in EDGE or Chromes, the same user on my computer (MS Office user) is used for authentication, but I need to enter another user account (internal domain user) that has been granted user rights. I can't change to another account to use this report server.
SSRS home folder open with error "Could not load folder contents". I see title of SSRS web page, but can not use it.

0 Votes 0 ·

Hi @AndrusTamme-9900

this thread is similar to your issue,please take a look: could-not-load-folder-contents-ssrs-report-manager


0 Votes 0 ·