Dynamics 365 Online S2S Authentication - Full Explain

Server-to-Server (S2S) authentication (only support Dynamics 365 online) was great, it use ClientId/SecretKey to authentication (instead use UserName/Password) and it use without Dynamics 365 license. But everybody have problem when use CllientId/SecretKey, the main problem is HTTP Error 401 - Unauthorized: Access is denied I headache this problem more than 3 days, and now, I succeed authentication with ClientId/SecretKey. This post I will fully explain you how I can achieve it. [Read More]

Please, don't hard code

When building hyperlinks to CRM in SSRS reports, please don’t hard code Wrong: hard coding your CRM URL. Do not set your URL to “https://crmserver/….” If you do this use the hyperlink will only work in one environment and will have to be rewritten to work in another environment. Right: Use the CRM_URL parameter in your report. This makes your links will work in all environments, even when offline. Parameters!CRM_URL Wrong: Using OTC (ObjectTypeCode) in your hyperlink expression. [Read More]

Get Sql ConnectionString from CRM server code

Sometime, your business logic need access direct SQL Server, and you want to know the ConnectionString of CRM Database. This code will help you get Sql ConnectionString from CRM Plugin/Custom Action/Custom Workflow (before that I saved the ConnectionString to the custom Options entity) public void Execute(IServiceProvider serviceProvider) { var context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext)); var platformContext = context.GetType().InvokeMember("PlatformContext", BindingFlags.GetProperty, null, context, null); var transaction = (SqlTransaction)platformContext.GetType().InvokeMember("SqlTransaction", BindingFlags.GetProperty, null, platformContext, null); throw new InvalidPluginExecutionException(transaction. [Read More]