Oct 30

SQL Server Integration Services Error: Connecting to the Integration Services service on the comp...

Sometimes, it is fun to install new BizTalk Server environments, especially if you are not in the process/responsible for installing its prerequirements This

By Sandro Pereira

Oct 29

SQL Server Error while trying to delete Job: Cannot perform this operation while SQLServerAgent i...

Today, while installing a brand new BizTalk Server environment and after the first attempt to configure BizTalk Server failed, I encountered this error while

By Sandro Pereira

Oct 28

SQL Server Management Studio: The certificate chain was issued by an authority that is not trusted.

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

By Sandro Pereira

Sep 5

BizTalk Maintenance Tasks: BizTalk MessageBox database size does not decrease after a shrink

While maintaining and fine-tuning a BizTalk environment this week, I found out, alongside other non-compliances, that the BizTalk MessageBox database size was

By Sandro Pereira

May 29

Fixing “Target Principal Name is Incorrect” SQL connection error while trying to vali...

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

By Luis Rigueira

Apr 24

There was a failure executing the send pipeline: Microsoft.BizTalk.DefaultPipelines.XMLTransmit, ...

I wrote this issue many years ago in this blog post, and I'm revisiting it to add more information about it because today I got the same error while trying to

By Sandro Pereira

Apr 18

BizTalk Server WCF-SQL: The certificate chain was issued by an authority that is not trusted.

Today, while trying to generate a new WCF-SQL Schema from Visual Studio, we got the following error: Connecting to the LOB system has failed  A

By Sandro Pereira

Apr 9

BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...

Following yesterday's blog post, on the same note, when we tried to generate a WCF-SQL stored procedure schema for a new BizTalk Server solution, we got the

By Sandro Pereira

Apr 8

BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...

Today while importing/generating a WCF-SQL schema for a new BizTalk Server solution, we got the following error inside Visual Studio: Error while

By Sandro Pereira

Mar 15

PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption

A few days ago, Luis Rigueira created a Kusto query to identify all Logic Apps Consumptions that use SQL V1 actions and triggers that will soon be deprecated

By Sandro Pereira
turbo360

Back to Top