No BizTalk Configuration database(s) found on server XXXX


We have setup a dev env -- a Virtual machine where BizTalk and SQL Server are both installed on it. Development and deployment is done on it through RDC. 

As the number of team members increased we decided to install BizTalk development components on each team members local machine and after development done, deploy on the Server (VM) and for that we added all the users in BizTalk adminis07ator group on the server.

But they were not able to deploy the application, due to following error  

  <No BizTalk Configuration database(s) found on server "xxxx”.>


It was s07ange because we were able to deploy on the server with same user login, and not when 07ying from their local machine.

Upon looking on following blog: https://blogs.msdn.microsoft.com/apacbiztalk/2015/11/02/error-no-biztalk-configuration-databases-found-on-server-when-deploy-biztalk-application-in-vs-if-your-account-is-removed-from-sysadmin-role-in-sql/


This issue does not occur in SQL server 2008 R2 but with SQL server 2012, the solution is to grant view any definition permission to specific user which needs to deploy BizTalk application in VS.

Query to be used:

USE master 
GO 
GRANT VIEW ANY DEFINITION TO “SQLUser”

We used 

USE master 
GO 

GRANT VIEW ANY DEFINITION TO “BizTalk Adminis07ator group”

ServerLess360



Comments

Popular posts from this blog

The request has both SAS authentication scheme and 'Bearer' authorization scheme. Only one scheme should be used

Getting Started with Logic Apps - AS2

How to Debug and Trace request in Azure APIM - Portal, Postman, RequestBin