Changes for page How to enable encryption

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

Summary

Details

Page properties
Content
... ... @@ -32,7 +32,6 @@
32 32  1. Click the **Generate STP File**  and save the STP file again
33 33  [[image:1623328525432-818.png]]
34 34  
35 -
36 36  == Database Settings ==
37 37  
38 38  
... ... @@ -39,20 +39,39 @@
39 39  === Parent Service ===
40 40  
41 41  {{code language="SQL"}}
42 -UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
43 -WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
41 +UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
42 +WHERE txtConnStr NOT LIKE '%Encrypt%'
44 44  
45 45  UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
46 46  WHERE txtDocConnStr NOT LIKE '%Encrypt%'
47 47  
48 -UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
47 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
49 49  WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
50 50  
51 -UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
50 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
52 52  WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
53 53  
54 -UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
53 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
55 55  WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
55 +{{/code}}
56 56  
57 +=== System Settings ===
57 57  
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%'
58 58  {{/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: