Dynamics CRM 4 cannot connect to the database


I'm running Microsoft Dynamics CRM 4.0 on my company's network. I have a windows server 2003 with SQL Server 2008 as the DB server and a Win2003 x64 for the web application. After moving the DB to a new server, I had several errors connecting the web server to the DB. I added ports 1433 and 1434 to firewall exception list and my CRMAppPool is using NETWORK SERVICE identity. I added the computer name to SQL Server logins. I had several errors and now my situation is like this:

When I try to connect to the web application I get "Record Is Unavailable" error indicating: "The requested record was not found or you do not have sufficient permissions to view it."
When I try opening Deployment Manager or my CRM server, I only have "License" node in the MMC console.

I guess Deployment Manager is able to connect to the SQL Server and MSCRM_Config database, but I do even see the options to create a new organization and restore the old database over a new one.

Any ideas?
Who is Participating?
chargoonConnect With a Mentor Author Commented:
I tried everything but nothing worked. I finally gave up and re-installed the CRM web application and let it configure the DB and everything then imported my organization database.
So you moved the SQL databases to a new SQL server.
Did you remove them from the old SQL server or are the services stopped there?

Are you able to create an ODBC Connection from the CRM server to the new SQL server (this should help determine if it is CRM or permissions or connectivity)  Try first with the SQL server SA account, then work towards the account you are logged in with. (was that account the CRM Administrator account? / Install account?)

If you move both databases, you need to modify the string for the MSCRM_CONFIG connection in the registry (that way you can fully use the Deployment Manager and thus move the SQL for the ORG_MSCRM database.

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.