Missing report server templates in Visual Studio 2013 + Business Intelligence SSDT

Question

The other day, I installed Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 (SSDT: replacement for BIDS) and started using the reporting features in VS2013 .

Successfully created a project using the Project Server Project Wizard.

However, later I needed SQL Server 2014, then I downloaded and installed the developer version. (in case this could cause a problem)

Now the report server project is missing in VS2013 , and I can’t just get them back.

Now my VS2008 has the functions I want:

But no trace in VS2013 Professional :

Any suggestions?

Additional unsuccessful approaches I took

• Refurbished SQL Server Data Services.
• An attempt to remove this service, which led to many problems, including, cannot install this service, since all the checkboxes are checked and grayed out during installation and can no longer pass this level.
• Trying to remove all related components that may allow me to install SSDT-BI for Visual Studio 2013 again, but did not help. This is the Microsoft guide I took for this: Removing SQL Server Data Components
• Edited the entire installation of SQL Server 2014 (64-bit) from the installation media.
• I tried restoring unregistered VS2013 templates using devenv.exe /InstallVSTemplates , following this guide from Microsoft / InstallVSTemplates (devenv.exe) .

Answer 1

I eventually fixed my problem by following Graham's suggestion on my question on his post Installing SQL Server Data Tools - Business Intelligence for Visual Studio 2012 , using the scorch earth approach and deleting every single version of SQL that I had on my PC. It basically comes down to three simple steps,

• Remove each instance of SQL Server from your PC using the programs and features in Control Panel

• Installed 32-bit version of SQL Server 2014 Express (any other option will work)

• Install 32-bit SSDT-BI for Visual Studio 2013 and choose to add features to an existing instance of SQL Server with 32-bit versions. If you get a discrepancy, follow the message mentioned above. (There is no 64-bit option for SSDT-BI, since Visual Studio is also available only in the 32-bit version.)

Viola,