locked
Deployment Manager issue: SQL Server is unavailable RRS feed

  • Question

  • Hi Experts,

    I am facing the issue with deployment manager when trying to create new organisation entry. It is giving error " SQL server is unavailable. Below is the brief of my problem:

    Earlier application & CRM database was on same server & it was working perfectly fine.

    But when we migrated the Database on another server, application was able to connect to database.
    but we are not able to add new entry in organiser. When we are trying this it was saying that "SQL Server is unavailable." ( But SQL Server is running fine.) 

    Note: Firewall is turned off
    There is no network issue
    SQL Services are running fine 

    Any help on this would be appreciable.

    Thanks in advance


    Regards,
    Yashwant Vishwakarma | SQLOcean.com


    Yashwant Vishwakarma | www.sqlocean.com

    Wednesday, June 3, 2015 11:43 AM

All replies

  • Does the user you use when you run the deployment manager have permission to access/manage the new instance of SQL?

    Halldór Jóhannsson

    Wednesday, June 3, 2015 12:26 PM
  • Hi Halldor,

    The user which I am using to run the deployment manager have all the permissions.

    Regards,
    Yashwant Vishwakarma | SQLOcean.com


    Yashwant Vishwakarma | www.sqlocean.com

    Thursday, June 4, 2015 5:05 AM
  • Hmm, you could try repairing the CRM installation, or even uninstall it, install again and connect to the existing database, this might fix anything that might be missing (SPNs, domain group adds etc).

    Are you getting any errors in the event viewer or logs?


    Halldór Jóhannsson


    Thursday, June 4, 2015 9:47 AM
  • You could also try and create it with powershell.

    Create a CRM Organization

    You can create a new CRM organization in the Microsoft Dynamics CRM deployment, using the Deployment Manager or the CRM PowerShell tools. Use the following procedure to create a new tenant organization in CRM using the CRM PowerShell cmdlet.

    1. Logon to the CRM server with the Deployment Administrator role, such as CRMDEP01, as a CRM Deployment Administrator.
    2. Launch an administrative Windows PowerShell window from the quick launch bar, or from the Start menu under Program Files, Accessories, Windows PowerShell, and then Windows PowerShell.
    3. In the Windows PowerShell command window, execute the following commands:

      Add-PSSnapin Microsoft.Crm.PowerShell

    4. In the Windows PowerShell command window, execute the following command to create a CRM organization for the hosted tenant organization.

      New-CrmOrganization -DisplayName "Alpine Ski House" -SQLServerName "CRMSQL" -SrsUrl "http://CRMSQL/ReportServer" -Name "alpineskihouse" -BaseCurrencyCode "USD" -BaseCurrencyName "US Dollar" -BaseCurrencySymbol "$" -BaseCurrencyPrecision "2" -BaseLanguageCode 1033 -SqlCollation "Latin1_General_CI_AI" -SQMOptIn false

      Note

      Although the GUID of job will be returned upon successful submission of the request, the actual creation process may take a significant amount of time.

      For more details on the New-CRMOrganization cmdlet parameters, see the Deployment Manager Help contents.

      Syntax:

      New-CrmOrganization -DisplayName display_name -SQLServerName sql_server_name -SrsUrl srs_url -Name name -BaseCurrencyCode base_currency_code -BaseCurrencyName base_currency_name -BaseCurrencySymbol base_currency_symbol -BaseCurrencyPrecision base_currency_precision -BaseLanguageCode base_language_code -SqlCollation sql_collation {-SQMOptIn true|false}

      where:

    • display_name is the display name of the organization that will be imported. If no display name is provided, the default behavior is to use the existing display name in the organization's database. (mandatory)
    • sql_server_name is the name of the SQL Server database server on which to look for the organization database to import. (mandatory)
    • srs_url is the URL of the SRS reporting server for the organization that will be imported. (mandatory)
    • name is the unique name of the organization that will be imported. If no unique name is provided, the default behavior is to use a unique version of the display name. (Optional)
    • base_currency_code is the base currency code for the organization to be created, for example, "USD" for US dollar.
    • base_currency_name is the name of the base currency, for example, "US Dollar" for USD. If no base currency name is provided, the default behavior is to use a currency name based on the base_currency_code specified.
    • base_currency_symbol is the symbol of the base currency, for example, "$" for the US Dollar. If no base currency symbol is provided, the default behavior is to use a value based on the base_currency_code specified.
    • base_currency_precision is the decimal precision of the base currency, for example, two decimal places for US Dollar. If no base currency precision is provided, the default behavior is to use a value based on the base_currency_code specified.
    • base_language_code is the code for the base language for the organization being created, for example, "1033" for English.
    • sql_collation is an enumerated (enum) value that specifies the preferred SQL collation that the organization database will use to sort and compare data characters.
    • SQMOptIn specifies whether to have the organization participate in the Customer Experience Improvement Program. The default value is false.


    Halldór Jóhannsson

    Thursday, June 4, 2015 10:06 AM