I just recently installed new fresh AX 2012 R3 and importing data using Test Data Tools :
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 :