Hello, I'm again dealing with this, and it's driving me crazy :w00t:

I've start over again and folowed the MS steps https://msdn.microsoft.com/en-US/library/hh710046(v=sql.120).aspx, most of them give the result => 'Command(s) completed...

Yes, sure!

I'll start over again from scratch and log results

Just one clarification, I'm using SQL Server 2014 and the link you provided is intended for the upcoming SQL Server 2016

Also, under my Replication Monitor after a faillover I can see the publication still depends on SRVSQL1 and SRVSQL2 is empty but acting like primary node :crazy:

In my case this will be:

Run on the distributor (SRVSQL3)

USE distribution;

GO

EXEC sys.sp_redirect_publisher

@original_publisher = 'SRVSQL2', -- the new publisher

@publisher_db = 'MyPublishedDB',

@redirected_publisher = 'SQL';...