Adding SQL AG database error

Using wizard 'Add Database to Availability Group' you may receive next error message: Failed to join the database '<db-name>' to the availability group '<ag-name>' on the availability replica '<secondary-sql-server>'. (Microsoft.SqlServer.Smo) Availability-group DDL operations are permitted only…

Decrypt CRM Email Router saved passwords

We are using Email Router for Dynamics CRM 2011. And we have lots of profiles there. During migration to CRM 2015 we need to recreate email server profiles and mailboxes. I don't like how OOB migrate email router data works. Cause it creates email server profile per email router configuration…

Dynamics CRM fails on help content server tests

After deploying Dynamic CRM you may start receiving next errors in application event logs where Help Server role installed: Monitoring test failed: Test Title: Help Content Server Tests.: Machine: <MACHINE-NAME>: ServerRole: HelpServer Test Log: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.GetResponse(…

Increase rollup fields maximum

Recently we started transition from Dynamics CRM 2011 to 2015. As part of transition we started using rollup fields. There are some limitations for that feature: You can define a maximum of 100 rollup fields for the organization and up to 10 rollup fields per entity. Which we faced on…

How to restore merge replication triggers

Issue We are using merge replication to provide some filtered data for our clients. Also we use data-tier applications for deploying latest DB schema, stored procedures, etc for our databases. Somehow it turned out that deployment of DACPAC are breaking replication. It took quite a time to troubleshoot it. The…

Usging NuGet for software deployment?

Developers here work on rewriting\refactoring our product to have modular design rather then monolith. We consider using NuGet packages for deploying. Octopus uses NuGet for packaging: Before you can deploy an application using Octopus, you will need to bundle all of the executables, DLL's, configuration files, installation scripts, and…

PowerShell for Dynamics CRM Organization Data

Microsoft guys released PowerShell cmdlets Microsoft.Xrm.Data.Powershell. About half a year since I've started my Handy.Crm.Powershell.Cmdlets project to deal with day to day work and automate routine DevOps tasks. Haven't checked their work though. Rhetorical question rises up if I should abandon my cmdlets and…

WinRM MaxEnvelopeSize quota

While testing your Desited State Configuration configuration you may receive next error message during exectuion of Start-DscConfiguration: VERBOSE: Perform operation 'Invoke CimMethod' with following parameters, ''methodName' = SendConfigurationApply,'className' = MSFT_DSCLocalConfigurationManager,'namespaceName' = root/Microsof t/Windows/DesiredStateConfiguration'. The WinRM client sent a request to the remote WS-Management service and was notified…

Configuring SQL mirroring

During configuring database mirroring via Microsoft SQL Management Studio you can stumble upon error message: The server network address "TCP://srv-sql.test.local:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are…

How to restore Dynamics CRM entity from audit log

Eventually almost everyone face the situation when you removed something that shouldn't be removed. There is no built-in recycle bin inside Dynamics CRM. Restoring database to specific state isn't right thing to do for sure, because of several reasons: It is resource intensive. You may not have so old backup.…