Changes for page How to enable encryption

Last modified by Gideon Lombard on 2021/08/12 10:55
<
From version < 26.1 >
edited by Gideon Lombard
on 2021/06/25 16:18
To version < 24.1 >
edited by Gideon Lombard
on 2021/06/25 16:12
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -32,6 +32,7 @@
32 32  1. Click the **Generate STP File**  and save the STP file again
33 33  [[image:1623328525432-818.png]]
34 34  
35 +
35 35  == Database Settings ==
36 36  
37 37  
... ... @@ -38,39 +38,20 @@
38 38  === Parent Service ===
39 39  
40 40  {{code language="SQL"}}
41 -UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
42 -WHERE txtConnStr NOT LIKE '%Encrypt%'
42 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
43 +WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
43 43  
44 44  UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
45 45  WHERE txtDocConnStr NOT LIKE '%Encrypt%'
46 46  
47 -UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
48 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
48 48  WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
49 49  
50 -UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
51 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
51 51  WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
52 52  
53 -UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
54 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
54 54  WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
55 -{{/code}}
56 56  
57 -=== System Settings ===
58 58  
59 -{{code language="SQL"}}
60 -
61 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
62 -WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
63 -
64 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
65 -WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
66 66  {{/code}}
67 -
68 -=== SSIS Service Steps ===
69 -
70 -{{code language="SQL"}}
71 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
72 -WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
73 -
74 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
75 -WHERE txtToConnectionString NOT LIKE '%Encrypt%'
76 -{{/code}}

Applications

Navigation

Need help?

If you need help with XWiki you can contact: