Monday, March 19, 2012

Error on configure Distributor

I got an error while trying to configure sql Server 2000 as distributor
Error description:
Error: 14114 '(null)' is configured is a Distributor
Maybe i need to check some services ? Which?
Any suggestion?
Thanks
Message posted via http://www.droptable.com
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