How to use SQLSnapper with TrustCertificate=True in the connection?

In the SQLSnapper GUI there is no option/checkbox to enable Trust Server Certificate.   Do you have instructions how to modify the xml config file to include this option?

Best Answer

  • martinmmartinm Posts: 3 Bronze 1
    I was able to do this successfully using the command line interface, using the following one-liner, saved to a .BAT file:

    RedGate.SQLSnapper.exe /database:MyDatabase server:"MyServer,port;encrypt=true;trustservercertificate=true" /mksnap:MyDatabase.snp

    This seems to work only in the command line interface.  Redgate - Please add this feature to the GUI in the stand alone SQLSnapper UI (this option already exists in the full product SQL Compare -> Snapshot utility, just not in the stand alone SQLSnapper).  Pretty, pretty, please.

Answers

  • martinmmartinm Posts: 3 Bronze 1
    edited January 17, 2025 8:46PM
    I confirmed adding ";Trust Server Certificate=true" to the end of the server name as suggested in another post does not work (in the GUI).  It does work if you use the command line interface.
Sign In or Register to comment.