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

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

On my other computer, this worked completely fine.

CodePudding user response：

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.