Changes for page How to enable encryption

Last modified by Gideon Lombard on 2021/08/12 10:55
<
From version < 16.1 >
edited by Gideon Lombard
on 2021/06/10 12:39
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
... ... @@ -1,9 +1,12 @@
1 1  {{box cssClass="floatinginfobox"}}
2 -{{toc start="2" /}}
2 += Table of Contents =
3 +
4 +{{toc start="2"/}}
3 3  {{/box}}
4 4  
5 5  == Website ==
6 6  
9 +
7 7  1. Open the web.config on the web server
8 8  1. Look for the section with the connection strings
9 9  {{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>
... ... @@ -10,7 +10,7 @@
10 10  <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>
11 11  <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>
12 12  <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}}
13 -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 **;**
14 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];Encrypt=true" ></add>
15 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];Encrypt=true" ></add>
16 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];Encrypt=true" ></add>
... ... @@ -28,3 +28,46 @@
28 28  [[image:1623328456852-301.png]]
29 29  1. Click the **Generate STP File**  and save the STP file again
30 30  [[image:1623328525432-818.png]]
34 +
35 +== Database Settings ==
36 +
37 +
38 +=== Parent Service ===
39 +
40 +{{code language="SQL"}}
41 +UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
42 +WHERE txtConnStr NOT LIKE '%Encrypt%'
43 +
44 +UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
45 +WHERE txtDocConnStr NOT LIKE '%Encrypt%'
46 +
47 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
48 +WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
49 +
50 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
51 +WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
52 +
53 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
54 +WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
55 +{{/code}}
56 +
57 +=== System Settings ===
58 +
59 +{{code language="SQL"}}
60 +
61 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
62 +WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
63 +
64 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
65 +WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
66 +{{/code}}
67 +
68 +=== SSIS Service Steps ===
69 +
70 +{{code language="SQL"}}
71 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
72 +WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
73 +
74 +UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
75 +WHERE txtToConnectionString NOT LIKE '%Encrypt%'
76 +{{/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: