3 min read
BizTalk Assessment: How to Check SQL Server version and cumulative updates
Sandro Pereira
May 18, 2026
When performing a BizTalk Server assessment, one of the first and most critical checks is the SQL Server version and patch level BizTalk Server depends
3 min read
BizTalk Server SQL Queries: Check if exists Orphaned Messages
Sandro Pereira
Oct 7, 2025
It’s been a while since I last wrote about BizTalk Server on the blog With so much happening around Azure Integration Services, I naturally focused more on
3 min read
SQL Server Integration Services Error: Connecting to the Integration Services service on the comp...
Sandro Pereira
Oct 30, 2024
Sometimes, it is fun to install new BizTalk Server environments, especially if you are not in the process/responsible for installing its prerequisites This
3 min read
SQL Server Error while trying to delete Job: Cannot perform this operation while SQLServerAgent i...
Sandro Pereira
Oct 29, 2024
Today, while installing a brand‑new BizTalk Server environment, the initial configuration attempt failed As a result, I tried to clean up the artifacts
2 min read
SQL Server Management Studio: The certificate chain was issued by an authority that is not trusted.
Sandro Pereira
Oct 28, 2024
Some time ago, I wrote a similar blog post describing this exact same error message while using the WCF-SQL Adapter of the BizTalk Server Today, I encountered
4 min read
BizTalk Maintenance Tasks: BizTalk MessageBox database size does not decrease after a shrink
Sandro Pereira
Sep 5, 2024
This week, while maintaining and fine‑tuning a BizTalk environment, I identified several non‑compliances One of them involved the BizTalk MessageBox
3 min read
BizTalk Server WCF-SQL adapter error: Subquery returned more than 1 value. This is not permitted ...
Sandro Pereira
Aug 28, 2024
Welcome back to another blog post on the saga of BizTalk Server errors and warnings, causes, and solutions This morning started off excitingly as I had to go
4 min read
How to install the Legacy SQL Adapter (Deprecated) in BizTalk Server 2020
Sandro Pereira
Jun 27, 2024
I wish I had never had to use this adapter again, but what I desire is often not reality, and I found myself needing to install once again the old legacy SQL
4 min read
Fixing “Target Principal Name is Incorrect” SQL connection error while trying to vali...
Luis Rigueira
May 29, 2024
I'm going to start quoting Sandro: "Sometimes the life of a developer is a nightmare, hehe" But it is also fun once you find the solution So, on one of
