Wiki source code of How to enable encryption

Version 24.1 by Gideon Lombard on 2021/06/25 16:12
Show last authors
1 {{box cssClass="floatinginfobox"}}
2 = Table of Contents =
3
4 {{toc start="2"/}}
5 {{/box}}
6
7 == Website ==
8
9
10 1. Open the web.config on the web server
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}}
21
22 == Everest.NET ==
23
24
25 1. Get the clients current STP file that is provided to the users
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]]
34
35
36 == Database Settings ==
37
38
39 === Parent Service ===
40
41 {{code language="SQL"}}
42 UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
43 WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
44
45 UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
46 WHERE txtDocConnStr NOT LIKE '%Encrypt%'
47
48 UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
49 WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
50
51 UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
52 WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
53
54 UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
55 WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
56
57
58 {{/code}}