MSCRMSqlClrLogin SQL Login

(1) Share

Report

Posted on by jgspitler

342

Hello, My client is using D365 V9 on premise. There are production and UAT environments using SQL Server AlwaysOn, In production I noticed that one of the nodes has s SQL authenticated user account named MSCRMSqlClrLogin. This account has no permissions other than public. No permissions on any databases. This account does not exist on the other nodes. It doesn't exist at all in the UAT environment. I did a google search and see articles about it but none regarding v9. They are all pertaining to older versions of CRM. Is this SQL account needed in v9?

Thanks.

All responses (3)

Answers (0)

Suggested answer

Platon Vasilchenko 4 on at

Like (0)

Report

MSCRMSqlClrLogin SQL Login

Hello.

MSCRMSqlClrLogin SQL login, the asymmetric key for it, and Microsoft.Crm.SqlClr.Helper.dll aren’t required with Dynamics 365 Customer Engagement (on-premises), version 9.

See this article: https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/deploy/post-installation-configuration-guidelines-dynamics-365?view=op-9-0#configure-databases-for-sql-server-alwayson
PabloC on at

Like (0)

Report

RE: MSCRMSqlClrLogin SQL Login

I have the same question, in tools folder i didn't found the Microsoft.Crm.SqlClr.Helper.dll, and it's c:\Program Files\Dynamics 365 the base route.
Community Member Microsoft Employee on at

Like (0)

Report

RE: MSCRMSqlClrLogin SQL Login

Hi Joe,

I also didn't search for any document about MSCRMSqlClrLogin regarding V9, so you can test to check error appears or not when you don't configure it.

If error appears, you can configure it as following link:

Need Help Configuring AlwaysOn Availability Groups for Dynamics CRM 2016? (crmsoftwareblog.com)

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.