How can we help you today? How can we help you today?

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?
martinm
0

Comments

2 comments

Sort by
  • martinm
    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.
    martinm
    0
  • martinm
    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.
    martinm
    0

Add comment

Please sign in to leave a comment.