Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'p_GetDefaultOrgFromAuthInfo', database 'MSCRM_CONFIG', schema 'dbo' RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I needed to update SSRS to be on the same machine as of CRM 4.0. After installing SSRS 2005 and SRS Data Connector, whenever I try to connect to CRM Organization, above error is shown.

    Moreover, I am unable to connect to deployment manager as well. As it complains:

    "Only the Deployment Administrators are able to use Deployment Manager. You are not a Deployment Administrator."

     

    Thanks...

    Thursday, May 17, 2012 7:21 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    If the error is when you try to browse to CRM, I expect the problem is that the CRM service account (the identity of the CrmAppPool application pool) does not have SQL rights to the MSCRM_Config database. The CRM service account should be a member of the SqlAccessGroup AD group, which should be granted the rights in SQL.

    Similarly, I think that the account that you use to run Deployment Manager needs SQL rights to the MSCRM_Config database.

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Thursday, May 17, 2012 2:07 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Is your account a CRM Deployment Administrator ? By default, only the account that is used to install CRM is made a deployment administrator.

    Have you configured CRM (via Deployment Manager) to use the SSRS instance on the CRM 4.0 machine ? If you haven't, then CRM should be unchanged. When do you get the SqlException ?

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Thursday, May 17, 2012 9:59 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi David!

    Yes, my account is deployment administrator in CRM. And yes i have used deployment manager to change SSRS instance on the CRM machine.

    I get this error, every time when I try to browse my CRM organization.

    ---

    Zeshan

    Thursday, May 17, 2012 10:14 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If the error is when you try to browse to CRM, I expect the problem is that the CRM service account (the identity of the CrmAppPool application pool) does not have SQL rights to the MSCRM_Config database. The CRM service account should be a member of the SqlAccessGroup AD group, which should be granted the rights in SQL.

    Similarly, I think that the account that you use to run Deployment Manager needs SQL rights to the MSCRM_Config database.

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Thursday, May 17, 2012 2:07 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Daivd, I have given rights to SqlAccessGroup for the MSCRM_Config database. The error is gone, but a new error is now produced as the result of this.

    "Invalid user authorizatoin The user authenticatoin passed to the platform is not valid."

    and this is what I have in windows event log.

    Event code: 3005

    Event message: An unhandled exception has occurred.

    Event time: 21/05/2012 07:17:01

    Event time (UTC): 21/05/2012 06:17:01

    Event ID: 986bad4cf2384123bb4d8d7ff0c7f697

    Event sequence: 25

    Event occurrence: 11

    Event detail code: 0

    Application information:

    Application domain:
    /LM/W3SVC/1/ROOT-1-129820531855876532

    Trust level: Full

    Application Virtual Path: /

    Application Path: C:\inetpub\wwwroot\

    Machine name: DUB-CRMTEST01

    Process information:

    Process ID: 7436

    Process name: w3wp.exe

    Account name: NT AUTHORITY\NETWORK SERVICE

    Exception information:

    Exception type: CrmException

    Exception message: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    Request information:

    Request URL: http://dub-crmtest01/CRMtest01/loader.aspx

    Request path: /CRMtest01/loader.aspx

    User host address: ::1

    User: RENRE\tali

    Is authenticated: True

    Authentication Type: Negotiate

    Thread account name: NT AUTHORITY\NETWORKSERVICE

    Thread information:

    Thread ID: 3

    Thread account name: NT AUTHORITY\NETWORKSERVICE

    Is impersonating: True

    Stack trace: at Microsoft.Crm.Authentication.WindowsAuthenticationProvider.QueryForOrganizationId(StringuserToken)

    at Microsoft.Crm.Authentication.WindowAuthenticationProviderBase.Authenticate(HttpApplication application)

    at Microsoft.Crm.Authentication.AuthenticationStep.Authenticate(HttpApplication application)

    at Microsoft.Crm.Authentication.AuthenticationPipeline.Authenticate(HttpApplication application)

    at Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender,EventArgs e)

    at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Custom event details:

    ---

    Zeshan


    Monday, May 21, 2012 6:24 AM