Installation of instance of host BizTalkSoapApplication on server … failed. Permission is denied. The current user does not have sufficient permissions to perform this operation.

Normally we tend to inherit BizTalk environments already installed and preconfigured, is not every day that we create an environment from scratch, this is one of these situations. It was given BizTalk Administrator permission to my user, i.e., my user was added to BizTalk Server Administrators group.

My first operations were to create some BizTalk Hosts, which went smoothly (for more information about this topic see Managing BizTalk Hosts and Host Instances)

However, when I was creating the Host Instances associated with BizTalk Hosts created previous, I obtained the following error:

TITLE: BizTalk Server Administration
——————————
Installation of instance of host BizTalkSoapApplication on server … failed.
For help, click: http://go.microsoft.com/fwlink/?LinkId=47400&ProdName=Microsoft+BizTalk+Server+2010&ProdVer=3.9.469.0&EvtSrc= Microsoft.BizTalk.Administration.SnapIn.Properties.Errors&EvtID=HostInstance_CreateFailed&EvtChain= BTSAdminMsg+%2c10294
——————————
ADDITIONAL INFORMATION:
Permission is denied. The current user does not have sufficient permissions to perform this operation. (WinMgmt)
For help, click: http://go.microsoft.com/fwlink/?LinkId=47400&ProdName=Microsoft+BizTalk+Server+2010&ProdVer=3.9.469.0&EvtSrc=BTSAdminMsg&EvtID=10294

error creating host instance

Cause

The additional information is explicit, this problem occurs because the user account that you’re using to configure BizTalk doesn’t have sufficient permissions.

Solution

  • When you install a host instance, you must have the privileges to create a Windows service, and to grant SQL Server logon and access rights for the BizTalk databases to the Host Windows user group.

I usually say: “To be able to install and configure BizTalk Server 2010 without problems, you have to log on the server using a Domain User who is a member of BizTalk Server Administrators group and this group has Administrator rights on both the SQL Server and the BizTalk Server.”

In my case, my user was a member of the BizTalk Server Administrators group, but this group didn’t have Administrator rights in BizTalk Server machine.

To add BizTalk Server Administrators group to the Local Administrators Group in both machines:

  • Click ‘Start’, ‘Control Panel’, ‘Administrator Tools’, ‘Computer Management’, ‘Local Users and Groups, ‘Groups’
  • Add your user account and BizTalk Server Administrators group to the ‘Administrators’ group

Note: as I had no administrator rights in the machine, I had to request to the system administrators to carry out this operation.

By default the Windows Builtin\Administrators group has the sysadmin SQL role on the SQL Server, however, we need to ensure that this group has access to the BizTalk databases. In my case, the group is db_ower of all BizTalk databases, have permission to connect to the database engine and the login is enabled.

error creating host- instance sql user permission
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.

2 thoughts on “Installation of instance of host BizTalkSoapApplication on server … failed. Permission is denied. The current user does not have sufficient permissions to perform this operation.”

  1. Hi, I have a similar problem, same error, but the SQL Server is a remote cluster and I don’t have sysadmin privileges to it. I can’t create anything such as the “SQL login and grant SQL privilege configurations on the Management database server”. The database and login already exist but there is no option to connect and use what already exists. I put in the user that is in the Administrators group and that has access to the database and still get this error.

    Is there any way to tell BizTalk NOT to try to create anything or grant anything, just use what is already there?

  2. I spent a day troubleshooting this until I realized I did not run PowerShell ISE in Administrator mode. Creating hosts from an unelevated script in ISE works fine and will not give you an error. On the other hand, creating host instances requires elevation. Sigh.

Leave a Reply

Your email address will not be published. Required fields are marked *

turbo360

Back to Top