Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Replication OS error 5


Replication OS error 5

Author
Message
tajrin
tajrin
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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
S. Kusen
S. Kusen
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1094 Visits: 1109
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
tajrin
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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
ShibuShaji
ShibuShaji
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 28
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
saidapurs
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search