web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

MSCRMSqlClrLogin SQL Login

(1) ShareShare
ReportReport
Posted on by 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.

I have the same question (0)
  • Community Member Profile Picture
    on at

    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.

  • PabloC Profile Picture
    on at

    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.

  • Suggested answer
    Platon Vasilchenko Profile Picture
    4 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 73 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 42 Most Valuable Professional

#3
Scott Jackson UK Profile Picture

Scott Jackson UK 22

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans