Wiki source code of How to enable encryption
Version 25.1 by Gideon Lombard on 2021/06/25 16:14
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
14.1 | 1 | {{box cssClass="floatinginfobox"}} |
| |
17.1 | 2 | = Table of Contents = |
| |
18.1 | 3 | |
| |
17.1 | 4 | {{toc start="2"/}} |
| |
14.1 | 5 | {{/box}} |
| |
13.1 | 6 | |
| |
1.1 | 7 | == Website == |
| 8 | |||
| |
21.1 | 9 | |
| |
1.1 | 10 | 1. Open the web.config on the web server |
| 11 | 1. Look for the section with the connection strings | ||
| |
12.1 | 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}} | ||
| |
21.1 | 16 | 1. If there is not an Encrypt=true as part of the connection string you will need to add it seperated with a **;** |
| |
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}} | ||
| |
2.1 | 21 | |
| 22 | == Everest.NET == | ||
| 23 | |||
| 24 | |||
| 25 | 1. Get the clients current STP file that is provided to the users | ||
| |
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]] | ||
| |
24.1 | 34 | |
| 35 | == Database Settings == | ||
| 36 | |||
| 37 | |||
| 38 | === Parent Service === | ||
| 39 | |||
| 40 | {{code language="SQL"}} | ||
| |
25.1 | 41 | UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=') |
| 42 | WHERE txtConnStr NOT LIKE '%Encrypt%' | ||
| |
24.1 | 43 | |
| 44 | UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=') | ||
| 45 | WHERE txtDocConnStr NOT LIKE '%Encrypt%' | ||
| 46 | |||
| |
25.1 | 47 | UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=') |
| |
24.1 | 48 | WHERE txtConnStrSchedule NOT LIKE '%Encrypt%' |
| 49 | |||
| |
25.1 | 50 | UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=') |
| |
24.1 | 51 | WHERE txtConnStrProcess NOT LIKE '%Encrypt%' |
| 52 | |||
| |
25.1 | 53 | UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=') |
| |
24.1 | 54 | WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%' |
| 55 | {{/code}} |