Does SQL Server have a max server name limitation for SQL Server Replication with publishers or subscribers?
My coworker is worried about going above 15 characters for a server name. We are currently looking to go to the cloud where it would be really helpful to break the 15 character limit, but my coworker is hesitant about doing so, stating that at least in times past SQL Server replication didn't handle it very well. I've looked as much as I can online and see no current limitations, but unfortunately that doesn't mean there isn't one.
What I know:
I know that you can create a host with a longer name then 15 characters. I also know that in our case, Active Directory truncates the name and appends random characters to the end, but that it stores the actual value as part of the DNS property.
I know that SQL Server @@servername can be longer then 15 characters.
We have an environment where we are migrating to SQL Server 2019 Enterprise from SQL Server 2014 Enterprise, and so have a mix of both. We replicate from SQL Server 2019 to both SQL Server 2019 to SQL Server 2014 Enterprise. If it matters we are running Windows 2012 R2 for SQL Server 2014 and Windows 2019 Standard for the SQL Server 2019 hosts. We have a central distributor that is running SQL Server 2019 Enterprise.
Thanks in advance for any help that you can give.