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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM org Update
Microsoft Dynamics CRM (Archived)

CRM org Update

(0) ShareShare
ReportReport
Posted on by raki 249

CRM version update failed, it showing following error:

" if not exists (select * from sysusers where name = '******\CRM2013-ReportingGroup-PR') exec sp_grantdbaccess '******\CRM2013-ReportingGroup-PR' Exception: System.Data.SqlClient.SqlException (0x80131904): The login already has an account under a different user name."

*This post is locked for comments

I have the same question (0)
  • raki Profile Picture
    raki 249 on at

    Crm Exception: Message: Update Organization with Id=4cec64dd-4dee-e211-8a14-0050569502e7 failed with Exception:

    System.Exception: Error.ActionFailed Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction ---> System.Data.SqlClient.SqlException: The login already has an account under a different user name.

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,308 User Group Leader on at

    HI Raki, your Reporting Services account is missing its security roles, you can set these in the Reporting Services Server/Reports and Server/Reportserver

    Please ensure your Reporting Services Service Account has the permissions required for SQL Server and AD Permissions;

    The identity account running the instance of Microsoft SQL Server Reporting Services where the Microsoft Dynamics CRM Reporting Extensions are running can’t be the local system or a virtual account. This is required for Microsoft Dynamics CRM reporting to work because the identity account must be added to the PrivReportingGroup Active Directory security group that is used by Microsoft Dynamics CRM.

    The user running CRM Reporting Extensions Setup does not have appropriate permissions on the organization database.

    The identity account running the instance of Microsoft SQL Server Reporting Services where the Microsoft Dynamics CRM Reporting Extensions are running can’t be the local system or a virtual account. This is required for Microsoft Dynamics CRM reporting to work because the identity account must be added to the PrivReportingGroup Active Directory security group that is used by Microsoft Dynamics CRM.

    You must run the Microsoft Dynamics CRM Reporting Extensions Setup on a computer that has a supported version of Microsoft SQL Server Reporting Services installed. More information: SQL Server Reporting Services

    Kindly Verify by Ticking Yes for Suggested Answer :)

    Best Wishes, Raz

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans