Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Problem with Import Organization in Deployment Manager RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all.

    CRM was installed on one server, SQL was installed on another. We would like to change old Sql server to another new Sql server.

    I have a problem with Import Organization in Deployment Manager. When i try to  choose SQL Server in dialog box, there aren't any SQL servers here. (there are no entries in the "SQL Servers" list)

    What should i do? Help please.

    Tuesday, February 1, 2011 8:32 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    you could enter the server name manually.
    If it does not show up automatically the most common reason is that the SQL Server Browser Service is not running or blocked by a firewall.

    Tuesday, February 1, 2011 9:40 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you.

    We tried to enter name manually, but sql server wasn't found.  SQL Server Browser Service is  running

    Tuesday, February 1, 2011 9:52 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    try to keep SQL Server name as your "Microsoft Dynamic CRM SRS Data Connector URL:" server name :

    Example: Microsoft Dynamic CRM SRS Data Connector URL: http://crm//ReportServer.

    enter "crm"  in Import Organization as SQL Server name.

    Regards, Bhaskar
    Tuesday, February 1, 2011 10:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    http://s-sql1/reportserver

    We wrote http://s-sql1  in Import Organization as SQL Server name, but it didn't help


    Tuesday, February 1, 2011 11:03 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Can you please try with only s-sql1?
    Regards, Bhaskar
    Tuesday, February 1, 2011 11:14 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Have you followed the steps in this article http://support.microsoft.com/kb/952934
    MSCRM Bing'd - http://bingsoft.wordpress.com
    Check out the CRM 4 to CRM 2011 JavaScript Converter Tool
    CRM Forum Guidance on how to Help Us Help You
    Tuesday, February 1, 2011 11:14 AM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote
    Have you checked the firewall of your new server? Are the SQL-ports open?
    Tuesday, February 1, 2011 11:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    it didn't help

    Tuesday, February 1, 2011 12:38 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    we have checked the firewall of our new server , it didn't help. In Native sql client we can see all sql servers, but there aren't any in Deployment Manager

    Tuesday, February 1, 2011 12:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    yes, we have.  but there are no entries in the "SQL Servers" list :(
    Tuesday, February 1, 2011 12:47 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    I'm copying the steps here that are fomr the article above, can you verify you have performed each one, in particular updating the registry

    1. Update the following registry subkeys on the computer that is running Microsoft Dynamics CRM Server:

    configdb

    database

    metabase

    1. To do this, follow these steps:
    2. On the computer that is running Microsoft Dynamics CRM Server, click Start, click Run, type regedit in the Open box, and then click OK.
    3. Locate the following registry subkey:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
    4. Right-click configdb, and then click Modify.
    5. In the Value data box, change the data source to the name of the new SQL Server, and then click OK. For example, the string value in the Value data box should resemble the following:
      Data Source=<var>NewSQLServer</var>;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI
    6. Follow steps 3b-3d for the database subkey and for the metabase subkey.
    7. Notes
    8. If multiple Microsoft Dynamics CRM Roles are in your deployment, you must update the registry keys for all the server roles.
    • If you use the Microsoft Dynamics CRM Data Connector for SQL Server Reporting Services and if you are not moving the SQL Server Reporting Services server, you must update the configdb subkey on the computer on which the Microsoft Dynamics CRM Data Connector for SQL Server Reporting Services is installed.
    1. Configure the Microsoft Dynamics CRM Application to point to the new SQL Server and SQL Server Reporting Services. To do this, follow these steps:
    2. On the computer that is running Microsoft Dynamics CRM Server, click Start, point to All Programs, point to Microsoft Dynamics CRM, and then click Deployment Manager.
    3. Click Organizations.
    4. Right-click the organization that you moved to the new computer that is running SQL Server, and then click Disable.
    5. Right-click the organization that you disabled, and then click Edit Organization.
    6. Type the new name of the SQL Server and the new URL for the SQL Server Reporting Services server.

      Note This step publishes the reports that are in Microsoft Dynamics CRM to the new computer that is running SQL Server Reporting Services server that you specify.
    7. Click Next two times, and then click Apply.
    8. Right-click the organization that you disabled in step 4c, click Enable, and then click Yes.
    • MSCRM Bing'd - http://bingsoft.wordpress.com
    Check out the CRM 4 to CRM 2011 JavaScript Converter Tool
    CRM Forum Guidance on how to Help Us Help You
  • Proposed as answer by Jim Glass Jr Thursday, February 3, 2011 9:40 PM
Tuesday, February 1, 2011 3:43 PM
Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    We run Deployment Manager use "Run as administrator" and it helped Thanks all.
    Thursday, February 3, 2011 7:17 AM