What are the challenges you face when working across database platforms? Take the survey

Trust Server Certificate

I installed the update to 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:
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 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.


Sign In or Register to comment.