January 24, 2018 at 7:48 am
AX 2012 R3 installation with SQL Server 2014. When trying to set up the Master Data Services connection I get a message from AX Access is Denied.
The Sql Server Log as these two messages in them.
The activated proc '[mdm].[udpNotificationQueueActivate]' running on queue 'MDS2.mdm.microsoft/mdm/queue/notification' output the following: 'The EXECUTE permission was denied on the object 'udpNotificationQueueActivate', database 'MDS2', schema 'mdm'.'
The activated proc '[mdm].[udpStagingBatchQueueActivate]' running on queue 'MDS2.mdm.microsoft/mdm/queue/stagingbatch' output the following: 'The EXECUTE permission was denied on the object 'udpStagingBatchQueueActivate', database 'MDS2', schema 'mdm'.'
I am able to execute those stored procedures from Sql Server Management Studio.
This is all running on a VM on my local machine with one login that is admin all the way around.
Thoughts on what is missing?
January 24, 2018 at 1:33 pm
Problem solved. There were 3 additional accounts in AX that may have been making a call to MDS and those had to be added via the website security.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply