Dynamics CRM 4 cannot connect to the database

Posted on 2008-11-20
Last Modified: 2012-06-27

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?
Question by:chargoon
    LVL 15

    Expert Comment

    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.


    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
    Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now