Changes for page How to enable encryption

Last modified by Gideon Lombard on 2021/08/12 10:55
<
From version < 27.1 >
edited by Gideon Lombard
on 2021/06/25 16:25
To version < 26.1 >
edited by Gideon Lombard
on 2021/06/25 16:18
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -7,13 +7,13 @@
7 7  == Website ==
8 8  
9 9  
10 -1. Open the **web.config** on the web server with **Notepad**
10 +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** as part of the connection string you will need to add it separated with a **;**
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 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 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 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>
... ... @@ -32,21 +32,6 @@
32 32  1. Click the **Generate STP File**  and save the STP file again
33 33  [[image:1623328525432-818.png]]
34 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"}}<databaseConnections>
40 - <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password]" />
41 - </databaseConnections>{{/code}}
42 -
43 -
44 -1. (% id="cke_bm_1488S" style="display:none" %) (%%) If there is not an **Encrypt=true** as part of the connection string you will need to add it separated with a **;**
45 -{{code language="xml"}}<databaseConnections>
46 - <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password];Encrypt=true" />
47 - </databaseConnections>{{/code}}
48 -
49 -
50 50  == Database Settings ==
51 51  
52 52  
... ... @@ -69,7 +69,7 @@
69 69  WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
70 70  {{/code}}
71 71  
72 -=== System Settings ===
57 +=== System Settings ===
73 73  
74 74  {{code language="SQL"}}
75 75  
... ... @@ -80,7 +80,7 @@
80 80  WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
81 81  {{/code}}
82 82  
83 -=== SSIS Service Steps ===
68 +=== SSIS Service Steps ===
84 84  
85 85  {{code language="SQL"}}
86 86  UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
... ... @@ -89,5 +89,3 @@
89 89  UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
90 90  WHERE txtToConnectionString NOT LIKE '%Encrypt%'
91 91  {{/code}}
92 -
93 -

Applications

Navigation

Need help?

If you need help with XWiki you can contact: