Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / MR 2012 RU5 CU6
Microsoft Dynamics SL (Archived)

MR 2012 RU5 CU6

(0) ShareShare
ReportReport
Posted on by Butch Adams 4,757

I have built a new test environment and MR has stumped me - I cannot get Data Mart integration going.

I have attached a database from an existing site with MR running fine

I have set up the demo companies

I have tried different server scenarios and I keep getting the same error

I have tried working with both SL 2011 SP1 and FP1

There is an error as follows for each of the dimensions that get integrated:

[Account to Account] has encountered an error. Processing will be aborted. Error text: Login failed for user 'CD8359B5576446f85EB67E824B4770'.

Has anyone seen this?

*This post is locked for comments

  • Richard West Profile Picture
    Richard West 525 on at
    RE: MR 2012 RU5 CU6

    Thank you for posting this! Worked great.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: MR 2012 RU5 CU6

    Thanks for the link. I fiddled with the service user - even making it the Sysadmin at one point and didn't get any results.

  • Jeff Larson Profile Picture
    Jeff Larson 157 on at
    RE: MR 2012 RU5 CU6

    When using the Data Mart it is supposed to use the service account to connect to the database, but if the service account does not have the correct rights it for some reason reports the CD8... user as the failing account.

    MS has a KB article for this issue: mbs.microsoft.com/.../KBDisplay.aspx but it is incomplete (or it was at the time I had a posting about this on the partner network forums) their script did not include the "grant exec on Get_ReportUser_Info "

    I first ran into this issue on RU4 and it still has not been fixed yet.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: MR 2012 RU5 CU6

    That worked. After I removed the integrations setup and the DDM db that was there and recreated everything after running the script, I got a good transfer.

    No I wish I knew why that worked. Is the old CD835.... account equal to the service account in the newer versions of SL?

  • Verified answer
    Jeff Larson Profile Picture
    Jeff Larson 157 on at
    RE: MR 2012 RU5 CU6

    Butch,

    Run the following against your System Database:

    (replacing the DOMAIN\MRSVC with your actual service account.

    -- Run against System Database

    DECLARE @CMD varchar(1000)

    DECLARE @MRServiceUser varchar(50)

    SET @MRServiceUser = 'DOMAIN\MRSVC'  --(domain\username format)

    SET @CMD =

    'grant exec on Company_Active to ['+ @MRServiceUser + ']

    grant exec on Get_User_Info to ['+ @MRServiceUser + ']

    grant exec on getAuthenticationType to ['+ @MRServiceUser + ']

    grant exec on Get_ReportUser_Info to ['+ @MRServiceUser + ']

    grant exec on GetInfo to ['+ @MRServiceUser + ']

    IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'''+ @MRServiceUser + ''') and NOT EXISTS(SELECT * FROM sys.database_principals WHERE name = N'''+ @MRServiceUser + ''')

    exec sp_grantdbaccess '''+ @MRServiceUser + '''

    alter user ['+ @MRServiceUser + '] WITH DEFAULT_SCHEMA=[dbo]'

    EXEC (@cmd)

    /*** run manually if the dbo does not get set

    exec sp_grantdbaccess 'DOMAIN\MRSVC'

    alter user [DOMAIN\MRSVC] WITH DEFAULT_SCHEMA=[dbo]

    */

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: MR 2012 RU5 CU6

    Thanks, but I have run it at least a hundred times. That isn't working.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: MR 2012 RU5 CU6

    In Database Maintenance, run the Synchronize All Ownership and Security Scenario.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans