none
CRM 2016的變更資料庫問題請教 RRS feed

  • 問題

  • 各位好!

    如果當初建置CRM 2016的時候,選擇了使用內建的SQL Server Express,後續可以再調整為使用其他已存在的SQL Server Standard嗎?

    謝謝~

    PS.因為不確定CRM要發在哪一區,所以先發在這邊,如果有需要再麻煩相關人員調整,感恩!

    2016年10月28日 上午 02:56

所有回覆

  • Hi,

    1. Changed registry to point to new SQL Server

    2. Changed all organization rows/records in MSCRM_CONFIG ->Organization table to use new server

        a. Open SQL Server Managment Studio->browse down to MSCRM_CONFIG->Tables-> find dbo.Organization->Right click->Edit top 200 rows

        b. Find "Connection string" column and change "data source=" value to your new SQL server instance name. (in my case was "devsql006" ->new sql server "devsql006\sql2012")

        c. Find "SQLServerName" column and change data to your new SQL Server instance name ("devsql006"->"devsql006\sql2012")

    then it worked perfectly, I hope it will help someone.

    -----------------------------------------------------------------------------------------------------------------------------

    出現以下錯誤時,

    A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 172.23.201.162:80

    -----------------------------------------------------------------------------------------------------------------------------

    USE MSCRM_CONFIG

    Update DeploymentProperties SET NVarCharColumn = ‘New IP Address’  WHERE ColumnName= ‘AsyncSdkRootDomain’

    Update DeploymentProperties SET NvarCharColumn = ‘New IP Address’  WHERE ColumnName = ‘ADSdkRootDomain’

    Update DeploymentProperties SET NvarCharColumn = ‘New IP Address’  WHERE ColumnName = ‘ADWebApplicationRootDomain’


    Hi there, if you found my comment very helpful then please | Propose as answer | . Thanks and Regards.

    2016年12月8日 上午 09:07
  • Hi,

    1. Changed registry to point to new SQL Server

    2. Changed all organization rows/records in MSCRM_CONFIG ->Organization table to use new server

        a. Open SQL Server Managment Studio->browse down to MSCRM_CONFIG->Tables-> find dbo.Organization->Right click->Edit top 200 rows

        b. Find "Connection string" column and change "data source=" value to your new SQL server instance name. (in my case was "devsql006" ->new sql server "devsql006\sql2012")

        c. Find "SQLServerName" column and change data to your new SQL Server instance name ("devsql006"->"devsql006\sql2012")

    then it worked perfectly, I hope it will help someone.

    -----------------------------------------------------------------------------------------------------------------------------

    出現以下錯誤時,

    A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 172.23.201.162:80

    -----------------------------------------------------------------------------------------------------------------------------

    USE MSCRM_CONFIG

    Update DeploymentProperties SET NVarCharColumn = ‘New IP Address’  WHERE ColumnName= ‘AsyncSdkRootDomain’

    Update DeploymentProperties SET NvarCharColumn = ‘New IP Address’  WHERE ColumnName = ‘ADSdkRootDomain’

    Update DeploymentProperties SET NvarCharColumn = ‘New IP Address’  WHERE ColumnName = ‘ADWebApplicationRootDomain’


    Hi there, if you found my comment very helpful then please | Propose as answer | . Thanks and Regards.

    Thanks^^
    2016年12月8日 上午 09:36