Reconfiguring Factory Shipped CMS
White paper | Reconfiguring Factory Shipped CMS
4 | April 16, 2013
Automated Steps
1. Retrieves the old host name from SQL server – “select @@servername”
2. Retrieves the old CMSip and RDPip from the software-settings.xml file
3. Retrieves the list of current IPs assigned to CMS
4. Prompts the user to select the current IPs for RDP interface.
5. Makes the following configuration changes for RDP
a. Name and IP changes in RDP configuration files
b. ODBC entry for eXpress database
c. Mxnodesecurity entry for dsc_rdp protocol
6. Executes the mxreconfig sqlredirect command
7. Executes the mxreconfig relocateUnusedCMS
8. Changes the host name in SQL server
Manual Steps Needed
1. Re-start the SQLServer database service.
2. Run the following command in Windows PowerShell:
a. SQLCMD.EXE –Q “SELECT SUSER_SNAME(OWNER_SID) from sys.databases”
b. If the query result does not have the new host name as part of the DB owner
name, then execute the following command, else go to step 3
c. SQLCMD.EXE –Q “ALTER LOGIN [OldHostName\USER] with name =
[NewHostname\USER]”
3. Edit and regenerate the PXE boot images for RDP.
Local-Acct-CMSreconfig.ps1
Scope
The Local-Acct-CMSreconfig.ps1 script is used only for the initial reconfiguration, as it depends on
the values in the software-settings.xml file.
Pre-requisites
Host name/IP change must be completed (if applicable).
User must be logged in as initial installation account
The local or domain username/hostname must not contain the character $
Automated Steps
1. Prompts the user for new local account credentials
2. Creates the new local account
3. Adds the new account to administrators and HPIO administrator’s group
4. Launches the OO administrator via Internet Explorer to change OO administrator
password
5. Adds the new account logon to SQL -server as dbo for ID databases
6. Changes the service accounts of the new user
7. Updates the RDP configuration files
8. Executes the mxreconfig sqlredirect command for the new user
mxreconfig -m sqlredirect -s $cmsName -b $db -a $fullName -p 1433 -v >> $env:logfile
2>&1
9. Updates the mxnodesecurity entry for the dsc_rdp protocol
Manual Steps Needed
1. Edit and regenerate the PXE boot images for RDP.
2. Verify if all the services are up and running. If not, restart the database services.