CRM 4.0 Deployment from prod to dev. Locked out of both now. RRS feed

  • Question

  • We have 2 CRM 4.0 environments - prod and dev. (we also have SQL prod and SQL dev).

    An import was performed using the deployment manager on the CRM dev server, importing directly from the production db. The mapping option used was Auto-map users (Active Directory account name).

    From what I understand, the database should have been backed up from prod and restored over to Dev, then the import should have taken place. But that's not what happened.

    Now, this particular organization cannont be accessed through either prod or dev. Looking at the properties in CRM dev, it shows that it's pointed to the prod SQL database.

    Trying to open CRM in the dev environment gives a "The user Id is invalid." error. Opening CRM in prod gives "systemuser With Id = <ID> Does Not Exist".

    Any timely help with this would be MOST appreciated.

    Thursday, June 14, 2012 9:59 PM

All replies

  • HI KeithJ42,

                    It looks like the person who imported the organization database in dev pointed to the Prod SQL Server, I would go to the prod CRM and import the organization again by pointing it to the Prod SQL Server, and you might need to restore the backup you took first. That will at least restore the production environment.

    Damian Sinay

    Friday, June 15, 2012 5:08 AM