Adding a Remote Distributor for a Transactional Replication

You may encounter the following messages when creating a remote Distributor :   TITLE: Configure Distribution Wizard—————————— SQL Server could not connect to the Distributor using the specified password. For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.0.2100.60&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=CantConnectAdminPassword&LinkId=20476 ——————————ADDITIONAL INFORMATION: An error occurred during decryption.There is no remote user ‘distributor_admin’ mapped to local user ‘(null)’ from the remote server ‘759D11CB-6B1A-4AAD-9D8E-5A89B2DAA151’….

0

The subscription(s) have been marked as inactive

While you are troubleshooting the following error : “The subscription(s) have ben marked as inactive” Please make sure you have checked the following : 1. MSSubscriptions  table and the value is showing as zero for the status column http://technet.microsoft.com/en-us/library/ms188368.aspx 2. The subscription for transaction replication have not crossed the max. retention period. 3. You have…

0