Wiki source code of How to enable encryption

Version 27.1 by Gideon Lombard on 2021/06/25 16:25
Hide last authors
Gideon Lombard 14.1 1 {{box cssClass="floatinginfobox"}}
Gideon Lombard 17.1 2 = Table of Contents =
Gideon Lombard 18.1 3
Gideon Lombard 17.1 4 {{toc start="2"/}}
Gideon Lombard 14.1 5 {{/box}}
Gideon Lombard 13.1 6
Gideon Lombard 1.1 7 == Website ==
8
Gideon Lombard 21.1 9
Gideon Lombard 27.1 10 1. Open the **web.config** on the web server with **Notepad**
Gideon Lombard 1.1 11 1. Look for the section with the connection strings
Gideon Lombard 27.1 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** as part of the connection string you will need to add it separated with a **;**
Gideon Lombard 12.1 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}}
Gideon Lombard 2.1 21
22 == Everest.NET ==
23
24
25 1. Get the clients current STP file that is provided to the users
Gideon Lombard 12.1 26 1. Run the Everest Administrator application and click the **STP Connection Files **menu item
27 [[image:1623327833111-701.png]]
28 1. On the next screen you click the **Load STP File** and load the STP file of your client
29 [[image:1623328089168-341.png]]
30 1. Ensure that the **Encrypt** is checked on the connection settings
31 [[image:1623328456852-301.png]]
32 1. Click the **Generate STP File**  and save the STP file again
33 [[image:1623328525432-818.png]]
Gideon Lombard 24.1 34
Gideon Lombard 27.1 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]" />
41 </databaseConnections>{{/code}}
42
43
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 **;**
45 {{code language="xml"}}<databaseConnections>
46 <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password];Encrypt=true" />
47 </databaseConnections>{{/code}}
48
49
Gideon Lombard 24.1 50 == Database Settings ==
51
52
53 === Parent Service ===
54
55 {{code language="SQL"}}
Gideon Lombard 25.1 56 UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
57 WHERE txtConnStr NOT LIKE '%Encrypt%'
Gideon Lombard 24.1 58
59 UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
60 WHERE txtDocConnStr NOT LIKE '%Encrypt%'
61
Gideon Lombard 25.1 62 UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
Gideon Lombard 24.1 63 WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
64
Gideon Lombard 25.1 65 UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
Gideon Lombard 24.1 66 WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
67
Gideon Lombard 25.1 68 UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
Gideon Lombard 24.1 69 WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
70 {{/code}}
Gideon Lombard 26.1 71
Gideon Lombard 27.1 72 === System Settings ===
Gideon Lombard 26.1 73
74 {{code language="SQL"}}
75
76 UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
77 WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
78
79 UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
80 WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
81 {{/code}}
82
Gideon Lombard 27.1 83 === SSIS Service Steps ===
Gideon Lombard 26.1 84
85 {{code language="SQL"}}
86 UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
87 WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
88
89 UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
90 WHERE txtToConnectionString NOT LIKE '%Encrypt%'
91 {{/code}}
Gideon Lombard 27.1 92
93

Applications

Navigation

Need help?

If you need help with XWiki you can contact: