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.