locked
CRM new organization creation error RRS feed

  • Question

  • Hi,

        When i am trying to create new organization in CRM 2011 i am getting the following error:

    microsoft.crm.tools.admin.grantcrmdatabaseaccessaction failed
    The default_schema clause cannot be used with a windows goup or with principles mapped to certificates or asymmetric keys

    Kindly help me to resolve the issue.

     

    Thanks in advance

    Jeriesh


    Cheers : Jeriesh
    Monday, August 29, 2011 6:33 AM

Answers

  • Hi.

    just a couple of questions :

    is this the first (main) organization of you CRM Server or are you trying to add an org to an existing CRM distribution ?

    are you using the same deployment admin ?

    have you changed privileges for that user on SQL server ?

    • Proposed as answer by Andrea1911 Monday, August 29, 2011 12:18 PM
    • Marked as answer by Donna EdwardsMVP Saturday, September 3, 2011 8:18 PM
    Monday, August 29, 2011 10:14 AM
  • I suggest you to read the following article :

    Make Microsoft Dynamics CRM client-to-server network communications more secure

    http://technet.microsoft.com/en-us/library/gg584033.aspx

    • Proposed as answer by Jim Glass Jr Monday, August 29, 2011 5:05 PM
    • Marked as answer by Donna EdwardsMVP Saturday, September 3, 2011 8:18 PM
    Monday, August 29, 2011 12:24 PM

All replies

  • Hi.

    just a couple of questions :

    is this the first (main) organization of you CRM Server or are you trying to add an org to an existing CRM distribution ?

    are you using the same deployment admin ?

    have you changed privileges for that user on SQL server ?

    • Proposed as answer by Andrea1911 Monday, August 29, 2011 12:18 PM
    • Marked as answer by Donna EdwardsMVP Saturday, September 3, 2011 8:18 PM
    Monday, August 29, 2011 10:14 AM
  • Hi Andrea,

       Thank you ...i have found that the deployment admin missing from local system admin group & that's the issue.

    Also i need one more help i need to change my current "http crm url" to "https url".Pls guide me

     

    Thanks in advance

    Jeriesh


    Cheers : Jeriesh
    Monday, August 29, 2011 12:04 PM
  • I suggest you to read the following article :

    Make Microsoft Dynamics CRM client-to-server network communications more secure

    http://technet.microsoft.com/en-us/library/gg584033.aspx

    • Proposed as answer by Jim Glass Jr Monday, August 29, 2011 5:05 PM
    • Marked as answer by Donna EdwardsMVP Saturday, September 3, 2011 8:18 PM
    Monday, August 29, 2011 12:24 PM
  • Hi there,

    I am getting the same error message but the user is already a member of Administrators group of local machine. The user is also a sysadmin of the SQL Server. The CRM Server and SQL Server are in the same machine.

    Any idea?

    Thanks in advance.

    Henri


    Please remember to click “Mark as Answer” on the post that helps you.

    Thursday, April 5, 2012 1:24 AM
  • superb and really thanks... it's working perfectly.

    Just add current user to Administrator group and issue resolved.

    Monday, September 22, 2014 1:32 PM