Wiki source code of How to enable encryption
Version 31.1 by Gideon Lombard on 2021/08/12 10:49
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 | |
| |
27.1 | 10 | 1. Open the **web.config** on the web server with **Notepad** |
| |
1.1 | 11 | 1. Look for the section with the connection strings |
| |
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}} | ||
| |
29.1 | 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}} | ||
| |
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 | |
| |
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 | ||
| |
31.1 | 39 | {{code language="xml"}}<connectionStrings> |
| 40 | <add name="dbConn" providerName="System.Data.SqlClient" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password]"/> | ||
| 41 | </connectionStrings>{{/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"}}<connectionStrings> | ||
| 44 | <add name="dbConn" providerName="System.Data.SqlClient" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true"/> | ||
| 45 | </connectionStrings>{{/code}} | ||
| 46 | |||
| 47 | == Parent Service - Client == | ||
| 48 | |||
| 49 | 1. (% id="cke_bm_849S" style="display:none" %) (%%)Open the **EBSParentService.exe.config** on the web server with **Notepad** | ||
| 50 | 1. Look for the section with the connection strings | ||
| |
27.1 | 51 | {{code language="xml"}}<databaseConnections> |
| |
28.1 | 52 | <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password]" ></add> |
| |
27.1 | 53 | </databaseConnections>{{/code}} |
| |
29.1 | 54 | 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 **;** |
| |
27.1 | 55 | |
| |
24.1 | 56 | == Database Settings == |
| 57 | |||
| 58 | |||
| 59 | === Parent Service === | ||
| 60 | |||
| 61 | {{code language="SQL"}} | ||
| |
29.1 | 62 | UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
25.1 | 63 | WHERE txtConnStr NOT LIKE '%Encrypt%' |
| |
24.1 | 64 | |
| |
29.1 | 65 | UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
24.1 | 66 | WHERE txtDocConnStr NOT LIKE '%Encrypt%' |
| 67 | |||
| |
29.1 | 68 | UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
24.1 | 69 | WHERE txtConnStrSchedule NOT LIKE '%Encrypt%' |
| 70 | |||
| |
29.1 | 71 | UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
24.1 | 72 | WHERE txtConnStrProcess NOT LIKE '%Encrypt%' |
| 73 | |||
| |
29.1 | 74 | UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
24.1 | 75 | WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%' |
| 76 | {{/code}} | ||
| |
26.1 | 77 | |
| |
27.1 | 78 | === System Settings === |
| |
26.1 | 79 | |
| 80 | {{code language="SQL"}} | ||
| 81 | |||
| |
30.1 | 82 | UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
26.1 | 83 | WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%' |
| 84 | |||
| |
30.1 | 85 | UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
26.1 | 86 | WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%' |
| 87 | {{/code}} | ||
| 88 | |||
| |
27.1 | 89 | === SSIS Service Steps === |
| |
26.1 | 90 | |
| 91 | {{code language="SQL"}} | ||
| |
29.1 | 92 | UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
26.1 | 93 | WHERE txtFromConnectionString NOT LIKE '%Encrypt%' |
| 94 | |||
| |
29.1 | 95 | UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=') |
| |
26.1 | 96 | WHERE txtToConnectionString NOT LIKE '%Encrypt%' |
| 97 | {{/code}} |