Changes for page How to enable encryption

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

Summary

Details

Page properties
Content
... ... @@ -6,7 +6,6 @@
6 6  
7 7  == Website ==
8 8  
9 -
10 10  1. Open the web.config on the web server
11 11  1. Look for the section with the connection strings
12 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,7 +13,7 @@
13 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 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 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 **;**
15 +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>
... ... @@ -31,46 +31,3 @@
31 31  [[image:1623328456852-301.png]]
32 32  1. Click the **Generate STP File**  and save the STP file again
33 33  [[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,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: