(cross-posted to mssql replication newsgroup)

MS-SQL2K (Build 2000.080.0534.00) on Win2K Server (SP4 Build 2195).

I am trying to set up replication using EM/Tools/Replication/Configure
Publising, Subscribers and Distribution ... using the same server "HOSVTSGA"
as Publisher and Distributor and I keep getting the error 141114 with the
error msg:

========
SQL Server Enterprise Manager could not configure 'HOSVTSGA' as the
Distributor for 'HOSVTSGA'

Error 14114 '(null)' is not configured as a Distributor.
========

* What does this error message mean?
* What would be the likely causes of this error?
* How to fix it?

On my test server, I had no problem setting up replication using
EM/Tools/Replication/Configure Publising, Subscribers and Distribution ...

Many thanks for any ideas, pointers ...

--
Van T. Dinh

Please check out this article:
http://support.microsoft.com/default...b;en-us;302223
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Thanks, Paul.

The servername is in the sysservers Table as local but it has been changed
recently and I don't think the server has been stopped and re-start as yet
(SELECT @@servername returns Null).

I get the server stopped and re-started.

BTW, there is another entry "repl_distributor" in the sysservers Table which
was created when I attempted to set up replication. Should I leave this or
delete this (with sp_dropserver) before stopping and re-starting the server?

Thanks, again
Van T. Dinh



"Paul Ibison" <Paul.Ibison (AT) Pygmalion (DOT) Com> wrote

You'll need to keep the repl_distributor entry. This is a remote server used
behind the scenes for publisher-distributor communication (even if they are
one and the same).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Thanks, Paul

--
Van T. Dinh



"Paul Ibison" <Paul.Ibison (AT) Pygmalion (DOT) Com> wrote