Error running sys.sp_validate_replica_hosts_as_publishers


  • I am working with setting up Replication Publishers in AlwaysOn Availability Groups, and after running sp_redirect_publisher, there is a new stored procedure in SQL 2012 called sys.sp_validate_replica_hosts_as_publishers that validates your configuration is correct.  Occording to BOL this procedure creates a temporary linked server to the nodes in the Availability Group and validates they are suitable for handling replication and uses the windows credentials of who is currently logged in.  I am logged in as a windows account that is both domain admin as well as SQL sysadmin on all my instances but keep getting an error when running this procedure.

    Here is the code I am running from the distributor

    declare @redirected_publisher sysname
    exec sys.sp_validate_replica_hosts_as_publishers 
         @original_publisher = 'SQL1', 
         @publisher_db = 'TestPub', 
         @redirected_publisher = @redirected_publisher output
    select @redirected_publisher

    I am getting the following error.  I am running SQL 2012 SP1 and am wondering is I am missing some sort of security configuration or if this is a bug that needs to be filed

    Msg 21892, Level 16, State 1, Procedure sp_hadr_validate_replica_hosts_as_publishers, Line 60
    Unable to query sys.availability_replicas at the availability group primary associated with virtual network name 'CHAD-PUB-AGList' for the server names of the member replicas: error = 18456, error message = Error 18456, Level 14, State 1, Message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'..',

    Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

    Mittwoch, 16. Januar 2013 15:22


Alle Antworten