Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -36,11 +36,22 @@
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]"></add>
	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"></add>
	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
39	39	{{code language="xml"}}<databaseConnections>
40	40	<add key="Everest" value="Data Source=127.0.0.1;Initial Catalog=[database name];User ID=[username];Password=[password]" ></add>
41	41	</databaseConnections>{{/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"}}<databaseConnections>
	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 **;**{{code language="xml"}}<databaseConnections>
44	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	45	</databaseConnections>{{/code}}
46	46
...	...	@@ -70,10 +70,10 @@
70	70
71	71	{{code language="SQL"}}
72	72
73		-UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
	84	+UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
74	74	WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
75	75
76		-UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
	87	+UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;TrustServerCertificate=true;pwd='), ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
77	77	WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
78	78	{{/code}}
79	79
...	...	@@ -86,4 +86,3 @@
86	86	UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;TrustServerCertificate=true;Password=')
87	87	WHERE txtToConnectionString NOT LIKE '%Encrypt%'
88	88	{{/code}}
89		-