Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

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

Avatar of sellcenter
sellcenter asked on
Microsoft SQL ServerSBSMicrosoft Dynamics
6 Comments1 Solution1708 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Avatar of Biffster007
Biffster007Flag of New Zealand image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers