Solved

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

Posted on 2003-12-09
5
1,527 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
  • 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

815 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now