How to install SQL Server support for Visual Studio 2017?

Question

I am not able to connect to SQL Server .dbml file. When I am trying to connect to SQL Server, it shows a message to "install the missing package". Now, when I am installing that missing plug-in, it just shows the progress bar and at last shows "Installation completed". But again when I try to connect, it shows the above error message.

Can anyone please help me to install it manually?

Step 1:

Step 2:

Step 3:

Try running visual studio `as admin` and then install it. – Pritam Feb 06 '18 at 05:03 — Pritam, Feb 06 '18 at 05:03
Thanks for your comment, let me try and inform you – Merbin Joe Feb 06 '18 at 05:21 — Merbin Joe, Feb 06 '18 at 05:21

score 0 · Answer 1 · answered Feb 06 '18 at 22:10

0

Search for and install the latest version of SSDT (Sql Server Data Tools).

answered Feb 06 '18 at 22:10

user3444696

347
2
7

score 0 · Answer 2 · answered Aug 01 '18 at 22:33

0

I install Visual Studio (community edition) quite often and this happened to one of the PCs I develop on.

Uninstalling/Re-installing Visual Studio is what make this work.

answered Aug 01 '18 at 22:33

Steven Chang

94
1
3

score 0 · Answer 3 · answered Apr 24 '19 at 20:13

Starting with Visual Studio 2017, the functionality of creating Database Projects has been integrated into the Visual Studio installation. There is no need to install the SSDT standalone installer for the core SSDT experience. To create Integration Services/Analysis Services/Reporting Services projects you still need the SSDT standalone installer.

For Database Projects, install the Data Storage and Processing workload for Visual Studio For Analysis Services, Integration Services or Reporting Services projects, download and install SQL Server Data Tools

How to install SQL Server support for Visual Studio 2017?

3 Answers3