SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name (Replication.Utilities)


canot create subscription

please me

i error code is:

title: connect server
------------------------------

cannot connect 89.19.13.138.

------------------------------
additional information:

sql server replication requires actual server name make connection server. specify actual server name, '94de80acd308'. (replication.utilities)

------------------------------
buttons:

ok
------------------------------

please check links

my server info : http://www.tolgasimsek.com/11.jpg

and

error screen : http://www.tolgasimsek.com/22.jpg


this can happen when publisher or subscriber hostname has been renamed @ point.

on publisher , subscriber execute this:

select @@servername

on both publisher , subscriber execute this:

select * sys.servers

also, on both publisher , subscriber execute command prompt:

hostname

you should see mismatch in names.  if so, drop publication , disable distribution.  execute sp_dropserver , sp_addserver , restart sql services.

sp_dropserver <old_name>; go sp_addserver <new_name>, local; go

then reconfigure replication.

replication requires actual server name - incorrect server name


brandon williams (blog | linkedin)



SQL Server  >  SQL Server Replication



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........