BizTalk Error: If the BizTalk Server Computer Is Renamed After BizTalk Server Configuration, the Configuration Wizard Will Fail

This problem may manifest itself in several ways:

  • The configuration manager will load the Overview page correctly, but when attempting to configure a feature the feature options do not display on the screen.
  • The configuration wizard cannot connect to the SQL Server.
  • Attempting to Unconfigure All unconfigures some features, but not all.
Cause

The BizTalk Server configuration stores the computer network name. When the computer is renamed the configuration manager and configuration wizard cannot locate the BizTalk Server. A similar problem will occur if the SQL Server computer is renamed after BizTalk Server is configured.

Resolution

Do not rename the BizTalk Server computer or the SQL Server computer. If a server must be renamed, unconfigure all BizTalk Features before renaming the computer. After renaming the computer, reconfigure BizTalk Server features.

If you rename a SQL server you have to do this as well:

select @@servername

go

--If name is not correct to what you connect to, change it:

sp_dropserver OLDServerName

go

sp_addserver NewServerName, local

go

-- Restart SQL Service and verify with select @@servername again