172.68.3.38 at 17:27, 28 March 2024

2024-03-28T17:27:13Z

← Older revision		Revision as of 17:27, 28 March 2024
Line 14:		Line 14:

	Go to 176 (to server) bring database online (right click database in SQL > Tasks > Bring Online)		Go to 176 (to server) bring database online (right click database in SQL > Tasks > Bring Online)


	Run this query on server just brought online ------->		Run this query on server just brought online ------->


	OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'		OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'

	ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY		ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY


	EXEC sp_change_users_login 'Auto_Fix', 'oauser', NULL, 'admin'		EXEC sp_change_users_login 'Auto_Fix', 'oauser', NULL, 'admin'

	OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'		OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'

	OPEN SYMMETRIC KEY Card_Key_01		OPEN SYMMETRIC KEY Card_Key_01
	~~DECRYPTION~~ BY CERTIFICATE cardEncrypt;
			DECRYPTION BY CERTIFICATE cardEncrypt;

	GO		GO

	SELECT 'Unencrypted: ', SSN, 'Decrypted: ', CONVERT(varchar(20), DecryptByKey(EncryptedSSN)), 'Encrypted: ', EncryptedSSN
	FROM Distributor		SELECT 'Unencrypted: ', SSN, 'Decrypted: ', CONVERT(varchar(20), DecryptByKey(EncryptedSSN)), 'Encrypted: ', EncryptedSSN

			FROM Distributor


	GO		GO

	<-------------		<-------------

	Go to bottom of databases (176) > security > logins > SQLS03\Reports > User mapping (left side)> click check, newly added client database and ok		Go to bottom of databases (176) > security > logins > SQLS03\Reports > User mapping (left side)> click check, newly added client database and ok

	DONE WITH 175 AND 176. Go to Example_Client(remote desktop)		DONE WITH 175 AND 176. Go to Example_Client(remote desktop)
Line 40:		Line 53:

	Verify connection strings on 5 files C:\Program Files (x86)\Prodigix		Verify connection strings on 5 files C:\Program Files (x86)\Prodigix

	(		(
	prodigixsoftware.Ini
	OAParms.Ini		prodigixsoftware.Ini
	connection.Ini
	prodigix.config		OAParms.Ini
	CommissionCenter.exe.config
			connection.Ini

			prodigix.config

			CommissionCenter.exe.config

	)		)
	change any ip .175 to "PDXSQLDATA"
			change any ip .175 to "PDXSQLDATA"
	Update Report Center. From the clients remote desktop go to C:\inetpub\wwwroot\ReportCenter40, copy ReportCenter40, CTL A delete everything from original. from regular computor, open file explorer and connect to 134v$ and client remote desktop.
	copy reportcenter40 from 134 to client server. Go to ReportCenter40\web.config, change dev_prodigix to Example.Client_Live and .175 to PDXSQLDATA
			Update Report Center. From the clients remote desktop go to C:\inetpub\wwwroot\ReportCenter40, copy ReportCenter40, CTL A delete everything from original. from regular computor, open file explorer and connect to 134v$ and client remote desktop.
	If the report center doesn't work during your testing, check line 92 or //list reporting services report// of site.master.cs in C:\inetpub\wwwroot\ReportCenter40. change given line 90ish-92 to --> NetworkCredential cred = new NetworkCredential("reports", "!Prodigix1");
			copy reportcenter40 from 134 to client server. Go to ReportCenter40\web.config, change dev_prodigix to Example.Client_Live and .175 to PDXSQLDATA


			If the report center doesn't work during your testing, check line 92 or //list reporting services report// of site.master.cs in C:\inetpub\wwwroot\ReportCenter40. change given line 90ish-92 to --> NetworkCredential cred = new NetworkCredential("reports", "!Prodigix1");

	may need iisreset in terminal as admin		may need iisreset in terminal as admin

	if they have the dc 6.0 modify c> inetpub> wwwroot > distributorcenter60 > includes > config_database.asp change .175 to PDXSQLDATA		if they have the dc 6.0 modify c> inetpub> wwwroot > distributorcenter60 > includes > config_database.asp change .175 to PDXSQLDATA
	dc50 > includes > constants.asp line 148 switch to PDXSQLDATA. Update constants.settings.asp line 10 to client name and .176
			dc50 > includes > constants.asp line 148 switch to PDXSQLDATA. Update constants.settings.asp line 10 to client name and .176

	test rc/sc/dc/signup/upgrade/Commissions in OA		test rc/sc/dc/signup/upgrade/Commissions in OA

	134 vscource code web > dc50 > includes > constants.asp line 186 187 DONE		134 vscource code web > dc50 > includes > constants.asp line 186 187 DONE

