By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,187 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,187 IT Pros & Developers. It's quick & easy.

replication/distributor problem

P: n/a
Hello,
I'm trying to set up transactional replication on two SQL2k Servers.
Unfortunately I stuck on the following problem:
I use 'Configure Publishing and Distribution Wizard' , I make one of the
servers (publisher) its own distributor, then I set all the paths .After
pressing 'Finish' button, the wizard tries to perform next step i.e.
'Configuring Distributor' and I get the error:
"Error 14114: '(null)' is not configured as a Distributor". Does anyone have
idea what I should do in order to solve the problem?

I tried to run procedures manually, and I get exactly the same error when I
try to execute sp_adddistributondb

Thanks,

Piotrek
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
try this in QA

SELECT @@ServerName

My guess is that this returns NULL.

Now do

Exec sp_AddServer '<Name>', 'local'

Restart the SQL Server and try again

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Piotrek Stachowicz" <dy******@poczta.onet.pl> wrote in message
news:cd**********@news.onet.pl...
Hello,
I'm trying to set up transactional replication on two SQL2k Servers.
Unfortunately I stuck on the following problem:
I use 'Configure Publishing and Distribution Wizard' , I make one of the
servers (publisher) its own distributor, then I set all the paths .After
pressing 'Finish' button, the wizard tries to perform next step i.e.
'Configuring Distributor' and I get the error:
"Error 14114: '(null)' is not configured as a Distributor". Does anyone have idea what I should do in order to solve the problem?

I tried to run procedures manually, and I get exactly the same error when I try to execute sp_adddistributondb

Thanks,

Piotrek

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.