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.

Hi @RussLiu-5439 You can try right-clicking Report Builder and selecting "Run as a different user". This will bring up a login box into which you can enter your newly created username and password. 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

Hi @RussLiu-5439 You can try switching users while logged in. 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. 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

Fail to preview the report in Microsoft Report builder

Accepted answer

AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor

2023-09-11T02:15:33.28+00:00

Hi @RussLiu-5439

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

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

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
Please sign in to rate this answer.

1 person found this answer helpful.
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 12,441 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 12,441 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 12,441 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 12,441 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 12,441 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!!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.