Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transact replication on two computers Expand / Collapse
Author
Message
Posted Sunday, March 17, 2013 7:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 1, 2013 1:57 PM
Points: 7, Visits: 43
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.
Post #1431981
Posted Sunday, March 17, 2013 5:14 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:46 AM
Points: 3,998, Visits: 7,172
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; They'll drag you down to their level and beat you with experience"
Post #1432046
Posted Monday, March 18, 2013 11:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 1, 2013 1:57 PM
Points: 7, Visits: 43
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
Post #1432292
Posted Monday, March 18, 2013 12:12 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:46 AM
Points: 3,998, Visits: 7,172
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; They'll drag you down to their level and beat you with experience"
Post #1432300
Posted Monday, March 18, 2013 1:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 1, 2013 1:57 PM
Points: 7, Visits: 43
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 :)
Post #1432318
Posted Monday, March 18, 2013 4:21 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:46 AM
Points: 3,998, Visits: 7,172
The issue is it can't read the file at D:\unc\DAMIAN-PC$PCTWO_TESTOWA_TEST\




______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1432384
Posted Monday, March 18, 2013 5:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 1, 2013 1:57 PM
Points: 7, Visits: 43
Sorry, I was writing bad patch. The problem exists. Server is on Windows 7 starter. Important it is?
Post #1432403
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse