Changes for page How to enable encryption

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

Summary

Details

Page properties
Content
... ... @@ -4,15 +4,9 @@
4 4  {{toc start="2"/}}
5 5  {{/box}}
6 6  
7 -
8 -
9 -
10 -
11 -
12 -
13 -
14 14  == Website ==
15 15  
9 +
16 16  1. Open the web.config on the web server
17 17  1. Look for the section with the connection strings
18 18  {{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>
... ... @@ -19,7 +19,7 @@
19 19  <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>
20 20  <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>
21 21  <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}}
22 -1. If there is not an Encrypt=true as part of the connection string you will need to add it seperated with a ';'.
16 +1. If there is not an Encrypt=true as part of the connection string you will need to add it seperated with a **;**
23 23  {{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>
24 24  <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>
25 25  <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>
... ... @@ -37,3 +37,28 @@
37 37  [[image:1623328456852-301.png]]
38 38  1. Click the **Generate STP File**  and save the STP file again
39 39  [[image:1623328525432-818.png]]
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}}
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: