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 favorites topics … no not transformations, this time is all about “Errors and Warnings, Causes and
6 min read
BizTalk Server 2013 R2: Installation and Configuration – Install SQL Server 2014 (Part 7)
Sandro Pereira
Jan 11, 2015
This next posts will focus on installing the BizTalk prerequisites and perform the necessary configuration on the BizTalk Server machine Before installing
2 min read
SQL Queries to Enable or Disable All BizTalk SQL Server Agent jobs
Sandro Pereira
Nov 18, 2014
BizTalk is shipped out with a total of 13 SQL Agent jobs Experienced BizTalk professionals know that all the BizTalk SQL Server Agent jobs except the
4 min read
New release: Managing and cleaning BizTalk Server MarkLog database tables: sp_DeleteBackupHistory...
Sandro Pereira
May 26, 2014
Almost three weeks ago in my last post I release a SQL script to manage and delete the unnecessary records in the BizTalk “MarkLog” tables according to
7 min read
Managing and cleaning BizTalk Server MarkLog database tables according to some Best Practices
Sandro Pereira
May 6, 2014
All the BizTalk databases which is being backed up by the 'Backup BizTalk Server' job, so all databases with the exception of the BAM Star Schema database
3 min read
A different way to Force a Full Backup of the BizTalk Server databases
Sandro Pereira
Apr 15, 2014
BizTalk Server databases and their health are very important for a successful BizTalk Server database messaging environment BizTalk is shipped out with a
6 min read
How to create a Maintenance Plan to delete BizTalk Database Backups files
Sandro Pereira
Jun 26, 2013
BizTalk Server database databases and their health are very important for a successful BizTalk Server database messaging environment This is nothing new and
4 min read
How to configure SQL Server Network Protocols in the SQL Server that houses BizTalk Server databa...
Sandro Pereira
Apr 4, 2013
Today is a special day for me, it’s my birthday, and I will continue the tradition of giving something to the community on this day (I started this
13 min read
BAM Portal Errors – Failed to list permissions for BAM view. System.Data.SqlTypes.SqlNullVa...
Sandro Pereira
Dec 4, 2012
I decided to put the name of the error in the post title but this post also could be called “Why you shouldn’t delete Active Directory accounts (if you
