Summary

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

Details

Page properties

Content

...	...	@@ -31,3 +31,46 @@
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}}