Unable to use CRM 4.0 after databse restore from different domain.

Posted on 2008-10-15
Medium Priority
Last Modified: 2012-05-05
We are in the process of upgrading our server and changing our domain and I'm running into a problem migrating our CRM data to the new environment.  The steps we followed (definitely not best practices) were:

1. Installed Idera's SqlSafe Free (http://www.idera.com/Products/SQLsafefree/Default.aspx).
2. Used the SqlSafe BACKUP command to backup the database to a file called MSCRM.bak.
3. Formatted the server's hd.
4. Installed Small Business Server 2003 R2 Premium.
5. Installed SQL Server 2005 Standard.
6. Installed CRM from the installation CD.
7. Installed SqlSafe Free.
8. Used the SqlSafe RESTORE command to restore MSCRM.bak.
9. Initially tried renaming the data and log files to the appropriate CRM data and log files.
10. When that didn't work, we renamed them correctly.
11. Installed SQL Server Management Studio 9 (same install cds as SQL Server).
12. Shut down SQL Server, restarted it, and swapped the names of the databases using Managment Studio.
13. Granted SELECT, UPDATE, INSERT, DELETE to PUBLIC on the databse (just initially to get it working)
13. Tried to access CRM and got the following error message displayed in the main panel of CRM (the top and side panels display correctly):

Access Is Denied: You do not have enough privileges to access the Microsoft Dynamics CRM object or perform the requested operation. For more information, contact your Microsoft Dynamics CRM administrator.

Any insight would be greatly appreciated.
Question by:sellcenter
  • 3
  • 2

Expert Comment

ID: 22725305

So you just restored the previous CRM databases to the new SQL Server and changed the names to be the same name as the new CRM databases??

Was the previous CRM system on another domain??


Author Comment

ID: 22725563
Yes, we just restored the previous database using Idera's command line tool, then renamed it within management studio.  I tried to rename from the command line initially, but was running into some errors.

Yes, the previous system was set up on the same machine but we changed the domain when we reinstalled the OS.  I was thinking that might be part of the issue, but have no idea how to resolve it.


Accepted Solution

Biffster007 earned 2000 total points
ID: 22725696

Yep that will definitely be the issue as the GUID's that uniquely identify the CRM users relate to the A.D. of the previous domain.  You need to use the redployment tool to migrate CRM from one domain to another.

Before you install CRM on the new server/domain you restore the CRM databases.  You then run a utility call the CRM redeployment wizard and map users that are in the current CRM database with users that exist in the new domain.  This changes the GUID's of these users all through the database to GUID's of the new users.  Make sure you have the users setup in A.D. before you run the redeployment wizard.  You then install CRM using an option to point to existing databases and point to the databases that you've previously restored.

Make sense??

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

LVL 15

Expert Comment

ID: 22727011
I am not sure there is a "redeployment tool with CRM 4.0" like there was in 3.0.

In 4.0, you would install a clean environment and once that is installed and working, you restore your database (don't try to get clever with the names, just name your clean install CLEAN or something).

Then IMPORT the Organization using the Deployment Manager on the CRM server.  This will bring in the other database (you just need the Organization_MSCRM database restored) and will automatically walk you through the mapping of the users.  If you have Workgroup or Professional, the import will replace the CLEAN organization.  If Enterprise, it will add it, but you can then Disable and Delete the CLEAN and make the good one the default.

Biffsters general idea is sound though.

Author Closing Comment

ID: 31506438
Almost exactly right but I ended up needing to use Deployment Manager instead of redeployment wizard since it's CRM 4.0.

Expert Comment

ID: 22727132
Nice one :-)


Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question