Article ID: 302223 - View products that this article applies to.
This article was previously published under Q302223
When you try to set up a SQL Server server as a distributor for replication, the following error message may occur:
Error 14114:(NULL) is not configured as a distributor
The error message appears because there is not an entry for the local server in the sysservers table in the master database.
To verify that there is no entry for the local server in the sysservers table in the master database, connect to the local server and run "select @@servername" from Query Analyzer. If a (NULL) is returned, then an entry for the local server does not exist in the sysservers table in the master database.
To correct the problem, use these steps:
SQL Server 2000 Books Online; topic: "Renaming Servers"
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/321822/ )How to replicate between computers that are running SQL Server in non-trusted domains or across the Internet
Article ID: 302223 - Last Review: November 30, 2005 - Revision: 4.3