Unable to add data connection between SQL Server 2019 and Visual Studio 2019 using Server Explorer

355 Views Asked by At

Server Explorer-Data Connections-Add new connection---testConnection(:Success)-Connect(:Shows this error)

On my other computer, this worked completely fine.

The error

1

There are 1 best solutions below

0
karthik kasubha On BEST ANSWER

Try below steps

Copy Microsoft.VisualStudio.Data.Providers.SqlServer from the working machine Or Click Here to download Microsoft.VisualStudio.Data.Providers.SqlServer File.

Paste in This Folder Located at C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE

Now your error should be fixed.