Wednesday, March 7, 2012

Replication

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

No comments:

Post a Comment