- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
I’m looking for a way to configure biztalk to use a MSSQL server that is not in the same windows domain or in a trusted domain.
Our environment has a MSSQL server available on a remote machine, but we cannot join our biztalk server to the domain it is in nor setup any relationships between the two domains.
Ideally we’d use just username/password authentication (for a user in the MSSQL servers domain).
Any ideas?
-
When you use Biztalk with a separate SQL Server all security is managed through domain accounts and groups. The SQL Server databases make extensive use of these groups and accounts.
Back on Biztalk 2004 I managed to setup Biztalk and SQL on separate servers using local machine accounts and groups and synchronising passwords. This took significant effort and was very fragile. Any change would cause Biztalk to fail dramatically and would take a long time to diagnose and correct. I have never been silly enough to do it again.
I would suggest you use a SQL Server that is in the same domain as your Biztalk server.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.