Wiki source code of How to enable encryption
Version 24.1 by Gideon Lombard on 2021/06/25 16:12
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 | |||
| 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}} |