Changes for page How to enable encryption

Last modified by Gideon Lombard on 2021/08/12 10:55
<
From version < 31.1 >
edited by Gideon Lombard
on 2021/08/12 10:49
To version < 29.1 >
edited by Gideon Lombard
on 2021/08/12 10:44
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -36,22 +36,13 @@
36 36  
37 37  1. (% id="cke_bm_1117S" style="display:none" %) (%%)Open the **Everest_SMSService.exe.config** on the web server with **Notepad**
38 38  1. Look for the section with the connection strings
39 -{{code language="xml"}}<connectionStrings>
40 - <add name="dbConn" providerName="System.Data.SqlClient" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password]"/>
41 - </connectionStrings>{{/code}}
42 -1. (% id="cke_bm_1488S" style="display:none" %) (%%) If there is not an **Encrypt=true** **and TrustServerCertificate=true **as part of the connection string you will need to add it separated with a **;**
43 -{{code language="xml"}}<connectionStrings>
44 - <add name="dbConn" providerName="System.Data.SqlClient" connectionString="Data Source=127.0.0.1;Initial Catalog=[database name];Persist Security Info=True;User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true"/>
45 - </connectionStrings>{{/code}}
46 -
47 -== Parent Service - Client ==
48 -
49 -1. (% id="cke_bm_849S" style="display:none" %) (%%)Open the **EBSParentService.exe.config** on the web server with **Notepad**
50 -1. Look for the section with the connection strings
51 51  {{code language="xml"}}<databaseConnections>
52 52   <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password]" ></add>
53 53   </databaseConnections>{{/code}}
54 54  1. (% id="cke_bm_1488S" style="display:none" %) (%%) If there is not an **Encrypt=true** **and TrustServerCertificate=true **as part of the connection string you will need to add it separated with a **;**
43 +{{code language="xml"}}<databaseConnections>
44 + <add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password];Encrypt=true;TrustServerCertificate=true" ></add>
45 + </databaseConnections>{{/code}}
55 55  
56 56  == Database Settings ==
57 57  
... ... @@ -79,10 +79,10 @@
79 79  
80 80  {{code language="SQL"}}
81 81  
82 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
73 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
83 83  WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
84 84  
85 -UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
76 +UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
86 86  WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
87 87  {{/code}}
88 88  
... ... @@ -95,3 +95,4 @@
95 95  UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
96 96  WHERE txtToConnectionString NOT LIKE '%Encrypt%'
97 97  {{/code}}
89 +

Applications

Navigation

Need help?

If you need help with XWiki you can contact: