We are in the middle of installing BizTalk 2009 at my current company. Our database guru decided that all future databases would use database CNames, making the databases a little more flexible if future changes are needed. Flexibility is always a good thing.
A bit of background:
- We have a clustered SQL Server 2008 environment (Active/Passive failover) that BizTalk is using.
- We are installing most of the BizTalk install options.
- We are installing UDDI 3.0 and ESB 2.0 as well (LOTS of blog material on these two to come).
Unfortunately, we ran into problems with the BizTalk Server Configuration tool, as it's not consistent with itself. The Enterprise SSO and BizTalk Rules Engine configurations accept the CName just fine. However, the Group and BAM Tools don't recognize the CName at all... Maybe there were different developers between these sections?
Our database admin came up with another idea: use an alias in the SQL Server Configuration Manager, as shown below. We acknowledge that it wasn't the best solution, but it does allow us to have a single place where we can change the database name if needed.
That worked just fine for the BizTalk Configuration itself.
However, we ran into problems with this with the UDDI and ESB installs. Neither CNames nor Aliases worked - we had to put in the actual SQL Server name!
If anything, it's VERY inconsistent at best. Hopefully Microsoft will recognize this and make changes so that all setups/installers are consistent with each other.
There's also some more entries from Andy Morrison, who is helping me with the install.
