Hi,
I have set a transactional replication, and everything
looks fine, but I get the following error message in my
Subscriptions:
( 'Server Name' is not configured as a distributor. The
step failed. )
any idea,
Thanks
Matthew,
Try (on the publisher/distributor):
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services
HTH,
Paul Ibison
Wednesday, March 7, 2012
Replication
Labels:
database,
error,
everythinglooks,
following,
message,
microsoft,
mysql,
mysubscriptions,
oracle,
replication,
server,
sql,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment