Have Geek Brain

Can Biztalk use a remote MSQL server on a different non-trust domain?

I have a remote MSQL instance that I want to use with biztalk. My biztalk machine cannot join the same domain as the MSSQL instance and we cannot create trusts between the two Windows domains.

Is there a way to configure biztalk for authentication? The username / password (like any other DB) will be fine.

0


a source to share


1 answer


If you're talking about using SQL Server as the primary data layer for your BizTalk installation, then maybe. There's an old trick in which you create local accounts on both servers with sam credentials (id and password) and then use the local account for your services. This is hack and not recommended.



For the SQL Server adapter, just provide the credentials in the conneciton line. Can be a SQL account or a remote domain account.

0


a source






More articles:


All Articles