172.68.1.135: Created page with " Verify no users are on server to be transfered (remote desktop > task manager > Users). connect to 176 file explorer (new server) d drive > Data > (Example_Client) > delete connect to 176 file explorer (new server) L drive > Logs > (Example_Client) > delete only works if desired database is offline 175(from server) take client database offline. click check box take clients offline. Copy d drive > Data > (Example_Client) from 175 to 176 File explorer Copy L drive..."

2024-03-28T17:26:37Z

Created page with " Verify no users are on server to be transfered (remote desktop > task manager > Users). connect to 176 file explorer (new server) d drive > Data > (Example_Client) > delete connect to 176 file explorer (new server) L drive > Logs > (Example_Client) > delete *only works if desired database is offline* 175(from server) take client database offline. click check box take clients offline. Copy d drive > Data > (Example_Client) from 175 to 176 File explorer Copy L drive..."

New page

Verify no users are on server to be transfered (remote desktop > task manager > Users).

connect to 176 file explorer (new server) d drive > Data > (Example_Client) > delete

connect to 176 file explorer (new server) L drive > Logs > (Example_Client) > delete *only works if desired database is offline*

175(from server) take client database offline. click check box take clients offline.

Copy d drive > Data > (Example_Client) from 175 to 176 File explorer

Copy L drive > logs > (Example_Client) from 175 to 176 File explorer

Go to 176 (to server) bring database online (right click database in SQL > Tasks > Bring Online)

Run this query on server just brought online ------->

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

EXEC sp_change_users_login 'Auto_Fix', 'oauser', NULL, 'admin'
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'asdfj;2l438as7dfj2;l3jk@#^@-81234-7sadj@FR@adswf^2%7yhadf'
OPEN SYMMETRIC KEY Card_Key_01
DECRYPTION BY CERTIFICATE cardEncrypt;
GO

SELECT 'Unencrypted: ', SSN, 'Decrypted: ', CONVERT(varchar(20), DecryptByKey(EncryptedSSN)), 'Encrypted: ', EncryptedSSN
FROM Distributor
GO
<-------------

Go to bottom of databases (176) > security > logins > SQLS03\Reports > User mapping (left side)> click check, newly added client database and ok

DONE WITH 175 AND 176. Go to Example_Client(remote desktop)

Go to file explorer on Example_Client(remote desktop) C:\Windows\System32\drivers\etc > open HOSTS file with notepad ++ > change ip at bottom from 175 to 176 and save (may need to be in admin mode)

Change ODBC 64 bit and ODBC 32 bit. Click icon > System DSN > double click 64bit (for 64) or 32 bit (for 32). login with admin password. Verify correct client pre populates. test connection. ok. finish.

Verify connection strings on 5 files C:\Program Files (x86)\Prodigix
(
prodigixsoftware.Ini
OAParms.Ini
connection.Ini
prodigix.config
CommissionCenter.exe.config
)
change any ip .175 to "PDXSQLDATA"

Update Report Center. From the clients remote desktop go to C:\inetpub\wwwroot\ReportCenter40, copy ReportCenter40, CTL A delete everything from original. from regular computor, open file explorer and connect to 134v$ and client remote desktop.
copy reportcenter40 from 134 to client server. Go to ReportCenter40\web.config, change dev_prodigix to Example.Client_Live and .175 to PDXSQLDATA

If the report center doesn't work during your testing, check line 92 or //list reporting services report// of site.master.cs in C:\inetpub\wwwroot\ReportCenter40. change given line 90ish-92 to --> NetworkCredential cred = new NetworkCredential("reports", "!Prodigix1");
may need iisreset in terminal as admin

if they have the dc 6.0 modify c> inetpub> wwwroot > distributorcenter60 > includes > config_database.asp change .175 to PDXSQLDATA
dc50 > includes > constants.asp line 148 switch to PDXSQLDATA. Update constants.settings.asp line 10 to client name and .176

test rc/sc/dc/signup/upgrade/Commissions in OA

134 vscource code web > dc50 > includes > constants.asp line 186 187 DONE

DataBaseServerMigration - Revision history

172.68.3.38 at 17:27, 28 March 2024