replication/distributor problem

[Piotrek Stachowicz]

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

[Allan Mitchell]

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