Notifications
Announcements
No record found.
can i install management reporter on case sensitive database collation ? like SQL_LATIN1_GENERAL_BIN collation ?
*This post is locked for comments
anyone can help ?
I have never tried this and given all the problems I have seen with Management Reporter I would have my doubts but since MS Dynamics GP supports this collation sequence there may be a good change MR will work.
but, the Microsoft give some note on the Management Reporter Installation Guide, that the sql database must be case insensitive database collation
The GP manual also says that GP9 is not supported on a W7 64 bit OS but it does work. If you are stuck this collation sequence there is no harm in trying. If you are using this instance of SQL for GP it means all your inquiries are now case sensitive. You are better off doing a bulk copy out and in to the change the collation sequence back to case insensitive.
Management Reporter will work on the SQL_LATIN1_GENERAL_BIN collation without any issues.
Thanks,
Ryan
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1