SSRS – The Application is not installed message in Visual Studio 2015

Every once in a while I get to dabble with SSRS. This time I needed to edit some SSRS reports in an SSRS project that a co-worker had added to our Visual Studio solution. When I opened the solution the SSRS project failed to load with the message “{ProjectName} Incompatible” “The application is not installed”.
TLDR: You need to install SQL Server Data Tools Preview in Visual Studio 2015 from here.

ssrs-project-application-not-installed-visual-studio-2015-error

Apparently, I needed to install the Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio from here.

I ended up downloading the iso which is 171 MB. Running the SSDTSETUP.exe ran the installer and finished without any issues.
microsoft-sql-data-tools-2015

Reopening Visual Studio did not fix it :-(. I was still getting the same “The application is not installed project”. It turns out that the latest version of SQL Server Data Tools for Visual Studio 2015 does not have the BI template for visual studio and we will need to install the previous version of it from here.

Update:I tried the Microsoft SQL Server Data Tool – Business Intelligence for Visual Studio 2013 from here.
Still getting the same issue. FYI, there is no separate x64 version of the SSDT installer. You may get an error that says “Rule evaluation message: The CPU architecture of installing feature(s) is different than the instance specified. To continue, add features to this instance with the same architecture.”. You need to install SSDT-BI as a new instance instead of adding features to an existing instance. The error message is completely wrong but luckily we only do this kind of stuff rarely.

SSDT-2013-New-Installation

Still no luck. I am going to try the preview version of the SSDT Visual Studio 2015 tool.s

Update: Trying SQL Server Data Tools Preview in Visual Studio 2015 from here.

SQL-Server-Data-Tools-Preview-Visual-Studio-2015

I needed to restart after the installation completed and voila it worked.

Posted in Uncategorized | Leave a comment

Unshelve Pending Changes in Visual Studio 2013

Recently, I needed to use visual studio 2013 for a client who is still using it and need to shelve and unshelve a changeset. Shelving is easy but I couldn’t find an intuitive way to unshelve my changes. After stumbling for a few minutes and a couple of failed google searches I finally found it.

1. Go to Team Explorer
2. Locate the Pending Changes section
3. Right click on Pending Changes and click on the “Find Shelvesets” menu item.
4. Once you are on the Find Shelvesets screen you can do a search by the user name or shelveset name.

Locate Pending Changes Section:
visual-studio-2013-shelveset-1

Search for shelveset by user name or shelevset name:
Visual-Studio-2013-Shelveset-2

Instead of step 3, you can also just click on the Pending Changes section and locate “Find Shelvesets” in the “Actions” drop down.
Visual-Studio-2013-shelveset-3

Posted in .Net, Visual Studio | Leave a comment