MS CRM 4.0 Installation with Exist Database

Dear All,

We are planning to Upgrade our CRM 3.0 to CRM 4.0, I did the following step but it’s not working.


•      In New Server we installed - OS Windows 2003 SP2, SQL 2005 SP2 and we bring the database backup from old CRM 3.0 Server and we restored in new server then installed CRM 3.0 successfully and working fine.
•      Then in the new server we stated upgrade the CRM 3.0 to CRM4.0 as per below instruction:
http://nitindhawan.wordpress.com/2009/06/14/mscrm-mig/

•      CRM 4.0 Installation successfully and its started working fine with customization
•      I took the SQL Backup MSCRM &  MSCRM_CONFIG & full image of the server.

Now I try here something

•      Here i format the New server – new OS Windows Server 2008, SQL Server 2008 R2 and I restore the database then I install directly CRM 4.0 while installing it’s give me error SQL Server already having MSCRM_CONFIG database name, so I removed MSCRM_CONFIG from SQL Server then continue the Installation, its completed successfully CRM 4.0
•      When I try to access the Accounts & Contacts it’s not working its giving me the below error:

No Account Records are available in this view


Could you please help me how to solve this issue

Thanks

Ram Kumar ChellamSr. System AdministratorAsked:
Who is Participating?
 
WayneATaylorCommented:
If you want to do an upgrade install you have to have a working CRM 3.0 system, you cannot just install CRM 4.0 as it will see it as a new install, then comlain about already having a MSCRM_CONFIG database.

If you have already successfully done an upgrade to CRM 4.0, you can take a backup of that Version 4 database, reinstall ther server. Install a clean office CRM 4.0, restore the database backed you tookf or the organisation and then import the organisation in using the deployment manager.

That wikll work, but you cannot do this, or upgrade a CRM 3.0 database unless CRM 3.0 is installed.

Wayne

0
 
Feridun KadirPrincipal ConsultantCommented:
Check the record (Settings | Administration) for the user that you are logged in as. I wonder if it has been set administrative access only. If so, remove that setting.
0
 
Ram Kumar ChellamSr. System AdministratorAuthor Commented:
Let me try and update you.

Thanks
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Ram Kumar ChellamSr. System AdministratorAuthor Commented:
Dear Admin,

Please close this ticket

Thanks
0
 
WayneATaylorCommented:
You need to issue points if it was OK.

That will automatically close it.

How did you go with my suggestion?

Wayne

0
 
Ram Kumar ChellamSr. System AdministratorAuthor Commented:

i try also its not working
0
 
WayneATaylorCommented:
That process will drfinately work.

What problems do you have?
0
 
Ram Kumar ChellamSr. System AdministratorAuthor Commented:

The CRM 4.0 Page is opening fine, but its not bringing any data from the restored database
0
 
WayneATaylorCommented:
You will find that you will have multiple organisations then if you imported it into crm

Have you tried setting the new one as the default org
0
 
Ram Kumar ChellamSr. System AdministratorAuthor Commented:

Fresh CRM 4.0 with new database is working fine if you restore the old database, its not bring any data from the database.

We have only one Org_MSCRM & MSCRM_CONFIG

Thanks
0
 
WayneATaylorCommented:
What happens when you go through the import org process.
Does it give any errors?
Wayne
0
 
Ram Kumar ChellamSr. System AdministratorAuthor Commented:

there is no error, i delete the new database and restore the backup database (where we took from the upgraded CRM4.0)

Thanks
0
 
Ram Kumar ChellamSr. System AdministratorAuthor Commented:
Thanks
0
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.

All Courses

From novice to tech pro — start learning today.