You are using the “setspn-a” cmd. You likely have a duplicate spn on the domain. Use the -s in place of -a to create the spn.

This is from this link:

Why use log shipping or any of the other options suggested when you are already using the only tool you need.??

Simply add a 3rd stand alone node (non-member node) to...

I use a combo of CTE and XML to split the strings makes it super fast and easy.

DECLARE @DELIMITER VARCHAR(50)='|||'
;WITH CTE AS
(SELECT
S.NAME
,SOUCE=S.RAW_DATA
,XML=CAST('<M>' + REPLACE(S.RAW_DATA, @DELIMITER, '</M><M>') +...