locked
Deploy Workflow Manager RRS feed

  • Question

  • Hello!

    I just want to deploy Workflow Manager in production.

    I have already done it in dev, but it was a single server.

    Now I wonder, does it matter, which SQL server I write in settings for hosting Workflow database? I mean should it be the same, that hosts SharePoint, or it may be different?

    Thanks a lot in advance!

    Kate.



    • Edited by Kate_S Friday, August 1, 2014 5:17 AM
    Friday, August 1, 2014 5:06 AM

Answers

  • Hello Kate - Depending on your deployment you can keep workflow DB in same SP SQL server or separate SQL server. In most of the cases when workflow is hosted centrally in the organization then workflow DB is always separated from SP DB's. If workflow is only catering SharePoint sites then you can keep in same SQL server.

    -prs

    • Marked as answer by Kate_S Friday, August 1, 2014 11:12 AM
    Friday, August 1, 2014 6:25 AM
  • Hello Kate - It is good practice to keep both DB's in separate servers however I will be happy to assist you in resolving your SP SQL server issue.  Pls raise your question in SQL forum.

    -prs

    • Marked as answer by Rebecca Tu Thursday, September 11, 2014 9:40 AM
    Friday, August 1, 2014 12:12 PM

All replies

  • Hi Kate,

    Pls refer the below links

    http://msdn.microsoft.com/en-us/library/jj193466(v=azure.10).aspx

    http://channel9.msdn.com/Events/SharePoint-Conference/2014/SPC356


    Please remember to click 'Mark as Answer' on the answer if it helps you

    Friday, August 1, 2014 5:32 AM
  • HI Kate,As I understand You want to deploy workflow manager in farm.We can deploy the workflow manager which share point DB resides.Please check the below to get more light.

    http://expertsharepoint.blogspot.de/2014/08/deployment-of-workflow-manager.html


    Anil Avula[MCP,MCSE,MCSA,MCTS,MCITP,MCSM] See Me At: http://expertsharepoint.blogspot.de/

    Friday, August 1, 2014 6:14 AM
  • Hello Kate - Depending on your deployment you can keep workflow DB in same SP SQL server or separate SQL server. In most of the cases when workflow is hosted centrally in the organization then workflow DB is always separated from SP DB's. If workflow is only catering SharePoint sites then you can keep in same SQL server.

    -prs

    • Marked as answer by Kate_S Friday, August 1, 2014 11:12 AM
    Friday, August 1, 2014 6:25 AM
  • Thank you for your answers!

    Prithvi Raj, now we have some problems whith performance of SP SQL Server, so I would like to keep SP and workflow DB's in separate servers. So, there aren't any possible troubles, that I should be prepare for?

    Kate


    • Edited by Kate_S Friday, August 1, 2014 8:14 AM
    Friday, August 1, 2014 6:46 AM
  • Hello Kate - It is good practice to keep both DB's in separate servers however I will be happy to assist you in resolving your SP SQL server issue.  Pls raise your question in SQL forum.

    -prs

    • Marked as answer by Rebecca Tu Thursday, September 11, 2014 9:40 AM
    Friday, August 1, 2014 12:12 PM