1. Create a new solution in VS 2022 v17.12.0 using the Console App Template (I don't think the template matters)

[ErikEJ]

1. Create a new solution in VS 2022 v17.12.0 using the Console App Template (I don't think the template matters)
2. Right click the project in Solution Explorer, Select EF Core Power Tool and then Reverse Engineer
   
3. Select Add, Add Database Connection
   
4. Enter a server name and select a database
   
5. Click Advanced... and set Multi Subnet Failover to True
   
6. Click OK on the Advanced Properties Windows and the Connection Properties Window
7. Error message is displayed
   

If you skip step 5 is works, but may timeout connecting to the database depending on which IP comes back first from DNS. Starting from Server Explorer, right clicking Data Connections, clicking Add Connection... and then following steps 4-6 works without error and then can be used when reverse engineering a database with EF Core Power Tools

Originally posted by @mikeholczer in #1845 (comment)

[ErikEJ]

@mikeholczer moved this to a new issue

[ErikEJ]

@mikeholczer I think this works from Server Explorer as you are probably using another Datasource than Microsoft SqlClient (as seen in step 4)

[mikeholczer]

I'm using Microsoft SQL Server (SqlClient) in both cases. In fact, if I skip step 5 and save the connection made through the Reverse Engineer window, I can then go over to Server Explorer, select Modify Connection on it, do step 5 there without any other changes and then I'm able to save the connection and use it.

[ErikEJ]

Interesting! Thanks for the additional details

[ErikEJ]

I implemented a fix for this in the latest daily build, would be grateful if you could try it out.

If you like my free tools, I would be very grateful for a rating/review on Visual Studio Marketplace and/or a one-time or monthly sponsorship