CRM Tips: Fixing The Import Organization Wizard cannot connect to the SQL server or cannot find an organization database

Sometime Microsoft Dynamic CRM organization import wizard will end up with following error

The Import Organization Wizard cannot connect to the SQL server or cannot find an organization database on <SQL Server>.

This error can occur when you importing CRM organization from SQL server which contains any other databases (other than CRM organization database).

To fix this issue need to perform following activities and checks

1. Check SQL connectivity
2. Check restore database name has “_MSCRM” phrase. If not then rename database before importing.

If previous checks are fine then connect to the SQL server and temporary set offline the database which mentioned in the organization import.

If database take long time to go offline then close the deployment manager and try again previous step

Note: CRM deployment manager establish multiple connections with the database and SQL server unable to close these connections. Use following query to check existing processes which establish connections with the database

Select *

From sys.sysprocesses

Where dbid = db_id(‘dwstaging’)

After database goes offline then import relevant organization.