Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Management Reporter er...

Management Reporter error referenced CD8 user after upgrading

(0) Share

Report

Posted on by Rachel Moore

Hello,

I've recently upgraded Management Reporter to CU8 and am now receiving an error in the data mart log for each integration task similar to:

"[G\L Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Login failed for user 'CD8359B5576446f85EB67E824B4770'."

I traced it and get this message:

I found the scripts from the links below, restarted the services, and reconfigured the integration with a new data mart db. The errors still occur.
https://community.dynamics.com/sl/f/35/t/111488.aspx
https://community.dynamics.com/sl/f/35/p/110339/224765.aspx

In checking the security in SQL, the CD8 user does not exist in SQL, or under any of the databases. They are Windows authenticated and from what I understand the CD8 user is created for SQL authenticated databases.

Does this CD8 user need to be created?

*This post is locked for comments