locked
how to enable organization without using the deployment manager? RRS feed

  • Question

  • We are moving the CRM deployment from one server to another.
    On the FIRST server, where CRM is running live, we do not have the credentials for the Deployment manager. 

    I imported the organization from the FIRST server to a NEW server, using deployment manager. however, the CRM of the FIRST server is no longer available. I believe the Organization got disabled during the import.

    How can I enable it again? Is there any SQL Script we can do to bypass this?

    It is very critical to resolve this issue, since we are production down.

    thanks,


    eSharing.com
    Wednesday, February 10, 2010 3:47 PM

Answers

All replies

  • What version of Dynamics CRm do you have (Professional or Enterprise). In Professional if you will import new organization it will automatically delete organization (but not delete Databases on SQL server) because Professional it's a single organization only. To restore old organizaiton you will need to import old organization once again via Deployment Manager.


    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Wednesday, February 10, 2010 4:25 PM
  • We have Dynamics CRM Enterprise.

    The problem is that I do not have access to the deployment administrator on the old server.
    eSharing.com
    Wednesday, February 10, 2010 4:40 PM
  • It's strange that you don't have access to Deployment Manager, anyway

    check this: http://blogs.msdn.com/crm/archive/2008/01/18/multi-tenancy-in-crm-4.aspx

    Check Microsoft.Crm.DeploymentConfigTool

    Do you share the same SQL environment for First server and new one ?

    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    • Proposed as answer by kgorczewski Wednesday, February 10, 2010 4:54 PM
    • Marked as answer by Jim Glass Jr Wednesday, February 10, 2010 6:07 PM
    Wednesday, February 10, 2010 4:51 PM
  • The reason why we don't have access to the deployment manager is that the employee who initially installed CRM (using his domain account) and thus was the deployment administrator, left the company. His AD account was deactivated. We tried to reactivate his account and reset his password, but it seems he was not accepted as deployment administrator anymore.

    I have SQL 2005 installed on the FIRST server (Management studio is NOT installed)
    I have SQL 2008 installed on the new Server, with Management Studio installed.

    I checked the blog you referred me to: it shows how to create a new organization, not to reset an existing one.

    Many thanks!
    Andrew -
    eSharing.com
    • Edited by eSharing Wednesday, February 10, 2010 5:52 PM typo
    Wednesday, February 10, 2010 5:34 PM
  • Without access to Deployment manager it can be difficult. It's strange that when you reactivate and reset password not working.

    I think that you may think about hack directly configuration DB (MSCRM_CONFIG). It's not supported to do this but in your situation I not see any choice.

    Check SecurityRole table and SystemUser in MSCRM_CONFIG
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Wednesday, February 10, 2010 6:00 PM
  • I checked these tables:

    SecurityRole has one entry (Administrator)
    SystemUser lists the users for all Organizations we have. It does not show which user is the deployment admin.

    Again, i truly appreciate your support!
    eSharing.com
    Wednesday, February 10, 2010 6:08 PM
  • Check this fresh article how to create a new Deployment Administrator in Database.

    http://crmdude.wordpress.com/2010/02/13/create-deployment-administrator-via-database/

    It should resolve your problem.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    • Proposed as answer by kgorczewski Saturday, February 13, 2010 11:01 PM
    Saturday, February 13, 2010 11:01 PM