Upgrading SSRS Tooling

Over the years I’ve been told that in order to support SQL Server Reporting Services (SSRS) files (RDL) that I had to install the decade-old Visual Studio 2008 product.

More recently, I came across some info that indicates that this may not be the case, so I’m sharing it here in case it is able to help someone upgrade to current tools.

VS 2008

To work on SSRS reports (RDL files) one needs Visual Studio 2008 with the BIDS extension installed.

BIDS download – https://www.microsoft.com/en-us/download/details.aspx?id=30438

Note

Historically, the Visual Studio shell used to create SQL Server content types has been released under various names, including SQL Server Data Tools, SQL Server Data Tools – Business Intelligence, and Business Intelligence Development Studio. Previous versions came with distinct sets of project templates. To get all of the project templates together in one SSDT, you need the newest version. Otherwise, you will probably need to install multiple previous versions to get all of the templates used in SQL Server. Only one shell is installed per version of Visual Studio; installing a second SSDT just adds the missing templates.

SOURCE: https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi

VS 2017

It may be possible to work on SSRS reports with Visual Studio 2017 via the Microsoft Reporting Services Projects add-on.

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio

This requires the SQL Server Data Tools (SSDT) workflow to be installed via the VS 2017 installer.

clip_image001

Git Fatal: Authentication failed for

Issue

> git pull –tags origin master

fatal: Authentication failed for ‘{repository URI here}’

Resolution

  1. Go to Control Panel\All Control Panel Items\Credential Manager in Windows
  2. Select Windows Credentials
  3. Scroll down to Generic Credentials
  4. Edit git: credentials with updated password

Authentication will now succeed