Rename BizTalk 2006 Server (Details)
I posted about this previously, but I wanted to post the steps I used to actually rename the server.
- Open BizTalk Server Configuration and Unconfigure all features
- Exit the BizTalk Server Configuration
- Open SQL Server Management Studio and connect to the server
- Expand your server in the Object Explorer and expand the Notification Services node
- Right click on the BAMAlerts instance and select Disable
- Right click on the BAMAlerts instance and select Stop
- Right click on the BAMAlerts instance, point to Tasks, and then select Unregister
- Right click on the BAMAlerts instance, point to Tasks, and then select Delete
- In the Object Explorer click on the Databases node
- In the Summary tab on the right of the screen, highlight all databases (do not highlight System Databases or Database Snapshots)
- Right click on the highlighted databases and select "Delete"
The Delete Objects screen will appear, as shown below. Ensure the options are selected as shown in this screenshot, and click OK
- If you receive any errors while deleting databases, expand the Management – Activity Monitor option under your SQL server in Object Explorer and kill any processes running against the database you're trying to delete
- In Object Explorer, expand Security – Logins and delete all logins used by the previously deleted databases
- Close the SQL Server Management Studio
- Change computer name
- Restart and log in (ignore any failed service startup messages)
- Open SQL Server Management Studio and connect to server using new computer name assigned above
- Open a New Query Window (click the New Query button in the toolbar)
- Enter the following commands, replacing <old_name> and <new_name> with the old and new computer names, respectively
sp_dropserver '<old_name>'
GO
sp_addserver '<new_name>', 'local'
GO
Execute the commands by clicking the "Execute" button in the toolbar or hitting F5 on your keyboard
- If you receive any errors during the sp_dropserver command, execute sp_helpserver and copy the value of network_name for the <old_name> server and paste it into your sp_dropserver parameter, including any spaces
- Restart SQL Server (Right-click on your server under the Object Explorer and select "Restart"), ignoring any errors that appear
Open Internet Information Services (IIS) from the Start menu
- Expand Web Sites, Default Web Site and delete the BAM application (if it's not there, move on to the next step)
- Expand Application Pools and delete the BAMAppPool (if it's not there, move on to the next step)
- Open BizTalk Server Configuration from the Start menu
Perform a Basic Configuration using your new computer name as the Database server name and a current local account as the username for the service credential
- When the configuration is complete review the results to ensure all features were successfully configured. If any failed, there will be a red "X" next to the failed feature.
- Any failed features will need to be manually configured, so ensure the option to launch the custom configuration is checked before closing the wizard
- For each failed feature, click on the option in the left pane of the configuration screen and configure the options in the right pane. Usually, the configuration involves setting a username and password for a service.
- Once the configuration is complete, export the configuration and save the file
Open BizTalk 2006 Administration Console
- Expand BizTalk Server 2006 Administration and right-click on the BizTalk Group for <old_name> and select Remove (If the BizTalk Group shown is already using your new computer name skip this step)
- Right-click on BizTalk Server 2006 Administration and select "Connect to Existing Group"
- Select your new SQL Server
- Select the database (BizTalkMgmtDb)
- Click OK
- Restart the machine
Turn on automatic updates and download and apply any available updates