Friday, March 16, 2018


I had a requirement to move root level site collection as a subsite, as everyone knows this can be done by using the Granular back up for the site, you need to take .cmp file,
I tried to restore the site to a sub site, i was unable to import it as the site template for the destination site is not matching with the backup file which i took,
i.e. The back up which i took is BLANKINTERNET#0 web template, and i created a blank site wanted to override this site, i.e. STS#1, then again i tried to create a publishing site as the source was the publishing site, again this did not work, becouse  destination was CMSINTERENET#1 site,
the best solution is to create site of source site, i wrote a power shell script to achieve this,

Fixing: The client and server cannot communicate, because they do not possess a common algorithm


A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.) (Microsoft SQL Server, Error: -2146893007)"

run below PS in your server, I got it from somewhere from internet. which fixed my servers
note: it will ask for restart.