Replication OS error 5

Question

Replication OS error 5

tajrin

Old Hand

Points: 383
More actions
November 30, 2010 at 2:19 am

#229191

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

Viewing 5 posts - 1 through 4 (of 4 total)

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

S. Kusen SSChampion Points: 10936 More actions · Answer 1

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

tajrin Old Hand Points: 383 More actions · Answer 2

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

ShibuShaji SSC Enthusiast Points: 133 More actions · Answer 3

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

saidapurs Hall of Fame Points: 3477 More actions · Answer 4

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