Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

HQ Client not open if i change region and language from arabic to English

Posted on by Microsoft Employee

dears

i have windows xp and POS

my working language is Arabic language if i go to control panel and changed it to English

the hq client not open 

i need to change language to English because Arabic make Problems with Excel Numbering 

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Client not open if i change region and language from arabic to English

    thanks ED

    i did your steps but i got this message

    store operation business rules

    invalid object name 'information_schema.tables'.

    (source: Microsoft OLE DB Provider for SQL Server )

    (SQL State: 42502)

    (NativeError: 208)

    No Help File available

    if EXISTS (select * from INFORMATION_SCHEMA.table where table_name = 'DatabaseMetaData') select Top 1 * from DatabaseMetaData

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Client not open if i change region and language from arabic to English

    You most likely have to change the collation of the SQL Database.  Make sure to backup the database first, as changing the collation of the Database can have unseen problems.  

    Do this on the RMS Admin if possible.  If not, then use the SQL Management Studio.

    first you have to connect to the database.

    1) Admin -> File ->Connect.  

    Next make a backup

    2) Admin -> Database -> Backup

    Then change the collation.  

    3) Admin -> database -> Change Collation -> SQL_Latin1_General_CP1_CI_AS

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans