Replication on SQL Server

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Danilo Popoviæ

    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
    Toplièka 16
    49240 Donja Stubica
    Croatia






  • Danilo Popoviæ

    #2
    Re: Replication on SQL Server

    Hi 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
    Toplièka 16
    49240 Donja Stubica
    Croatia



    Comment

    • Dean

      #3
      Re: Replication on SQL Server

      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.h r> wrote in message
      news:bku3va$6jj $1@sunce.iskon. hr...[color=blue]
      > Hi again,
      >
      > I have a problem with replication on SQLServer 2000. I've started[/color]
      "Configure[color=blue]
      > 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[/color]
      (valid[color=blue]
      > values are returned by sp_helpserver'. I didn't type server name[/color]
      "@Server",[color=blue]
      > because I've used wizard.What is a problem?
      >
      > Thank you in advance,
      >
      > Danilo Popoviæ, B. Sc.
      > Trgostil d.d. - IC
      > Toplièka 16
      > 49240 Donja Stubica
      > Croatia
      >
      >
      >
      >
      >
      >[/color]


      Comment

      Working...