I just recently installed new fresh AX 2012 R3 and importing data using Test Data Tools :
https://technet.microsoft.com/en-us/library/dn756356.aspx .
but somehow when i start sync db after full compilation and full CIL, i got following error :
“Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics”.
i logged in using domain administrator.
here is the solution :
on the user mapping at SQL Server , make sure the db owner for administrator is checked. if you are using another user, just make sure db.datareader and db.datawriter is checked.
voila !! , the ax db sync successfully
more info :
https://community.dynamics.com/ax/f/33/t/48661
[…] run a sync which means they aren’t in the db.reader and db.datawrite roles. You can review this blog to check your SQL User […]
Hi, I’ve tried those steps but still cannot synchronize.
Do you have any suggestions as whats else can I check so that I can do a full sync?
Thank you.
are the error is the same ?
checked the db_owner,db_writer and db_reader..
on same cases, db_owner alone can’t solve this error.
http://dynamicsaxaptablog.blogspot.dk/2015/11/failed-to-create-session-confirm-that.html
[…] a sync which means they aren’t in the db.reader and db.datawrite roles. You can review this blog to check your SQL User […]
[…] run a sync which means they aren’t in the db.reader and db.datawrite roles. You can review this blog to check your SQL User […]