Setting up replication over the internet

• azhan

  Newbie

  Points: 3

  More actions

  May 30, 2003 at 4:14 am

  #80341

  Hi

  I am having difficulty setting up replication on my database server (MyDB) which is a SQLServer v7. In SQLServer Enterprise Manager, I selected MyDB and from the menu selected

  Tools->Replication->Create & Manage Publications->Create Publication->Next

  and I get a popup with this error msg:

  SQL Server Enterprise Manager could not complete the wizard because @@SERVERNAME for '' is NULL. User sp_addserver to set @@SERVERNAME

  I tried using sp_addserver from Query Analyser and got this msg:

  sp_addserver 'myServer'

  ----------------------

  (1 row(s) affected)

  (1 row(s) affected)

  Server added.

  (1 row(s) affected)

  (1 row(s) affected)

  But when I tried to setup replication (as above) the same popup error msg appears.

  I am definitely missing some steps here, if anyone could help me along I would be most grateful!

  Thank you.

  -azhan

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  May 30, 2003 at 5:36 am

  #459165

  It might be a stupid question, but did you configure publishing on your server?

  Also run a profiler trace to see what is actually happening.

  [font="Verdana"]Markus Bohse[/font]