Monday, February 13, 2012

"Error 14114: '(null)' is not configured as a distributor".

When I try to configure this server to be it's own distributor, the wizard
gets as far as "Configuring distributor" when I get the error that it cannot
be set up as the distributor for itself because "Error 14114: '(null)' is
not configured as a distributor".
How can I fix this problem ?
Thanks
Try:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment