Have Report Builder forget saved credentials

Andrew 1 Reputation point
2020-08-17T15:56:02.537+00:00

Using Report Builder 3.0 for SQL Server 2014. I need to have it forget some user credentials forgotten when connecting to a report server. I have tried deleting the user config file, the clear all recent item lists option, and uninstalling and reinstalling Report Builder. It still remembers the credentials. How do I get it to forget them?

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,797 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 32,581 Reputation points
    2020-08-18T03:33:50.237+00:00

    Hi,

    Do you mind share a screenshot with your issue for me when you connect to a report server? (mosaic out important information.)

    I tried to connect a new remote report server via Report Builder 3.0, it did not promote me to enter the user credentials, but when I try to deploy report to the server it told me that I didn't have the permission.

    Regards,

    Zoe


  2. ZoeHui-MSFT 32,581 Reputation points
    2020-08-19T06:14:21.477+00:00

    Hi Andrew,

    Thanks for your reply.

    I have tested locally in the two situations.

    1)If I'm using a windows account which doesn't have the access to open the report server url. It will promote me to login in.

    2)If I'm using a windows account which has the access to open the report server url. I could connect to the report server directly without login promote.

    In the first situation, I login in and save my credential. And then I tried to clear all recent item lists with option and delete the user.config file at the same time.
    Restart the Report Builder, connect to the server,it will promote to login again.

    check the user.config file path:C:\Users\****Zoe(yourusername)****\AppData\Local\Microsoft\Report Builder\15.0.0.0

    Please check your window account to see if the account you are using already have the access so that you do not need to login in.

    You could run the Report Builder as a different user with an account which do not have any access and then connect to the server to have a check whether you need to login or not.