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”
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”
Comments
Post a Comment