Fail to preview the report in Microsoft Report builder

Question

Fail to preview the report in Microsoft Report builder

RussLiu-5439 20

When I click the preview button of the Report builder , it always show up below message.

The permissions granted to user '"DBNAME"\rpuser' are insufficient for performing this operation

I realize that this issue is happened by the lack of authentication and create another user(syssa) for designing report , but I don't know how to switch current user(rpuser) to that user(syssa) , it seems like it always connects to report server by rpuser instead of syssa.

Answer 1

AniyaTang-MSFT 9,526 Microsoft Vendor

Hi @RussLiu-5439

You can try right-clicking Report Builder and selecting "Run as a different user".

Screenshot 2023-09-11 100936

This will bring up a login box into which you can enter your newly created username and password.

Screenshot 2023-09-11 101018

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

RussLiu-5439 20 Reputation points

2023-09-11T02:44:22.9633333+00:00

Hi Aniya

After I right-clicking Report Builder in my laptop (preferred environment) , it did not show the option of "Run as a different user"

If I use the remote desktop to the Server that establish report server , it will show the option of "Run as a different user" , but if I logged in with the account newly created , the dropdown-list of connect report server will not show any report server that is able to connect.
AniyaTang-MSFT 9,526 Reputation points Microsoft Vendor

2023-09-11T02:52:19.4766667+00:00

Hi @RussLiu-5439

Can you try manually entering the web service url to connect?
RussLiu-5439 20 Reputation points

2023-09-11T02:57:55.9033333+00:00

Hi Aniya

Yes , I can enter the web service url manually.
AniyaTang-MSFT 9,526 Reputation points Microsoft Vendor

2023-09-11T03:14:57.1233333+00:00

Hi @RussLiu-5439

So after logging in with the new account, did your Report Builder run under the new account? You can still use the built-in field "UserID" to test the user ID running the report.

If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards,

Aniya
RussLiu-5439 20 Reputation points

2023-09-11T05:36:59.82+00:00

Hi Aniya

After logging in with the new account in Server , my Report Builder is running under the new account.

But I still have a problem that is when I use my laptop to show the userID , it always show my local account instead of the userID I set in URL website.

I ask my co-worker to test in his laptop , it will show the userID set in URL website.

Is there any settings I missed? (have uninstalled the Report Builder before but it didn't worked)

By the way , when my co-worker click "New Paginated Report" and open Report Builder , it will pop out a window ask for account & password (when I did the same action , the window did not pop out) , hope this information helps you.
AniyaTang-MSFT 9,526 Reputation points Microsoft Vendor

2023-09-11T06:18:31.93+00:00

Hi @RussLiu-5439

This may be due to the authentication type. By default, the report server uses Windows Integrated Authentication and assumes trust. You can try using Basic Authentication, please refer to this document: https://learn.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-ver16.

I did a simple test and after changing the authentication to basic authentication, when I open the report builder connection it asks for username and password.

Best regards,

Aniya
RussLiu-5439 20 Reputation points

2023-09-11T06:54:24.1666667+00:00

Hi Aniya

Thanks for your information , I have tried it , but when I open the report builder connection , it did not ask for username and password.

I remember that I have mark "Remember my password" , it seems that if I did it once , it will always directly logging in(By my co-worker Test).

Is there have any way to erase the remember password setting?(I have erase Cookies and reinstall Report builder before)
AniyaTang-MSFT 9,526 Reputation points Microsoft Vendor

2023-09-11T07:11:07.33+00:00

Hi @RussLiu-5439

I tried checking "Remember my password" but when I reopen report builder it still prompts for username and password. Did you stop and restart SSRS after changing the settings? Otherwise the changed settings will not take effect.
RussLiu-5439 20 Reputation points

2023-09-11T07:19:59.9066667+00:00

Hi Aniya

I just restart SSRS like below procedure , I am not sure this is correct or not?

and below is my setting config
AniyaTang-MSFT 9,526 Reputation points Microsoft Vendor

2023-09-11T07:28:46.48+00:00

Hi @RussLiu-5439

My settings are like this:
RussLiu-5439 20 Reputation points

2023-09-11T07:32:48.4+00:00

Hi Aniya

I just fix the problems refer to this topic

https://learn.microsoft.com/en-us/answers/questions/68683/have-report-builder-forget-saved-credentials

I delete the recent Item and reopen the report builder , then I can log in by synsa User.

thanks for your support!!

Answer 2

AniyaTang-MSFT 9,526 Microsoft Vendor

Hi @RussLiu-5439

You can try switching users while logged in.

Screenshot 2023-09-08 093033

I created a user Test and granted it the appropriate permissions. When I opened ReportBuilder, I created a simple report and added the built-in field "UserID" to test the user ID running the report. The result shows that the current running user is Test.

Screenshot 2023-09-08 093542

For more access to the report generator, you can check out this documentation: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/configure-report-builder-access?view=sql-server-ver16.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

RussLiu-5439 20 Reputation points

2023-09-11T01:49:15.2033333+00:00

Sorry Aniya , I think I did not describe my problems clearly

When I open the Microsoft Report builder and click Connect button like below.

It will pop out a window to select my report server

After I click connect , it will not ask me to key in the account name and password.

After that , when I click Run for preview report , it will show message like below.

It seems that rpuser don't have the permission to preview report.

Then I create a new user in Report Server called synsa that have the same permission of Administrators , and I want to switch user from rpuser to synsa , but I don't know how to do.

Fail to preview the report in Microsoft Report builder

1 additional answer

Activity