locked
Import organization - SQL server field is disabled RRS feed

  • Question

  • Hi,

    I'm trying to import organization. I do this:

    1. Run Microsoft CRM Deployment Manager (Start -> All Programs -> Microsoft Dynamics CRM Deployment Manager).

    2. Go to "Organizations" node, press right mouse button on the organization that uses the database whose name you want to change. Choose the "Disable" option.

    3. Repeat all the activities described in point 2, but this time select "Delete" option.

    4. Connect to your database server (for example, using Microsoft SQL Management Studio) and rename your [OrganizationName]_MSCRM database to the desired name. Sometimes you may get the information: “The database cannot be exclusively locked to perform this operation”. In such a situation the SQL Server restart will help.

    5. Use the CRM Deployment Manager to Import Organization (Deployment Manager -> Organization -> “Import Organization” option). It will run the wizard which allows for importing an organization from an existing SQL database
    .........

    but in this window, I can't choose SQL Server. Field is disabled. What I did wrong?

     

    http://screencast.com/t/Yzc4ODQzMm


    ...
    • Edited by T72 Monday, May 31, 2010 12:10 PM add screen
    Monday, May 31, 2010 11:50 AM

Answers

  • Did you try to... wait a little? I had this issue, while the servers is builded, the first field is disabled. When the list is gathered, the field is enabled.
    Mercure Integration: Dedicated to Dynamics CRM Import & Integration Products
    Check out Mercure Nomad
    • Marked as answer by T72 Monday, June 14, 2010 12:05 PM
    Wednesday, June 2, 2010 11:32 AM

All replies

  • hi

    is your sql browser service running?


    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Tuesday, June 1, 2010 3:58 AM
  • Yes, it is. It doesn't search sql servers. It disable the field so I can't even write ip of my sql server.
    ...
    Wednesday, June 2, 2010 8:18 AM
  • Deployment Manager log might say something.
    SJ
    Wednesday, June 2, 2010 10:38 AM
  • Did you try to... wait a little? I had this issue, while the servers is builded, the first field is disabled. When the list is gathered, the field is enabled.
    Mercure Integration: Dedicated to Dynamics CRM Import & Integration Products
    Check out Mercure Nomad
    • Marked as answer by T72 Monday, June 14, 2010 12:05 PM
    Wednesday, June 2, 2010 11:32 AM
  • No... i didn't wait (it's took about 10 seconds, i always exit after ~5).... ROTFL! Thanks :]
    ...
    Monday, June 14, 2010 12:05 PM