Monday, March 12, 2012

Replication on SQL Server

Hi again,

I have a problem with replication on SQLServer 2000. I've started "Configure
Publishing and Distribution Wizard" and SQLSrvr posted message "SQLServer
Enterprise Manager colud not configure 'DANILOPOPOVIC' as the Distributor
for 'DANILOPOPOVIC'. Error 14234: The specified '@.Server' is invalid (valid
values are returned by sp_helpserver'. I didn't type server name "@.Server",
because I've used wizard.What is a problem?

Thank you in advance,

Danilo Popovi, B. Sc.
Trgostil d.d. - IC
Toplika 16
49240 Donja Stubica
CroatiaHi again,

I've tried the same thing on another server TRGO2000 and SQLSrvr posted
message "SQLServer Enterprise Manager colud not configure 'TRGO2000' as the
Distributor for 'TRGO2000'. Error 14114: '(null)' is not configured as a
Distributor. '.

Danilo Popovi, B. Sc.
Trgostil d.d. - IC
Toplika 16
49240 Donja Stubica
Croatia|||I had a similar problem using the Wizards to set replication with the
Version 7 of EM. It was because the servers were registered in the EM with a
different name to the Actual Server Name. So I would check that the Servers
are registered with the correct Server/Instance Name.

Hope this Helps

Cheers
Dean

"Danilo Popovi" <adf@.trgostil.hr> wrote in message
news:bku3va$6jj$1@.sunce.iskon.hr...
> Hi again,
> I have a problem with replication on SQLServer 2000. I've started
"Configure
> Publishing and Distribution Wizard" and SQLSrvr posted message "SQLServer
> Enterprise Manager colud not configure 'DANILOPOPOVIC' as the Distributor
> for 'DANILOPOPOVIC'. Error 14234: The specified '@.Server' is invalid
(valid
> values are returned by sp_helpserver'. I didn't type server name
"@.Server",
> because I've used wizard.What is a problem?
> Thank you in advance,
> Danilo Popovi, B. Sc.
> Trgostil d.d. - IC
> Toplika 16
> 49240 Donja Stubica
> Croatia
>
>

No comments:

Post a Comment