Database Activities Not Working After Converting The Project To Windows

News Knowledge Base
, ,
1

Why Database activities are not working after converting the project to Windows?

Issue Description: After converting the project to Windows, the following error is received: "Database activities not working anymore due to the following error: Connect SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted"

Resolution: When configuring a new database connection in Windows projects, Microsoft.Data.SqlClient is now the only SQL client option. For Windows - Legacy projects, choose between System.Data.SqlClient or Microsoft.Data.SqlClient.

For Windows processes, this might cause a breaking change, as you might require setting the Trusted certificate=true in your connection string in case the client does not have the Database Server certificate installed.

For more details, check the v1.7.0 Release Notes from our official documentation.