Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

HQ Server Error

Posted on by Microsoft Employee

*This post is locked for comments

  • archelle16 Profile Picture
    archelle16 1,735 on at
    RE: HQ Server Error

    Please tag this thread as solved. I visited this 5 times thought as unsolved. Thanks!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Server Error

    Solved!!!

    Some users have apostrophe ' on password when upload password use  apostrophe so that give error search users with apostrophe and change password and then upload

    Run Query on HQ password not encrypted. and then see what users have that char and update on store.

    SELECT * FROM Cashier AS c

    WHERE c.[Password] LIKE N'%''%'

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Server Error

    Not solved but i found that its a problem only with the Cashier Table after run the worksheet i insert a new record in the table TimeStampLog and for a few days work until someone change the password of a account and the error come back again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Server Error

    Curious if you have solved this.  I have the exact same problem.    I'm on 2.0.0.1005. SQL 2008 R2 Express both store and hq.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Server Error

    Can you update RMS to 2.0.1005 at least and see how it goes?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Server Error

    Both same version

    Microsoft® SQL Server® 2008 R2 SP1

    no hotfix installed after SP1.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HQ Server Error

    What version of SQL Server are you running?   We need versions from both the store level and the HQ level.  Also if you could include and service packs or hotfixes install on the sql server.  

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans