Subhadeep
Reputation: 30
Unable to add data connection between SQL Server 2019 and Visual Studio 2019 using Server Explorer
Server Explorer-Data Connections-Add new connection---testConnection(:Success)-Connect(:Shows this error)
On my other computer, this worked completely fine.
Upvotes: 0
Views: 396
Answers (1)
karthik kasubha
Reputation: 424
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.
Upvotes: 1
Related Questions
- SQLConnection not part of System.Data.SqlClient in VS 2019?
- I can't seem to create a SQL Server database with Visual Studio in data connections
- Unable to connect LocalDB from Visual Studio 2019
- Error in Connecting Visual Studio 2019 with Oracle 19c
- Unable to connect Microsoft SQL-Server and Visual Studio code
- Unable to add data connection
- Visual Studio Unable to Add Data Connection to SQL Server
- Error adding connection in Server Explorer: "Unable to add data connection. ExecuteScalar requires an open and available connection."
- add sql server data connection in visual studio
- Cannot create a new VS data connection in Server Explorer