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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL Accounts details -
Microsoft Dynamics GP (Archived)

SQL Accounts details -

(0) ShareShare
ReportReport
Posted on by sandipdjadhav 18,306

Hello Friends,

Can any help me on getting more info for below sql accounts.

1.  DYNAMICSv16_0_0GPWorkflowEngineLogin,

2.  DYNAMICSv4_5_11NewtonsoftJsonLogin,

3.  DYNAMICSv4_0_30319SQLCLRSysDirServLogin

Need for SOX purpose.

Thanks much

Sandip

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Logins created from certificates or asymmetric keys are used for code signing purposes. They CANNOT be used to connect to SQL Server. Additionally, while creating a login from a certificate or asymmetric key, the certificate or asymmetric key needs to exist in the master database.

    So what is being code signed? Mostly a bunch of CLR assemblies loaded onto SQL Server, as follows:

    DYNAMICSv16_0_0GPWorkflowEngineLogin: Used for the workflow engine

    DYNAMICSv4_5_11NewtonsoftJsonLogin: Used for the serializing and deserializing JSON documents for the SBA web services

    DYNAMICSv4_0_30319SQLCLRSysDirServLogin: This is used by both SBA web services and the web services to access directory services

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Much Appreciate Mariano !

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    If I provided the answer to your question, I would much appreciate you mark the response as such. This will help other users with similar questions in quickly finding a solution to their problem. Thanks in advance.

  • Nizamudeen M Profile Picture
    Nizamudeen M 142 on at

    Any one can tell how can we can create this user while migrating or in the replication environment

    Thanks in advance

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans