I have a 2 machines. 1 running SQL2000 and another where I installed Biztalk Partner edition. When I try to configure Biztalk and point it to create its databases on machine 1, it tells me I can’t have remote database connections with the Partner edition. Does anybody know which Biztalk edition allows me to point to a different machine to create the biztalk databases when configuring Biztalk?
You need to have the Standard Edition to use a Remote SQL. Also, I think the Partner Edition only works with the low end SQL Database (it’s free and included with the software).