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.
Solution
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.
- Updating and join on multiple rows, which row's value is used?
- What changed about the Statement.execute() between sqljdbc4 and mssql-jdbc?
- Varchar datetime with EDT in it convert into datetime
- LINQ: Why does a union of a union throw error message "IQueryable<...> does not contain a definition for 'Union'"?
- SQL Logic doesn't work
- Aggregation: Category missing in SQL subquery
- Error copying data from SQL Server to Redshift via a linked server connection
- Backup SQL Schema Only?
- Row wise average in SQL Server
- a *FUTUREPROOF* Project reference, to connect to SQL Server?
- Error for Invalid length parameter passed to SUBSTRING function
- Why is Query Optimizer Underestimating and Causing Data Spill to tempdb?
- SQL Server Management Studio Schema View
- Drop User from SQL Server Database?
- Create failed for Database
- SQL Server Express localdb.msi offline installer
- Loading data into SQL Server using Pandas dataframe
- Data has always changed(SQL Server Management Studio)
- SQL Server : generate random numeric string 27 characters long
- SQL Server Restore Error: Directory lookup for the file "db.mdf" failed
- Use dynamic database name in a stored procedure
- Why Does SQL Update Top apparently reduce locking even when no records are updated?
- "Type character does not declare data type" error
- Stopping repeated XML Headers
- C# filling a dataset from the database
- Microsoft SQL join on longitudinal data
- Add SSIS to existing SQL Server instance
- Cannot start LocalDB
- Remove all spaces from a string in SQL Server
- How to check the existence of related records in group by query?