Sunday, February 26, 2017

My Footsteps On Configuring Sitecore Publishing Service 2.0

Recently I was task with configuring the latest Sitecore Publishing Service 2.0 into an existing Sitecore 8.2 environment. Following are the few points that I thought good to mention from my experience.





You can download the software and documentation with all the information from following link
https://dev.sitecore.net/Downloads/Sitecore_Publishing_Service/20/Sitecore_Publishing_Service_20_Initial_Release.aspx


After downloading, I installed the Pre-requisit of Windows Server Hosting (.NET Core) into the machine.

Then I followed the "Scripted Installation" option described in the documentation. It was much easier than the manual installation and provided lot of easy options.

Few points from my setting-up experience mention below.

1) Setting-up Connection Strings

For example, I ran the following command to setup 'Core' connection string


$ Sitecore.Framework.Publishing.Host configuration setconnectionstring core '<your_connection_string>' 

This will setup connectiong string on following file
<Publishing_Service_Web_Root>/config/global/sc.connectionstring.json 

Note that, it will automatically add "MultipleActiveResultSets=True;" to your connection string to support Multiple Active Result Sets (MARS).


2) Adding support to Multiple Active Results Sets on Sitecore Installation Connection Strings

To support Mutiple Active Result Sets (MARS) you have to add "MultipleActiveResultSets=True;" to end of your connection strings in your Sitecore installation.

i.e. to <Sitecore_Website_Root>/App_Config/ConnectionStrings.config

  <add name="core"  connectionString="Integrated Security=true;Data Source=(local);Database=sitecore_core822;MultipleActiveResultSets=True;" />
  <add name="master"  connectionString="Integrated Security=true;Data Source=(local);Database=sitecore_master822;MultipleActiveResultSets=True;" />
  <add name="web"  connectionString="Integrated Security=true;Data Source=(local);Database=sitecore_web822;MultipleActiveResultSets=True;" />

3) Remember to do IIS Reset for Publishing Service Website Once you do any Configuration Updates 

Not like Sitecore, you will have to do IIS Reset for Publishig Service Site to make your Configuration changes in Sitecore Publishing Service Website to take effect.