After you create the data mart database, you notice that the ERP Validation is not successful. When you check the Data Mart Integration logs you notice the message: Login Failed for user E8F575915A2E4897A517779C0DD7CE
RESOLUTION 1
Make sure all users are logged out of Dynamics SL.
Open the Database Maintenance screen.
Connect to the SQL Server that hosts the Dynamics SL database
On the Update Databases tab, run the Synchronize All Database Ownership & Security
Run the Data Mart Integration process again in the MR Configuration Manager. If the error persists, go to Resolution 2
RESOLUTION 2
Open SQL Management Studio
Run this statement against the SL system database: Select * from domain where description= 'Report User Password'
If the above statement returns multiple records and the currentpassword field is blank in any of the records, go ahead and delete those records. Then, run the Data Mart Integration process again in the MR Configuration Manager