Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SL Datamart Errors
Finance | Project Operations, Human Resources, ...
Unanswered

SL Datamart Errors

(0) ShareShare
ReportReport
Posted on by JGarcia123 1,608

I am in the process of configuring MR (CU16) for a Dynamics SL 2018 implementation.  The installation runs fine and the datamart creates without error, however we are having a problem when trying to enable and populate it.

The process appears to go through the motions, but then stalls towards the end.  The following message is in the error log:

Cannot open database "SLSYTEM" requested by the login. The login failed.
Login failed for user 'E8F575915A2E4897A517779C0DD7CE'.

The implementation uses windows authentication and In troubleshooting we've done the following

1) Under Solomon Database Maintenance, Set the authentication type to "Windows Authentication" (without error)

2) Also under Database Maintenance, Ran "Synchronize all database ownership and security" (without error)

3) Recreated the datamart numerous times still with the error.

4) Rebooted the server

5)  Compared and verified the 'E8F575915A2E4897A517779C0DD7CE' SQL settings against another working MR implementation

6)  Ran the Solomon data verification scripts and corrected any issues

Regardless still have not been able to remedy the login issue.  Before I open a formal case, is there something obvious I may not have considered.  Please advise.  Look forward to a reply.

JG

  • JGarcia123 Profile Picture
    JGarcia123 1,608 on at
    RE: SL Datamart Errors

    I never closed out this case.  Thanks to all who responded.  

    Turned out the client had an old invalid system DB reference in their domain table.  Once removed then the datamart rebuild worked.

  • JGarcia123 Profile Picture
    JGarcia123 1,608 on at
    RE: SL Datamart Errors

    Kyle,

    That's makes sense.  Was starting to think along those lines too.  Will give it a try.

    JG

  • KyleBWillman Profile Picture
    KyleBWillman 65 on at
    RE: SL Datamart Errors

    From what it looks to me:

    Due to the fact that you have restored DB's from another DB server, sometimes the 07.... and E8..... users get disjointed due to SQL server SID vales stored in the DB's.  I would drop the E8...  user and potentially the 07.... user from all application and the system DB.  Then, drop the login from SQL as well.  Run the synchronize ownership through DB maintenance and let it recreate itself throughout.  I think then you might get past this.  It appears that restoring the DB's retained the old SID and it does not match the login.  I hope this helps!

    KW

  • JGarcia123 Profile Picture
    JGarcia123 1,608 on at
    RE: SL Datamart Errors

    Thanks Laura,

    I tried that, but no luck.

    Any other thoughts?

    JG

  • JGarcia123 Profile Picture
    JGarcia123 1,608 on at
    RE: SL Datamart Errors

    Kyle,

    No need to be sorry.  

    This is a test environment upgraded from SL2011 to SL2018CU3.  It is separate from the production environment.  Databases were restored to the new environment and upgraded without issue.  Solomon screens and reports appear to be functional.

    MR is a new install/implementation and CU16.

    Any thoughts?  Let me know.  Thanks!

    JG

  • KyleBWillman Profile Picture
    KyleBWillman 65 on at
    RE: SL Datamart Errors

    I assume this is a test or sandbox environment, and not a production environment.  If so:  

    How were the Dynamics databases created in the environment?  

    Is it the same DB server as production, or different?  

    Did you move production DB's from prod server and restore them into a test/dev SQL server?  

    Was it a backup of a production environment?  

    Sorry for all the questions, but might help!

  • Laura Profile Picture
    Laura 450 on at
    RE: SL Datamart Errors

    You may want to try changing the database authentication to SQL Authentication and then back to Windows Authentication.

    I recall issues with SL 2015 for another company that causes issues with Management Reporter and with the PV's in SL .

    Laura

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans