Trust Server Certificate
DBAJohnny
Posts: 30 Bronze 2
I installed the update to 4.5.4.4597 this morning.
On opening my saved package, I needed to check the Trust Server Certificate on the dialog box connecting to the target database.
However, the <Generate Data> button was unavailable, with an orange/pink warning sign by each of my 60+ mapped tables. When I hovered over the warning sign, I got the message:
Thought to post this here in case it helps anyone else.
On opening my saved package, I needed to check the Trust Server Certificate on the dialog box connecting to the target database.
However, the <Generate Data> button was unavailable, with an orange/pink warning sign by each of my 60+ mapped tables. When I hovered over the warning sign, I got the message:
Error connecting mapped table. 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.)
I resolved this problem by saving my project, Opening up the .sqlgen file in VSCode and bulk replacing every instance of <TrustServerCertificate>False with <i><TrustServerCertificate>True</i>I saved the changes and reopened the project in SQL Data Generator. After this, the <Generate Data> button became available.
Thought to post this here in case it helps anyone else.
Comments