Say you have 2 Biztalk/SQL server set ups:

Setup 1:
Biztalk server: Biztalk01
SQL server: SQL01

Setup 2:
Biztalk server: Biztalk02
SQL server: SQL02

And if your Visual Development environment is on Biztalk01.

If you change MgmtDBServer on Biztalk01 to point to SQL02 because you
want to add a EDI send port on Biztalk02, you will notice your
Biztalk server service on Biztalk01 stop working, because it is now
trying to connect to SQL02 as its management database.

So before switching MgmtDBServer to point to a different SQL server,
I'd recommend you stop the Biztalk service on Biztalk01 first.  And
after you add the send port to the second server, remember to put
MgmtDBServer back to the original SQL server setting.

[ Post a follow-up to this message ]