Reconfiguring Factory Shipped CMS
White paper | Reconfiguring Factory Shipped CMS
6 | April 16, 2013
Manual Steps Needed
1. Edit and regenerate the PXE boot images for RDP.
DB-Change-CMSreconfig.ps1
Scope
The DB-change-CMSreconfig.ps1 script is executed from within the Domain Acct change script. If
the databases are to be moved the DB change option must be executed from the CMS-reconfig
wrapper script which includes the Domain Acct change.
Pre-requisites
CMS must be joined to the domain
New user account must be created on the domain
SQL server exists in the same or trusted domain as CMS
The CMS resolves the DNS name of the remote SQL Server
New user account must be added to remote SQL-Server
Host name/IP change must be been completed (if applicable).
User must be logged in with a domain account with local administrator’s privileges
Execute the below command in PowerShell from the directory where DB-Change-
CMSreconfig.ps1 script is present before you execute option-5
(Get-Content DB-Change-CMSreconfig.ps1) | ForEach-Object { $_ -replace
[Regex]::Escape('$newDBUser = $shortName + "\\" + $domain'), '$newDBUser = $domain
+ "\\" + $shortName' } | Set-Content DB-Change-CMSreconfig.ps1
Automated Steps
1. Executes the first 12 steps of the Domain-Acc-CMSreconfig script
2. Prompts the user for the remote SQL Server parameters
3. Verifies the connectivity to the remote SQL Server
4. Stops the CMS services
5. Updates the database parameters in the RDP configuration files.
6. Updates the ODBC connections
7. Detaches the databases from the local SQL server on the CMS
8. Outputs the data file path and filenames to a .txt document
9. Presents the text document to the user.
10. Opens an Explorer window to view the data files
11. Pauses for manual move of databases
12. MANUAL STEPS FOR DATABASE MOVE
a. Copy the database data and log files to the remote SQL Server
b. Attach the databases on the remote SQL Server
c. Map the domain user account to dbo of the CMS databases
13. Attempts a connection to each moved database and outputs results to log
14. Executes the mxreconfig sqlredirect command
15. Do not re-start the SIM services after sqlredirect. Select N when it asks for re-starting
the services.
16. Updates the IO and OO configuration files for the remote databases
Manual Steps Needed
1. Edit and regenerate the PXE boot images for RDP.
2. Reboot the CMS.