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
SQL Server > SQL Server Replication
Comments
Post a Comment