This post was originally published here

Yesterday while troubleshooting a BizTalk Server developer environment at a client, I encountered an unusual error while trying to configure the BizTalk Server Backup job:

Could not find server ‘server name’ in sys.servers. 

Based on the error description, and by the fact that I was trying to run a SQL Server job, I knew that the error should be on the SQL Server side, some incorrect configurations,

Cause

Why this problem start to happen is unclear to me, and at the time I didn’t have all the information available to understand that. However, after investigating a little this error type I realize that we can execute a SQL query to check out what is your linked server:

select * from sys.servers

Or

Select @@SERVERNAME

The problem was that once I run these scripts, I realize the server name was not the expected one, it was incorrect! For example:

  • I was expecting BTS2020LAB01.
  • But instead, I was seeing VMIMAGE01.

And that was causing the failure on the Backup job and other BizTalk server jobs.

Solution

To solve this issue we need to fix that server name and for that, we can apply the following SQL script:

sp_dropserver 'VMIMAGE01'
GO
sp_addserver  'BTS2020LAB01',local
GO

After applying this script, make sure you restart the SQL Server service.

Once you have done these steps, you can successfully start your BizTalk Backup job.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.
View all posts by Sandro Pereira