Score:0

Switched BizTalk's database domain, but cannot remove DC

cc flag

I've inherited an older system involving BizTalk (Server 2010) where the application and its database were on separate servers on separate domains.

There has been efforts to modernize the systems and applications, and I had to roll with it when the databases were upgraded from SQL Server 2008 to 2017. I thought it would reduce complexity if we at the same time moved the database from its domain to join the same domain that the application is in. Since it was the last artifact on the domain, we could then also remove the domain controller (theoretically.)

The database move happened in production, and it impersonates the older version so that BizTalk Server 2010 can still access it, and the application works - and this delighted me.

However, we attempted to remove the domain controller for the domain where the database lived before, and the application then failed saying it could no longer authenticate with the database. Upon turning on the domain controller, it started working again.

I have looked at what I believe are the BizTalk application settings and the database settings from SSMS, but I have no idea why there is still dependence on the domain controller we left behind. I have to assume previously, since the application and database lived in different domains, to get it working correctly there was some form of trust set up between the domains.

I have no knowledge of the domain controllers nor have access to them or their active directory. I need some direction and have searched the web a few times when I can, but to no real avail.

I figure it is either something I missed on the database or application end that I can still fix, or that it is involved with the configuration of AD on one or both domain controllers. If the latter is the case, then I need to know what to ask of the company's IT group to check, as they believe it is an application issue and are not being further helpful without specific details.

The business is leaning on me to do away with the older domain controller. What ideas are out there with regards to solving this?

This was originally asked on Stack Overflow (as I am a developer) but it didn't meet their guidelines and they suggested I post here instead. I had one response at that time, a helpful person who suggested I look for the old domain name using a search through the text of all tables of the BizTalk Management Database. I went through each one, and didn't find any references to the old domain name here. Hopefully that will help focus forthcoming assistance.

cn flag
You have to unconfigure the BizTalk server, the rerun the configuration wizard after joining the different domain. Any custom applications would also need to be reinstalled. Also this is a dead end of life product and is also off topic here. https://social.msdn.microsoft.com/Forums/en-US/d7b3f492-a176-4d85-8d3f-447603ac49f8/changing-domain?forum=biztalkgeneral
Temm avatar
cc flag
Ok. May take a while to get clearance to do this, but I will start the process. Thank you.
Dijkgraaf avatar
us flag
Also this article. https://social.technet.microsoft.com/wiki/contents/articles/24721.biztalk-server-step-by-step-guide-on-how-to-change-the-biztalk-server-group-domain-account.aspx I did also read that it is not supported by Microsoft that actually change domains for the BizTalk Servers.
Score:0
nc flag

This is no longer applicable as the company decided to abandon its solution and go with a new, hastily-put-together new solution involving different technology.

The answer in this case would be for companies to accept that migrations to new versions of operating systems and middleware is a good thing and will prevent people trying to cobble together unsupported server migrations using unsupported software and running into problems.

I honestly think, despite the effort involved in a proper BizTalk upgrade, that it still would've taken a shorter amount of time to perform the upgrade than it would have taken to create the new solution, and they would have had all the features they had to drop to make this happen.

Thank you all for your comments - much appreciated.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.