Forum Discussion
Power Participantconnect to SQL server fails
File - Options and settings - Data source settings
Then select your SQL database and select 'edit permisions'
Selec Edit
And there you can change your connection type
Community SupportHi Jeanxyz ,
If you're getting this error after January 2022, possibly after migrating from System.Data.SqlClient to Microsoft.Data.SqlClient or just updating Microsoft.Data.SqlClient to version 4.0.0 or later, it's because MS has introduced a breaking change::
Breaking changes in 4.0
Changed
Encryptconnection string property to betrueby default.The default value of the
Encryptconnection setting has been changed fromfalsetotrue. With the growing use of cloud databases and the need to ensure those connections are secure, it's time for this backwards-compatibility-breaking change.Ensure connections fail when encryption is required
In scenarios where client encryption libraries were disabled or unavailable, it was possible for unencrypted connections to be made when
Encryptwas set totrueor the server required encryption.
Rick Strahl has posted a detailed explanation on his blog
The change was made in this SqlClient pull-request in August 2021, where there is additional discussion about the change.
The quick-fix is to add Encrypt=False to your connection-strings.
Similar question refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien