Changes for page How to enable encryption

Last modified by Gideon Lombard on 2021/08/12 10:55

<
From version < 22.1 >
edited by Gideon Lombard
on 2021/06/18 10:52
To version < 25.1 >
edited by Gideon Lombard
on 2021/06/25 16:14
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -31,3 +31,25 @@
31 31  [[image:1623328456852-301.png]]
32 32  1. Click the **Generate STP File**  and save the STP file again
33 33  [[image:1623328525432-818.png]]
34 +
35 +== Database Settings ==
36 +
37 +
38 +=== Parent Service ===
39 +
40 +{{code language="SQL"}}
41 +UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
42 +WHERE txtConnStr NOT LIKE '%Encrypt%'
43 +
44 +UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
45 +WHERE txtDocConnStr NOT LIKE '%Encrypt%'
46 +
47 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
48 +WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
49 +
50 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
51 +WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
52 +
53 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
54 +WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
55 +{{/code}}
1624013689442-828.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.gideonl
Size
... ... @@ -1,0 +1,1 @@
1 +16.7 KB
Content

Need help?

If you need help with XWiki you can contact: