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

Posted: March 8, 2012 in BizTalk
Tags: , , ,

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 was 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 member of BizTalk Server Administrators group and this group have Administrator rights on both the SQL Server and the BizTalk Server.”

In my case, my user was member of 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 you user account and BizTalk Server Administrators group to the ‘Administrators’ group

Note: as I had no administrator rights in 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 have access to the BizTalk databases. In my case the group is db_ower of all BizTalk databases, have permission to connect to database engine and the login is enable.

error-creating-host-instance-sql-user-permission

References

Tags: BizTalk | Configuration | Hosts | Errors and Warnings, Causes and Solutions

Comments
  1. spinningtiger says:

    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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s