Why Database activities are not working after converting the project to Windows?
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”
In order to solve this, re-configure the database connection and change the connection option from System.Data.Sqlclient into Microsoft.Data.SqlClient.
If the error specifies any trust certificated issues, set the "Trusted certificate=true" in your connection string.
An alternative to that would be to install locally the certificate used by the database.
This is a breaking change introduced with version 1.7.0 of the UiPath.Database.Activities package.
For more details, check the v1.7.0 Release Notes.