Changes for page How to enable encryption

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

Summary

Details

Page properties
Content
... ... @@ -4,18 +4,16 @@
4 4  {{toc start="2"/}}
5 5  {{/box}}
6 6  
7 -
8 -
9 -
10 10  == Website ==
11 11  
12 -1. Open the web.config on the web server
9 +
10 +1. Open the **web.config** on the web server with **Notepad**
13 13  1. Look for the section with the connection strings
14 -{{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>
15 -<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>
16 -<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>
17 -<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}}
18 -1. If there is not an Encrypt=true as part of the connection string you will need to add it seperated with a ';'.
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 **;**
19 19  {{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>
20 20  <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>
21 21  <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>
... ... @@ -33,3 +33,63 @@
33 33  [[image:1623328456852-301.png]]
34 34  1. Click the **Generate STP File**  and save the STP file again
35 35  [[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"}}<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 +== Database Settings ==
51 +
52 +
53 +=== Parent Service ===
54 +
55 +{{code language="SQL"}}
56 +UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
57 +WHERE txtConnStr NOT LIKE '%Encrypt%'
58 +
59 +UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
60 +WHERE txtDocConnStr NOT LIKE '%Encrypt%'
61 +
62 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
63 +WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
64 +
65 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
66 +WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
67 +
68 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
69 +WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
70 +{{/code}}
71 +
72 +=== System Settings ===
73 +
74 +{{code language="SQL"}}
75 +
76 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
77 +WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
78 +
79 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
80 +WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
81 +{{/code}}
82 +
83 +=== SSIS Service Steps ===
84 +
85 +{{code language="SQL"}}
86 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
87 +WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
88 +
89 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
90 +WHERE txtToConnectionString NOT LIKE '%Encrypt%'
91 +{{/code}}
92 +
93 +
1624013566064-709.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.gideonl
Size
... ... @@ -1,0 +1,1 @@
1 +80.3 KB
Content
1624013689442-828.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.gideonl
Size
... ... @@ -1,0 +1,1 @@
1 +16.7 KB
Content

Applications

Navigation

Need help?

If you need help with XWiki you can contact: