all groups > sql server replication > may 2005 >
You're in the

sql server replication

group:

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



Re: "Error 14114: '(null)' is not configured as a distributor". Paul Ibison
5/20/2005 12:00:00 AM
sql server replication: 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)

"Error 14114: '(null)' is not configured as a distributor". Hernán Rado
5/20/2005 1:59:18 PM
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

AddThis Social Bookmark Button