Creating BizTalk Server 2016 Developer from Azure Gallery Image

Creating BizTalk Server 2016 Developer from Azure Gallery Image

Published by: Bill Chesnut

The process for creating a BizTalk 2016 Developer machine with 2016 has changed from the previous versions, the Azure Gallery Image does not have SQL, Visual Studio or BizTalk installed, so I will walk you through those steps here.

Start with either the Classic or ARM Azure Gallery Image (ARM Image show below)


Logon to your newly created machine


You might want to turn off the IE Enhanced Security Configuration or you will be prompted for every website you visit


The image does not contain Visual Studio or SQL so you will need to download those:

You might need to signup for a free Visual Studio Dev Essentials subscription on

SQL 2016 Developer:


Visual Studio 2015 (Community is free, use Professional or Enterprise if you have an MSDN subscription)


SQL Server Management Tools –

You should now have these files in your download directory


Installing SQL 2016 Developer Edition

We are now going to install SQL 2016 Developer Edition on the image

Note: for this installation I will be using the Administrator (bizadmin) for all services, you can use the accounts dictated by your companies security policies

Installing SQL Management Tools

We are now going to install SQL 2016 Management Tools on the image

Double Click on the setup application image
Click Install image
Installation Complete, Click Close image

Installing Visual Studio 2015 Community Edition

We are now going to install Visual Studio 2015 Community Edition on the image

Note: if you have MSDN subscription, feel free to install professional or enterprise

Installing BizTalk Server 2016 Developer Edition

We are now going to install BizTalk Server 2016 Developer Edition on the image

Configuring BizTalk Server 2016 Developer Edition

We are now going to configure BizTalk Server 2016 Developer Edition on the image

Enter the “User name” and “Password” that you want to use for the BizTalk Server Services, I am using the administrators account but feel free to create and use another account

Click Configure

Note: Ignore the warning about administrator account, this is a developer machine not production

Click Next image
Configuration Complete

Click Finish


Installing LOB Adapters

We are now going to Install the LOB Adapters & SDK on the image

Double Click on Setup image
Click “Install Microsoft BizTalk Adapters” image
Click Step 1… to install SDK

Follow Setup Wizard

Note: I typically do a Complete install in everything in the Adapter Pack on a developer machine

Click Step 2… to install Adapter Pack

Follow Setup Wizard

Note: I typically do a Complete install in everything in the Adapter Pack on a developer machine

Click Step 3… to install Adapter Pack (x64)

Follow Setup Wizard

Note: I typically do a Complete install in everything in the Adapter Pack on a developer machine

Click Step 4… to install Adapter for Enterprise Applications

Follow Setup Wizard

Note: I typically do a Complete install in everything in the Adapter Pack on a developer machine

Open the BizTalk Server Administration Console

Expand Tree, Right Click Adapters, Click New, Click Adapter

Type Name WCF-SQL, Select WCF-SQL from Adapter drop down list

Click OK

Note: this is the only adapter I typically add, but feel free to add the rest of the adapters if you development project is going to need them.


Installing & Configuring ESB Toolkit (Optional)

We are now going to Install and Configure ESB Toolkit on the image

Final Configuration for Developer Image

We are now going to do the final configuration on the image

Open Microsoft SQL Server Management Studio from the Menu image
Connect to your database server

Click Connect

Note: full stop or period means local machine

Click “New Query” image
For a developer image of BizTalk is it not necessary to create transaction logs for the BizTalk Databases, so the command below will set all database into simple recovery mode so no transaction logs are created and not database backups are required

Execute the Query

select ‘alter database [‘+name+’] set recovery simple’ from master.sys.databases where database_id > 4 and state_desc = ‘online’

Copy the output of the previous command into a new query window image
Click Execute

Note: all the databases are in simple recovery mode so there is no need to configure the BizTalk Backup Job

To keep the tracking database for becoming large on the developer image, we need to setup the DTA Purge Job

Right click on the “DTA Purge and Archive (BizTalkDTADb)”

Click Properties

Change the name to “DTA Purge (BizTalkDTADb)”

Click Steps

Edit the Step image
Change the step name to “Purge”

Update the Command to the text below

Click Ok, Click Ok

declare @dtLastBackup datetime
set @dtLastBackup = GetUTCDate()
exec dtasp_PurgeTrackingDatabase 1, 10, 11, @dtLastBackup

Right click on the “DTA Purge (BizTalkDTADb)”

Click Enable

Note: you can then do the same and select “Start Job at Step” to make sure you don’t have any syntax errors.



This finished the basic configuration with a few extra, if you are using BizUnit, BTDF, SpecFlow or any other tools, you will need to install them now.

I would also recommend running windows update to get the latest updates installed

I hope this instruction and screen shots help you get your BizTalk Server 2016 Developer Azure Gallery Image up and running smoothly

Looking back on another great year…

Looking back on another great year…

The first month of 2017 is almost over, and I was thinking back on my experiences over the last year. Looking at the integration space, 2016 was the year where Azure really matured. Of course, we already have been having the Service Bus stack for quite some time, but last year we also had Logic Apps go GA, which allows us to create flows in Azure, and easily connecting cloud services. And later in the year, Azure Functions went live as well, which gives us the ability to write small pieces of code, which can also be used from Locic Apps, closing the gap for custom code. And this was also the year we got a new BizTalk Server release, BizTalk 2016, which brings us even better integration with Azure, allowing us to focus even more on hybrid integration scenarios. For me personally, this was a year where I had lot of fun speaking, writing and visiting conferences.

BizTalk Server Extensibility Book

In March, we published our book which I wrote together with Steef-Jan Wiggers and Johann Cooper. In this book, we describe various ways in which you can extend BizTalk, like custom pipelines, adapters, BAM, WCF Behaviors, etc. I had a blast writing this book, it was awesome to be able to work together with these two great minds and put our experiences with a great product into this book, which is free for everyone to download.


In May, i attended Integrate, a must visit conference for anyone working with Microsoft’s integration technologies. Organized by BizTalk360, this was 3 days full of great sessions on integration, and discussion and socializing with the product group and fellow integrators. Make sure to be there this year as well, and come and say hi, it will be held June 26,27,28, and registrations will open soon.

Also in may, I visited TUGA IT in Portugal, where I had a great time together with my friends Steef-Jan, Sandro and Nino.


I love getting involved with the community, and what better way to do this then visit as much of usergroup meetings as I can. I will visit these whenever I can, either as a participant or as a speaker, and always have a blast. At our local user group here in the Netherlands, BTUG NL, I got to do 2 sessions this year. My first session was in March, which was actually a duo session together with my good friend Steef-Jan, where we talked about BizTalk Server Extensibility, of course inspired by our book. My second session was in November, this time on Hybrid Integration using BizTalk and Azure.

For me this was also the year I got to speak internationally, to be precise in Sweden and Belgium. I did another duo-session with Steef-Jan in Sweden in June, both in Stockholm and Goteborg. Sweden is such a nice country, with really friendly people, and being able to speak here together with Steef-Jan was a great experience. I also try to visit our friends from Belgium at BTUG BE as often as possible. They have a great community, and I also got the chance to speak here in June, on IoT and Azure.

Integration Monday

Every Monday Michael Stephenson and Saravana Kumar bring in another speaker on Integration Monday, talking about something integration related. I got to do 2 sessions here, one in March on BizTalk Server Extensibility together with Steef-Jan, and another on IoT and Azure in September. Doing these sessions is very different, as you don’t have an audience in front of you, but I love doing these, as you get to share with a global community.

The year 2017 started especially great for me, as on January 1st I received my first MVP Award. I can’t express how honored I am with this, it feels awesome to be part of such a great community.

I did another session on Integration Monday in January, this time on Hybrid Integration. But it’s only the beginning of the year, and I have a lot more planned. As I already mentioned, I will be going to Integrate in June, but first I will be going to Australia in February. Here I will be meeting with Rene, Mick, Dean, Bill, Dan and many others, I will be speaking in Sydney and Melbourne, and will be attending Ignite. I am one of the organizers of the Global Integration Bootcamp which will be done in March, where communities worldwide will be spending an entire day with integration using BizTalk and Azure, and I will be speaking here myself as well. I will be back in Sweden to do another session as well, probably in April, and will also be in Portugal in May for another TUGA IT. As you can tell, this will be another great year, and I am looking forward to catch up with old friends, and meet many new friends.

Year 2016 in review, Integration is still relevant

Year 2016 in review, Integration is still relevant

Last few hours before 2016 ends and what a year it has been as so many things happened. The year started off with finalizing and publishing an eBook on extensibility of BizTalk Server, which is available for free. My buddy Saravana made available through BizTalk360 website.

