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 < 29.1 >
edited by Gideon Lombard
on 2021/08/12 10:44
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -7,17 +7,17 @@
7 7  == Website ==
8 8  
9 9  
10 -1. Open the web.config on the web server
10 +1. Open the **web.config** on the web server with **Notepad**
11 11  1. Look for the section with the connection strings
12 -{{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]" ></add>
13 -<add name="Icarus" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password]" ></add>
14 -<add name="EverestWriteDB" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password]" ></add>
15 -<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]" ></add>{{/code}}
16 -1. If there is not an Encrypt=true as part of the connection string you will need to add it seperated 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}}
12 +{{code language="xml"}}<add name="Everest" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password]" ></add>
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 +<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 +<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}}
21 21  
22 22  == Everest.NET ==
23 23  
... ... @@ -32,6 +32,18 @@
32 32  1. Click the **Generate STP File**  and save the STP file again
33 33  [[image:1623328525432-818.png]]
34 34  
35 +== SMS Service Settings ==
36 +
37 +1. (% id="cke_bm_1117S" style="display:none" %) (%%)Open the **Everest_SMSService.exe.config** on the web server with **Notepad**
38 +1. Look for the section with the connection strings
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]" ></add>
41 + </databaseConnections>{{/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"}}<databaseConnections>
44 + <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true" ></add>
45 + </databaseConnections>{{/code}}
46 +
35 35  == Database Settings ==
36 36  
37 37  
... ... @@ -38,39 +38,40 @@
38 38  === Parent Service ===
39 39  
40 40  {{code language="SQL"}}
41 -UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
53 +UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
42 42  WHERE txtConnStr NOT LIKE '%Encrypt%'
43 43  
44 -UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
56 +UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
45 45  WHERE txtDocConnStr NOT LIKE '%Encrypt%'
46 46  
47 -UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
59 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
48 48  WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
49 49  
50 -UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
62 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
51 51  WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
52 52  
53 -UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
65 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
54 54  WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
55 55  {{/code}}
56 56  
57 -=== System Settings ===
69 +=== System Settings ===
58 58  
59 59  {{code language="SQL"}}
60 60  
61 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
73 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
62 62  WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
63 63  
64 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
76 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
65 65  WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
66 66  {{/code}}
67 67  
68 -=== SSIS Service Steps ===
80 +=== SSIS Service Steps ===
69 69  
70 70  {{code language="SQL"}}
71 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
83 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
72 72  WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
73 73  
74 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
86 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
75 75  WHERE txtToConnectionString NOT LIKE '%Encrypt%'
76 76  {{/code}}
89 +

Applications

Navigation

Need help?

If you need help with XWiki you can contact: