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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

chargoonAuthor 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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.