Post reply

Remote Dist - Snpsht / Trans Replication Fails to Create

  • September 8, 2005 at 4:11 am

    #91024 

    Hi Guys
    Below is a copy of my post the Microsoft version of this Newsgroup ... but rather than an MVP, have just got the ususal drivel u get from ppl who haven't a clue what they're on about! All help appreciated!
    Cheers
    Vinny
    ****************************************************************
    Hi AllI'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!? lolThe 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!CheersMark
    *******************************************************************

  • September 9, 2005 at 7:49 am

    #588715

    My aren't we being snide Vinny or is it Mark?

    I strongly suggest you review the posts in groups.google.com for 14294 , ie

    http://groups.google.com/group/microsoft.public.sqlserver.replication/search?group=microsoft.public.sqlserver.replication&q=14294+&qt_g=1&searchnow=Search+this+group

    Microsoft PSS support engineers have responded with some answers there you might want to review.

    You might also want to open a support incident with PSS.

    Hilary

     

     

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply