-> I was trying to configure Transactional replication on one of the SQL Server Instance and got below error,
TITLE: Configure Distribution Wizard
Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.0.18369.0&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476
Replication components are not installed on this server. Run SQL Server Setup again and select the option to install replication. (Microsoft SQL Server, Error: 21028)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.2000&EvtSrc=MSSQLServer&EvtID=21028&LinkId=20476
-> This is when I realized that replication features were not selected for this SQL Server Instance during Installation.
-> I opened the SQL Server setup files and clicked on “New SQL Server stand-alone installation or add features to an existing installation”.
-> Select “Add feature to an existing instance of SQL Server 2019” and select appropriate instance,
-> Select “SQL Server Replication” as shown in below screenshot,
-> Once the add feature is done. I was able to move ahead and configure Transactional replication.
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.