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

Replication OS error 5 Expand / Collapse
Author
Message
Posted Tuesday, November 30, 2010 2:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 6, 2014 3:11 AM
Points: 5, Visits: 70
Dear all,

I am doing some experiments with SQL server replication. Basically I have the following setup with two sql servers

Server1:
DB1: Publisher
DB2: Subscriber

Server2:
DB3: Subscriber

I have successfully managed to implement replication on Server 1 DB2, however for Server2 DB 3, I am getting the following error in the replication monitor:

The process could not read file '\\Server1\SQLShareFiles\unc\Server1_SHOP_COUNTRIES\20101130095003\tblCountries_2.pre' due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL21022)
Get help: http://help/MSSQL_REPL21022
Access is denied.
(Source: MSSQL_REPL, Error number: MSSQL_REPL5)
Get help: http://help/MSSQL_REPL5

From Server2 I am fully able to access the shared folder SQLShareFiles and all its subfolders....any suggestions how this might be solved?

tnx

tyrone
Post #1027807
Posted Tuesday, December 7, 2010 10:19 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 968, Visits: 964
What service account are you using for the publication? Since you can get it working on DB1 on server1, it sounds like the service account might be set to the SQL Server Agent.

Is server2 using the same SQL Server Agent account? If not, make sure that Agent account has access to the server1 share. If this is the local system account, I'd recommend changing both hosts to a domain service account, something that you'd be able to grant access to the share. I've seen issues where you get access denied simply because server1 doesn't know "who" is accessing it, so it rejects.

If you configured a different account to run the replication configuration, then you'd need to validate that login has access to the share as well.

My guess is your personal account has access to the share, but that doesn't mean the accounts replication is looking at to work has access.

Best of luck,
Steve
Post #1031645
Posted Wednesday, December 8, 2010 3:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 6, 2014 3:11 AM
Points: 5, Visits: 70
Hi Steve,

tnx for your reply...actually I am not using any domains as this is a setup on a simple local network and I guess that is the problem.

However I managed to get replication to work by managing the replication process of DB3 (Server 2) from server 1...ie server 1 manages 2 subscriptions: DB2 & DB3.

tnx for your reply

tyrone

Post #1031735
Posted Tuesday, August 21, 2012 1:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 8, 2013 5:46 AM
Points: 5, Visits: 26
I know this is very late reply, but I hope it helps somebody.
The solution is to have same user (not domain user) created on both server boxes with the same password.
Make sure this user have access to the snapshot folders.
Then use windows authentication all along while setting up the replication.
Read this article for more details:
http://msdn.microsoft.com/en-us/library/ms151227.aspx

Post #1348052
Posted Wednesday, August 22, 2012 11:45 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi Tajrin,

I accept you are using local network, i refer you to log in on SA accounts & your SQL Server Agent should run on Network and while configuring replication use SA account so you can test also.

Thanks & Regards
Satish
Post #1348863
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse