Changes for page How to enable encryption

Last modified by Gideon Lombard on 2021/08/12 10:55
<
From version < 31.1 >
edited by Gideon Lombard
on 2021/08/12 10:49
To version < 3.1 >
edited by Gideon Lombard
on 2021/06/10 12:19
>
Change comment: Uploaded new attachment "1623327563990-354.png", version {1}

Summary

Details

Page properties
Content
... ... @@ -1,97 +7,22 @@
1 -{{box cssClass="floatinginfobox"}}
2 -= Table of Contents =
3 -
4 -{{toc start="2"/}}
5 -{{/box}}
6 -
7 7  == Website ==
8 8  
9 9  
10 -1. Open the **web.config** on the web server with **Notepad**
4 +1. Open the web.config on the web server
11 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=[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 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}}
6 +{{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]" />
7 +<add name="Icarus" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password]" />
8 +<add name="EverestWriteDB" connectionString="Data Source=127.0.0.1;Initial Catalog=Everest_Risk_Demo;Persist Security Info=True;User ID=[username];Password=[password]" />
9 +<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]" />{{/code}}
10 +1. If there is not an Encrypt=true as part of the connection string you will need to add it seperated with a ';'.
11 +{{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" />
12 +<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" />
13 +<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" />
14 +<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" />{{/code}}
21 21  
16 +
22 22  == Everest.NET ==
23 23  
24 24  
25 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 -== 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"}}<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
51 -{{code language="xml"}}<databaseConnections>
52 - <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password]" ></add>
53 - </databaseConnections>{{/code}}
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 **;**
55 -
56 -== Database Settings ==
57 -
58 -
59 -=== Parent Service ===
60 -
61 -{{code language="SQL"}}
62 -UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
63 -WHERE txtConnStr NOT LIKE '%Encrypt%'
64 -
65 -UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
66 -WHERE txtDocConnStr NOT LIKE '%Encrypt%'
67 -
68 -UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
69 -WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
70 -
71 -UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
72 -WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
73 -
74 -UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
75 -WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
76 -{{/code}}
77 -
78 -=== System Settings ===
79 -
80 -{{code language="SQL"}}
81 -
82 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
83 -WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
84 -
85 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
86 -WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
87 -{{/code}}
88 -
89 -=== SSIS Service Steps ===
90 -
91 -{{code language="SQL"}}
92 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
93 -WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
94 -
95 -UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
96 -WHERE txtToConnectionString NOT LIKE '%Encrypt%'
97 -{{/code}}
21 +1. Run the Everest Administrator application
22 +1.
1623327567881-811.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -87.9 KB
Content
1623327731902-715.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -2.7 KB
Content
1623327833111-701.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -92.5 KB
Content
1623328089168-341.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -44.6 KB
Content
1623328370911-991.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -106.5 KB
Content
1623328425131-324.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -106.5 KB
Content
1623328456852-301.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -107.5 KB
Content
1623328525432-818.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -107.2 KB
Content
1624013566064-709.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -80.3 KB
Content
1624013689442-828.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.gideonl
Size
... ... @@ -1,1 +1,0 @@
1 -16.7 KB
Content

Applications

Navigation

Need help?

If you need help with XWiki you can contact: