5 min read
BizTalk WCF-SQL Error: Microsoft.ServiceModel.Channels.Common.MetadataException: Object [dbo].[St...
Sandro Pereira
Jul 4, 2018
I told you in my last blog post that an error never comes alone when an error appears, it always appears in pairs Or that, or I have a tendency to attract,
4 min read
DTA Purge and Archive (BizTalkDTADb) job: Procedure or function dtasp_PurgeTrackingDatabase has t...
Sandro Pereira
Oct 9, 2017
I normally advise my clients or partners to “religious” follow the order and steps of my BizTalk Server Installation and Configuration guide, an advice
4 min read
WCF-SQL Adapter: Connecting to the LOB system has failed. A network-related or instance-specific ...
Sandro Pereira
Aug 27, 2017
I been delivering a lot of BizTalk Server Training Courses for Developers and for Administrator in the past years that I normally like to call them Developing
3 min read
Empowering Hybrid Integration recording is now online on Channel 9
Sandro Pereira
Apr 5, 2017
Well, the Empowering Hybrid Integration segment has been online since January 30, 2017, but only now I realize that… During the MVP Global Summit,
3 min read
An error occurred while attempting to connect to a remote SQL Server database: The local MS DTC d...
Sandro Pereira
Nov 23, 2016
Today I’m returning to one of my favorite topics … no, not transformations, this time it's all about Errors and Warnings, Causes and Solutions Today I
3 min read
BizTalk WCF-SQL Adapter: The columns “…” are either duplicated or not in a sequence. Each column ...
Sandro Pereira
Apr 9, 2015
This week, while migrating a demo that I will present at the BizTalk Summit 2015 - London event, from BizTalk Server 2013/Visual Studio 2012 to BizTalk Server
3 min read
BizTalk Server 2013 R2: Installation and Configuration – Configure SQL Server Network Configurati...
Sandro Pereira
Jan 14, 2015
The next posts will focus on installing and configuring BizTalk Server 2013 R2 and additional components Make sure that you have installed all the latest
7 min read
BizTalk Server 2013 R2: Installation and Configuration – Install SQL Server 2014 (Part 7)
Sandro Pereira
Jan 11, 2015
The next posts will focus on installing the BizTalk prerequisites and performing the necessary configuration on the BizTalk Server machine Before
3 min read
SQL Queries to Enable or Disable All BizTalk SQL Server Agent jobs
Sandro Pereira
Nov 18, 2014
BizTalk Server installs a total of 13 SQL Server Agent jobsExperienced BizTalk administrators know that almost all of these jobs must remain enabled and run
