Changes for page How to enable encryption

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

Summary

Details

Page properties
Content
... ... @@ -13,11 +13,11 @@
13 13  <add name="Icarus" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password]" ></add>
14 14  <add name="EverestWriteDB" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password]" ></add>
15 15  <add name="EverestDocuments" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password]" ></add>{{/code}}
16 -1. If there is not an **Encrypt=true and TrustServerCertificate=true** as part of the connection string you will need to add it separated with a **;**
17 -{{code language="xml"}}<add name="Everest" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true" ></add>
18 -<add name="Icarus" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true" ></add>
19 -<add name="EverestWriteDB" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true" ></add>
20 -<add name="EverestDocuments" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo_Documents;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true" ></add>{{/code}}
16 +1. If there is not an **Encrypt=true** as part of the connection string you will need to add it separated with a **;**
17 +{{code language="xml"}}<add name="Everest" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true" ></add>
18 +<add name="Icarus" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true" ></add>
19 +<add name="EverestWriteDB" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true" ></add>
20 +<add name="EverestDocuments" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo_Documents;Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true" ></add>{{/code}}
21 21  
22 22  == Everest.NET ==
23 23  
... ... @@ -36,25 +36,17 @@
36 36  
37 37  1. (% id="cke_bm_1117S" style="display:none" %) (%%)Open the **Everest_SMSService.exe.config** on the web server with **Notepad**
38 38  1. Look for the section with the connection strings
39 -{{code language="xml"}}<connectionStrings>
40 - <add name="dbConn" providerName="System.Data.SqlClient" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password]"></add>
41 - </connectionStrings>{{/code}}
42 -1. (% id="cke_bm_1488S" style="display:none" %) (%%) If there is not an **Encrypt=true** **and TrustServerCertificate=true **as part of the connection string you will need to add it separated with a **;**
43 -{{code language="xml"}}<connectionStrings>
44 - <add name="dbConn" providerName="System.Data.SqlClient" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true"></add>
45 - </connectionStrings>{{/code}}
39 +{{code language="xml"}}<databaseConnections>
40 + <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password]" />
41 + </databaseConnections>{{/code}}
46 46  
47 -== Parent Service - Client ==
48 48  
49 -1. (% id="cke_bm_849S" style="display:none" %) (%%)Open the **EBSParentService.exe.config** on the web server with **Notepad**
50 -1. Look for the section with the connection strings
44 +1. (% id="cke_bm_1488S" style="display:none" %) (%%) If there is not an **Encrypt=true** as part of the connection string you will need to add it separated with a **;**
51 51  {{code language="xml"}}<databaseConnections>
52 - <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password]" ></add>
46 + <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password];Encrypt=true" />
53 53   </databaseConnections>{{/code}}
54 -1. (% id="cke_bm_1488S" style="display:none" %) (%%) If there is not an **Encrypt=true** **and TrustServerCertificate=true **as part of the connection string you will need to add it separated with a **;**{{code language="xml"}}<databaseConnections>
55 - <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true" ></add>
56 - </databaseConnections>{{/code}}
57 57  
49 +
58 58  == Database Settings ==
59 59  
60 60  
... ... @@ -61,19 +61,19 @@
61 61  === Parent Service ===
62 62  
63 63  {{code language="SQL"}}
64 -UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
56 +UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
65 65  WHERE txtConnStr NOT LIKE '%Encrypt%'
66 66  
67 -UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
59 +UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
68 68  WHERE txtDocConnStr NOT LIKE '%Encrypt%'
69 69  
70 -UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
62 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
71 71  WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
72 72  
73 -UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
65 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
74 74  WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
75 75  
76 -UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
68 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
77 77  WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
78 78  {{/code}}
79 79  
... ... @@ -81,10 +81,10 @@
81 81  
82 82  {{code language="SQL"}}
83 83  
84 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
76 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
85 85  WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
86 86  
87 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
79 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
88 88  WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
89 89  {{/code}}
90 90  
... ... @@ -91,9 +91,11 @@
91 91  === SSIS Service Steps ===
92 92  
93 93  {{code language="SQL"}}
94 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
86 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
95 95  WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
96 96  
97 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
89 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
98 98  WHERE txtToConnectionString NOT LIKE '%Encrypt%'
99 99  {{/code}}
92 +
93 +

Applications

Navigation

Need help?

If you need help with XWiki you can contact: