Post reply

Transact replication on two computers

  • March 17, 2013 at 7:26 am

    #272259

    Hello

    I am trying create transactional replication with updatable with subscriptions on two PC ( between instances database is OK ).

    On PC1 I was creating publicator ( include tables ), On PC2 I was creating Subscription ( I logged on PC1, choosed database and table ), next I was writing data to created linked server and I have error:

    http://tinypic.com/view.php?pic=vnijk1&s=6

    Screen step by step:

    http://tinypic.com/view.php?pic=2vlo009&s=6

    http://tinypic.com/view.php?pic=nb9qaa&s=6

    This data to linked server is ok because between instancesit works.

  • March 17, 2013 at 5:14 pm

    #1597931

    At the SQL Server instance level do you have the publisher and subscriber to "Allow Remote Connections?"

    And in your linked server, have you enabled "data access"?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • March 18, 2013 at 11:59 am

    #1598131

    Ok, I fixed it. I have next problem. I created network drive. When I created distributor, I pointed the patch to network drive but on the server ( publicator ) is error:

    http://tinypic.com/view.php?pic=11r5ef5&s=6

    I greet

  • March 18, 2013 at 12:12 pm

    #1598137

    This error is "The system cannot find the path specified"

    Check that the service account (running your replication agents, etc.) have the necessary permissions to the directory(ies) - currently it can't see/write to D:\unc\...

    http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/b4c64c77-58c3-48dc-8496-9d3ec7795071/

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • March 18, 2013 at 1:11 pm

    #1598150

    Folder \\DAMIAN-PC\My job is to write/read and other subfolders. I have no idea.... ( Wirte/Read for Everyone and many others users.... )

    Help me 🙂

  • March 18, 2013 at 4:21 pm

    #1598209

    The issue is it can't read the file at D:\unc\DAMIAN-PC$PCTWO_TESTOWA_TEST

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • March 18, 2013 at 5:11 pm

    #1598228

    Sorry, I was writing bad patch. The problem exists. Server is on Windows 7 starter. Important it is?

Viewing 7 posts - 1 through 6 (of 6 total)

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