The connection properties must be of type SqlConnectionProperties

Ahmed Zafar 0 Reputation points
2024-05-16T20:22:20.9266667+00:00

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”

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,763 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Michael Taylor 49,781 Reputation points
    2024-05-16T20:40:39.65+00:00

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

    0 comments No comments