?
Solved

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

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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

809 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