I was trying to create a distribution database on an instance of SQL Server 2016 SP1 Standard Edition.
I got an error that the replication component of SQL Server was not installed. We have recently upgraded our server from SQL Server 2012 to 2016 where we had tested replication to a dev machine previously.
It occurred to me that the reason that the replication components aren't installed is that we perhaps aren't paying for them. Looking at the licensing guide found HERE, I can't find information on replication specifically - either because it IS included in the basic SQL Server app or it falls under some generic product name like 'Enterprise Data Management', or something else.
- Does SQL Server 2016 Standard Edition include replication?
- Does the Distribution server count as a separate instance of SQL Server and require its own license?
- If we are using this as a testing 'dev' ground, do we still need to purchase licenses for replication from prod to dev, with the distribution server hosted on the same dev machine?