web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter 2012 CU16: Unable to obtain the database collation - Again

(0) ShareShare
ReportReport
Posted on by 670

You would think there would be Wiki on this by now.

Installing with the service account.

Service account Provisioned as follow form the installation manual :  

Assigned sysadmin role in SQL Server® and able to create a database

  • Is assigned to the SQL Server Sysadmin role

A domain user and a member of the local Administrators group on the server

  • An Active Directory® domain account

A Management Reporter Administrator

Has access to the network share or SharePoint location to which reports are generated
Is a dedicated account with a password that does not expire

?This is somewhat ambiguous but, I added the service account to the DYNGRP on DYNAMICS and COMPANY databases

"Be an active user in the Microsoft Dynamics ERP system(s) that you are integrating with"

Is the Management Reporter 1st Administrator.

-

Based on the Installation documentation; there should be no issue.

- I have tried creating an SQL user to connect to the DYNAMICS database that is a sysadmin with access to the DYNAMICS and COMPANY databases with membership in the DYNGRP.  Can't connect at all unless it is sa connecting to the DYNAMICS database.  The option to user the service account to connect to the DYNAMICS database is not a feature of the installation.

-

From Dumpster diving the Internet:

I have confirmed that the service account user has a name.

This is the first time I've run into this error with an MR installation and while I have found references to the error dating back years, none of the solutions I have encountered have provided me with a solution.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tim Andaya Profile Picture
    670 on at

    It would seem that for reasons unknown, unless I install the Legacy component, this error doesn't go away.

    I was hoping for a clean implementation without legacy but, that will not be the case.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans