Summary

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

Details

Page properties

Content

...	...	@@ -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=')
	73	+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=')
	76	+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		-