A question that I have been asked quite often is, “How can I change the Report Server that I am connected to in Report Builder?” I never really thought about it until then. To change the connection click the Disconnect link located at the bottom of the Report Builder Designer:

Once you click it you will be allowed to re-connect using the Connect link:

You will then be presented with the Connect to Report Server dialogue window:

In dropdown list labeled Report server type the URL of the Report Server of choice. Click Connect, and you will be connected to that report server.

Additionally, if you would like to set a default Report Server or SharePoint site that you would click on the SQL Server icon on the top left corner of the Report Builder Application:

Then click the Options button located at the bottom of the menu that appears. You will then be presented with Report Builder Options dialogue window:

Enter the Report Server URL or SharePoint site that you want to set as your default in the textbox labeled Use this report server or SharePoint site by default
and click OK. The next time you open the Report Builder application you will automatically connect to that site.

Talk to you soon,

Patrick LeBlanc