Visual Studio 2013 + Business Intelligence SSDT 中缺少 Reporting Server 模板 [英] Missing Reporting Server templates in Visual Studio 2013 + Business Intelligence SSDT

问题描述

前几天我安装了

从安装介质修复了整个 SQL Server 2014(64 位)安装.

尝试按照 Microsoft 指南使用 devenv.exe/InstallVSTemplates 检索未注册的 VS2013 模板/InstallVSTemplates (devenv.exe).

解决方案

根据 Graham 在他的帖子 安装 SQL Server 数据工具 - Visual Studio 2012 的商业智能 采用 scorch earth 方法并卸载我 PC 上的每个 SQL 版本.整个事情基本上归结为这三个简单的步骤，

1. 使用控制面板

中的程序和功能从您的 PC 上卸载每个 SQL Server 实例

2. 安装了 32 位版本的 SQL Server 2014 Express(任何其他版本都可以)

3. 安装 32 位 SSDT-BI for Visual Studio 2013 并选择将功能添加到 SQL Server 的现有实例，因为 32 位版本匹配.如果您的版本不匹配，请按照上面提到的帖子进行操作.(SSDT-BI 没有 64 位版本，因为 Visual Studio 也仅提供 32 位版本.)

中提琴，

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

Successfully created a project using Report Server Project Wizard template.

However, later on I needed SQL Server 2014, then I downloaded and installed the developer edition. (in case if this might've caused the problem)

Now the Report Server Project templates are missing from VS2013 and I can't simply bring them back.

Now my VS2008 has the features that I want:

But no trace of them in VS2013 Professional:

Any suggestions?

Additional unsuccessful approaches I have taken

• Repaired SQL Server Data Services.
• Attempted to Uninstall this service, which led to so many problems including, can't install this service back since all the boxes are ticked and grayed out in the installation process and can't past this level anymore.
• Attempted to remove all the related components which may let me reinstall the SSDT-BI for Visual Studio 2013 again but didn't help. This is the Microsoft guide I took to do so:Removing SQL Server Data Tools Components
• Repaired the whole SQL Server 2014 (64-bit) installation from the installation medium.
• Tried retrieving unregistered VS2013 templates using devenv.exe /InstallVSTemplates following this Microsoft guide /InstallVSTemplates (devenv.exe).

解决方案

I have eventually fixed my issue by following Graham's suggestion on my question on his post Installing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 by taking scorch earth approach and uninstalling every single edition of SQL that I had on my PC. The whole thing basically boils down to these three simple steps,

1. Uninstall every SQL Server instance from your PC using Programs and Features in Control Panel

2. Installed 32-bit edition of SQL Server 2014 Express (any other variation would work)

3. Installing 32-bit SSDT-BI for Visual Studio 2013 and choosing Add features to an existing instance of SQL Server since the 32-bit versions match. If you got mismatch editions follow the post mentioned above. (there is no 64-bit variation for SSDT-BI since Visual Studio is also only available in 32-bit.)

Viola,

这篇关于Visual Studio 2013 + Business Intelligence SSDT 中缺少 Reporting Server 模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！