Summary

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

Details

Page properties

Content

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