Announcements
18,302
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
Any one can tell how can we can create this user while migrating or in the replication environment
Thanks in advance
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.
Much Appreciate Mariano !
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
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
