Solved

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

Posted on 2003-12-09
5
1,560 Views
Last Modified: 2007-12-19
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".
0
Comment
Question by:sanjaykashyap19
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 9902657
Hi sanjaykashyap19,
ok which version of sql server....

and where about in the wizard / process are you actually...

Cheers!
0
 
LVL 5

Author Comment

by:sanjaykashyap19
ID: 9902682
publisher and distributor sqlserver7.0  and subscriber sqlserver 2000. Using sqlserver 2000 enterprise manager.
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 9902747
so you have a distrinutor set up already?

or gave you tried configuring the distributor via  the sql 7 enterprise manager
and then letting the sql 2k subscribe?

which fixpacks / levels

and what sort of replication.?
0
 

Accepted Solution

by:
rsrsm earned 125 total points
ID: 9903208
I found a relevant MS KB for the error message..let me know if it helps..
http://support.microsoft.com/default.aspx?scid=kb;en-us;302223

RSRSM
0
 
LVL 5

Author Comment

by:sanjaykashyap19
ID: 9908994
Thanks rsrsm
I did every thing same, but forget to restart SQLServer.

Sanjay Kashyap
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question