I have a Computer / SQL Server machine that ALL software ( 500 applications) know as TMPSQL2
So on this TMPSQL2
machine I have a Database that I want to setup replication with doing Publication.
Problem is that
SQL Server is unable to connect to server 'tmpsql2'.
ADDITIONAL INFORMATION:
SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'TMPSQL7'. (Replication.Utilities)
So that I run
select @@servername
Sure enough it is really TMPSQL7
that i guess someone renamed ? many years ago??
So how can I do a Publication with this issue. Is is NOT an option to rename this machine, many applications are "looking" for TMPSQL2
So the error states that alias is not allowed? I was hoping to do a configuration SSCM alias addition ( pending that is not harmful)
- Can I still do a publication/subscription, if so , how?
- Anything else recommended that will replicate or mirror the database with a new backup i restored on a new machine?