The publishing of the book marked the first major milestone in 2016. The collaboration of Eldert, Johann and myself as authors and three awesome reviewers in Mark, James and Sandro delivered a 150-page book on the power of .NET and BizTalk.
With the release of the book, Eldert and myself embarked on a speaking tour to promote the book, which we did in front of the BizTalk User Group in the Netherlands, online through integration Monday and in Sweden (Stockholm, Gothenburg). Thanks Mikael, Johan and Peter!!!

In the spring (May) I presented at Integrate 2016 on IoT end to end leveraging the Microsoft Azure Platform services. And this was in front of almost 400 people.

Who would have thought that integration is irrelevant? It’s not! Thanks for  Saravana and the BizTalk360 team for making this three-day event happening. Integrate 2016 was a success and for me my second major milestone in 2016.

Before Integrate 2016 Kent, his wife Melissa travelled through the UK and Scotland enjoying various country sides. One of the best days was hanging out with Michael in Newcastle. A really nice place with some great bars and restaurants.

After Integrate I went to TUGA IT, a large two-day conference in Lisbon. Thanks to Sandro I got invited to speak together with Nino. The three of us did a full day workshop on integration on Friday and a few talks on Saturday.

We had a blast and I really enjoyed Lisbon together with Nino and Sandro. Thanks to Niko Neugebauer and other Portuguese involved! Before I left I spend a full day exploring Lisbon with Sandro.

After Integrate and TUGA IT I went to Sweden with Eldert to talk about BizTalk Extensibility and another topic Azure Web Jobs. Sweden and its user groups are awesome, great welcome, excellent hosting environments and crowd. In Stockholm, we had a great user group event with several speakers including Mikael, Johan, Eldert, Robin, Ashwin and myself. The next day Eldert and myself went to Gothenburg to speak on extensibility and Web Jobs.

The summer holidays I spent in Italy and started to seriously prepare for third major milestone in 2016, the NYC marathon. In 2013 I ran the Berlin marathon together with Kent and decided or at least I said I will do another, preferably New York. Once Kent and his brother Kurt decided they wanted to run it when they turned 40 I said I am in!

The race was brutal and the bridges were quite the experience and challenge. It was a psychical and mental test yet I managed to finish with 5 hours.

My Canadian buddies finished just a few minutes later and then we enjoyed our medals with some great food and beers.

Thanks Kent and Kurt for letting me join in this endeavor. Our next challenge might be in 2018.

The next stop after the Marathon was the MVP Summit, which started the day after NYC Marathon. And to start things of was a nice game of the Seahawks playing the Bills. Lots of MVP and some MS folks went to the game.

The MVP Summit was a great experience as there was lots to share and engagements with the product teams.

You always run into someone you know ☺

This summit took place during the elections, hence we spent an evening together at Dan and Ola, who organized a great barbeque.

The outcome was not what we thought it would be, however, we still had a great time.

One of the traditions during the Summit is visiting Joey’s in Bellevue, which of course we did.

And Moksha our favorite Indian Cuisine place.

Another thing we did was visiting Tord, PG BizTalk Server and his family in Redmond.

And the BizTalk Crew was reunited once again.

We know BizTalk Server is in good hands now!
I really enjoyed my stay in Seattle. I went to another football game with Kent. We watched the Washington Huskies.

Before I left Seattle, I spent some time with my great friend Tom and his wife JoAnn. We watched the Seahawks play the Patriots on Sunday in a bar. Yes, more American Football, I love it. And it was an epic game, with the Hawks winning the game and cheers in the bar!

It was quite a trip, New York, running the Marathon followed by the MVP Summit. Something to remember as long as I will live.

In November and December I spend time writing some quest blogs for Saravana, a LinkedIn article on today’s integration and presenting at our Local user group.

In 2017 I, will kick the tires with some speaking engagements in Australia. In February I, will spent two and a half week with Mick, Eldert, Rene, Dean, Bill, Dan and many others. This will be followed by the global integration boot camp in March, where I’ll be speaking at the location of motion10 together with Eldert, Rob, Gijs, and Tomasso. In April and May I will be on the road to probably to speak in Portugal, Sweden and some other countries or venues. It will be an interesting year 2017!

P.S. I lost some kind of bet I have to wear some jersey with a name of a soccer player I really like, NOT!!!