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 administrator 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 strange because we were able to deploy on the server with same user login, and not when trying 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 Administrator 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 administrator 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 strange because we were able to deploy on the server with same user login, and not when trying 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 Administrator group”
If you have questions or suggestions, feel free to do in comments section below !!!
Do share if you find this helpful .......
Knowledge Sharing is Caring !!!!!!