"Mark Harris" <MarkHarris@discussions.microsoft.com> wrote in message
news:55B6B40A-9561-43B2-9FFC-63C08268CA3A@microsoft.com...
> you'll have to clarify a little ... "previous publications" of what?? from
> the same database, ANY other database??
>
> and which server am i running "select @@servername" against... baring in
> mind that the whole point is that i'm testing Remote distribution and
> therefore have two of the little devils ... and why is this relevant??
>
> "Hilary Cotter" wrote:
>
> > There have been reports of this error being caused by previous
publications
> > not being cleaned up correctly.
> >
> > The best way to fix this is to disable publisher and replication on the
> > publisher and try to reenable it.
> >
> > Also what does select @@servername return?
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> > "Mark Harris" <MarkHarris@discussions.microsoft.com> wrote in message
> > news:43481428-5374-42E2-9955-3E74D921880C@microsoft.com...
> > > Hi All
> > >
> > > I'm currently "Proof of Concept"ing our new server architecture, which
is
> > > going to contain a Master SQL Server with a Remote Distributor. After
> > > ploughing through the initial permission probs, i've hit another
problem
> > that
> > > i dont know how to get around.
> > >
> > > If i try to create a Publication that is either Snapshot or
Transaction,
> > > Enterprise Manager comes up with :
> > >
> > > " ... Could not create publication ...
> > > Error 14294 : Supply either @jobID or @JobName to Identify the job"
> > >
> > > ... which i'm finding a little strange as nowhere on the Wizard has it
> > asked
> > > me anything about jobs!? lol
> > >
> > > The same thing does NOT occur if i setup a Merge Publication ... and
this
> > is
> > > created correctly with both Publisher and Remote Distributor being
> > perfectly
> > > happy!
> > >
> > > As mentioned, i'm just proving things out at the minute so this isn't
> > > desperately urgent ... but i will be needing the capability to create
any
> > > type of Publication that will use the Remote Distributor ... so all
help
> > > appreciated!
> > >
> > > Cheers
> > >
> > >
> > > Mark
> >
> >
> >