Point to new sql instance

Prior to this you most have backuped and moved the database to the new location

It is highly recommended to use alias for sql connection

You also have to update Service Bus and Workflow Manager if you move those databases as well

  1. First you have to stop all system running for Zervicepoint

    Stop-SBFarm -Verbose
    Stop-WFHost -Verbose
    
    Stop-Service -Name ProcessSystem, ProvisioningSystem, ProvisioningSystemInventory, W3SVC -Verbose
    
  2. You need to update the following configurations files in order to get Zervicepoint to connect to the new instance

    C:\Program Files\Zipper\ZervicePoint\ProcessSystem\Zipper.ZervicePoint.ProcessSystem.WorkflowService.exe.config
    
    C:\Program Files\Zipper\ZervicePoint\Web\AdminWeb\Web.config
    
    C:\Program Files\Zipper\ZervicePoint\Web\ProcessSystem\Web.config
    
    C:\Program Files\Zipper\ZervicePoint\Web\UserWeb\Web.config
    
    C:\Program Files\Zipper\ZervicePoint\Web\WebApi\Web.config
    
  3. After you performed the change on these files it is time to start up all systems again

    Start-Service -Name W3SVC, ProcessSystem, ProvisioningSystem, ProvisioningSystemInventory -Verbose
    
    Start-WFHost -Verbose
    Start-SBFarm -Verbose