The connection properties must be of type SqlConnectionProperties

Question

WhatsApp Image 2024-05-16 at 21.59.54.jpeg

WhatsApp Image 2024-05-16 at 21.59.23.jpeg

I am trying to connect to DB. I receive next errors: “The connection properties must be of type SqlConnectionProperties

Here are my steps: Server Explorer->Data Connections->Add Connection: I receive Choose Data Source form. On that form I select “Microsoft SQL Server” as Data source and “.NET Framework Data Provider for SQL Server” as Data provider. After pressing Continue button I receive error: “The connection properties must be of type SqlConnectionProperties or OleDBSqlConectionProperties” 2 times.

After skipping this error by pressing “Ok” I receive “Add connection” form with prefilled Data source: “Microsoft SQL Server(SqlClient)”. In “Advanced properties Connection String is empty” After succeeded Test connection I select '“OK”

Answer 1

Instead of using Server Explorer, try using SQL Server Object Explorer within VS. Does the problem persist?