Share via

How to access SSRS report in another server/system?

Purnima Sharma 0 Reputation points
2023-02-23T06:25:14.24+00:00

I've created an SSRS report on my local server, it works fine locally. But when I'm trying to open that report in another server it asking "username and password" & "Could not load folder contents". But, I've not given any username & password or other credentials, still it keep asking. So, how to resolve this and keep visible to other different systems/servers.

Screenshot_20230222_095502.png

image.png

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.
3,061 questions
SQL Server Other
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 Reputation points
    2023-02-23T06:29:14.6933333+00:00

    By granting access for the user: Grant user access to a report server

  2. Anonymous
    2023-02-23T06:30:52.72+00:00

    Hi @Purnima Sharma

    Reporting Services uses role-based security to grant users access to the report server. On a newly installed report server, only users who are members of the local Administrators group have permissions to report server content and operations. To make the report server available to other users, you must create role assignments that map user or group accounts to predefined roles that specify a collection of tasks.

    You can see this link: Grant user access to a report server.

    Best regards,

    Aniya

  3. Anonymous
    2023-02-24T01:09:01.24+00:00

    Hi @Purnima Sharma

    The username and password are actually your authorized username and password.

    For example, when the SSRS download is complete, the permissions of the local administrator group have been granted, so I can log in to the website by logging in with the administrator's account password.1

    2

    Best regards,

    Aniya

  4. Anonymous
    2023-02-27T07:28:35.3966667+00:00

    Hi @Purnima Sharma

    To be honest, since we can’t check the status of your server in the forum, this type of issue is usually difficult to resolve.

    I suggest you consider using the phone support service provided by Microsoft which can usually help you resolve your issue.
    https://support.microsoft.com/en-us/help/4051701/global-customer-service-phone-numbers
    https://support.microsoft.com/en-us/supportforbusiness/productselection

    Best regards,

    Aniya

    0 comments
  5. Anonymous
    2023-03-03T06:07:59.7466667+00:00

    Hi @Purnima Sharma

    I searched and tested again, and according to your error message "Could not load folder contents", you probably didn't set the permissions correctly.

    Have you clicked "Manage folder" in the administrator account, and set permissions for the account you logged in in security? If you do not set this permission, setting permissions only for specific folders will not allow you to access folders.

    1

    2

    Best regards,

    Aniya

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.