Change Dynamics AX user default language without being connected to the domain

Today was supposed to publish an article in English about how to Export Purchase Order Data to MS Excel templates with Dynamics AX 2012 ( Document Management ). but when i open the ax client i remembered that i forget to change the default language before left my office yesterday. as you know you can't change user default language from the user options form without being connected to the domain. so i tried to change the language directly from the database and i succeeded. find below the steps maybe you will need it some day.

1. this is how my Dynamics AX  client look like today morning
   
2. when i tried to change the language from the options screen like this :
   
3. I got SID error that's mean i am not connected  to the domain
   
4. to solve this issue open the MS SQL management studio go to dynamics ax database in my case "ConAX" open the USERINFO table then select the user and change the language field as follow
   
   
   
   
   
   
5. then go to windows control panel --> administrative tools --> services --> restart the MS Dynamics service 
   
   
   
6. open your  dynamics AX Client you'll find that the language has changed.
   

Now i can start writing about about how to Export Purchase Order Data to MS Excel templates with Dynamics AX 2012 ( Document Management ).

To get new posts and updates, please follow the blog by clicking the Join this site Button in the top-right side under my personal information