[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2003-12-09
5
Medium Priority
?
1,612 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 500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

656 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