BizTalk Management and MessageBox Databases Sync Issue – Part2- UN-Deployment

Second phase of BizTalk Management and MessageBox DB sync issue is Un-Deploying/Deleting application. Fortunately issue was with only 2 applications. When tried to Delete (either from Cosnole Or BTSTask -Remove App command ) an application in order to deploy a new version,we got an error popping out every-time saying “The service action could not be performed because the service is not registered” The application was visible in the BizTalk Admin Console. Funny part was; application was running without any issue and all messages subscribed by artifacts of this application were being processed… Read More

BizTalk Management and MessageBox Databases Sync Issue – Part1- Deployment

While using BizTalk Clustered Environment with Availability Groups (Not Failover Cluster), an issue was found while deploying BizTalk Application. BizTalk Management and MessageBox Databases goes out sync (due to some specific or unknown reason), we get error while deploying an application. (it could be 1 or more applications; in my case it was only one) Deploying another version of same application in BizTalk Environment creates issue. It is noticed that there are activation subscriptions left even after Un-deploying the BizTalk application. Its  impossible to deploy the BizTalk application again with Orphan Subscriptions…. Read More

Create SQL database on Azure using PowerShell and access from on Premises Microsoft SQL Server Management Studio

SQL Azure is cloud database-as-a-service provided by Microsoft cloud. The best part is that the data is hosted and managed by Microsoft data centers. We can build our applications on premises and move our data to cloud. Azure SQL model provides: Elastic database pools – Allows you to provisioned 1000’s of database table as you need. Grow and shrink based on your requirement. Azure hosted database Pay for only what you use (no of plans available) Auto-scale Also enable Geo-replication for disaster recovery Reduces hardware cost and maintenance In this example, we… Read More