Hi @Nagarjuna Reddy,
Thanks for the error messages you provided. You can follow the steps below to troubleshoot and solve your errors:
- The error 'No replicated transactions are available.' states that your subscription is uninitialized. You need to create the initial snapshot and verify the Log Reader Agent is running. You can try to drop the subscription and try again. Ensure the subscription has all of the required permissions in Replication Agent Security Model.
- From the error 'The process could not execute 'sp_replcmds' on 'XXXXXX'.', I think it could be possible that owner of the database could be someone other than what you have permissions for. If this method does not work, you can try another method according to the troubleshooting method in this link: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/replication/error-replication-log-reader-agent-fails
- For the error ‘ TCP Provider: An existing connection was forcibly closed by the remote host.’, please gather the following information:
- The text of the error message and the error codes. Check whether the error is intermittent or consistent.
- Application and system event logs from SQL Server and client system. These logs can help check if there are any system wide issues occurring on your SQL Server.
- If the connections are failing from an application, collect the connection strings from the application. These strings are typically found in Web.config files for ASP.NET applications.
- Collect and review SQL Server error logs for other error messages and exceptions.
- If you have administrator access to the SQL Server computer, gather and review current computer settings and service accounts by using the following procedure:
- Download the latest version of SQL Check from the https://github.com/microsoft/CSS_SQL_Networking_Tools/wiki
- Unzip the downloaded file into a folder.
- Run the command prompt as an administrator to collect the data and save to a file.
Please feel free to share with us any problems you encounter that cannot be resolved.
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://docs.microsoft.com/en-us/answers/support/email-notifications