Transact replication on two computers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Transact replication on two computers

Transact replication on two computers

Rate Topic

Display Mode

Topic Options

Author

Message

damian.snoch20

Posted Sunday, March 17, 2013 7:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:33 AM
Points: 4, Visits: 26

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

MyDoggieJessie

Posted Sunday, March 17, 2013 5:14 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:19 PM
Points: 2,037, Visits: 3,761

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" Wink

Post #1432046

damian.snoch20

Posted Monday, March 18, 2013 11:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:33 AM
Points: 4, Visits: 26

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

MyDoggieJessie

Posted Monday, March 18, 2013 12:12 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:19 PM
Points: 2,037, Visits: 3,761

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" Wink

Post #1432300

damian.snoch20

Posted Monday, March 18, 2013 1:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:33 AM
Points: 4, Visits: 26

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

MyDoggieJessie

Posted Monday, March 18, 2013 4:21 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:19 PM
Points: 2,037, Visits: 3,761

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" Wink

Post #1432384

damian.snoch20

Posted Monday, March 18, 2013 5:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:33 AM
Points: 4, Visits: 26

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

Post #1432403

« Prev Topic | Next Topic »

Permissions