Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2003-02-09 : 11:24:04
|
| I have setup a Snapshot replication...that was working before. Now, the subscription is producing an error:The process could not read file'\\Server\Repl\unc\Server_db_Repl\20030209040006\CreateTempUserTable_1.sch' due to OS error 5. The step failed.I have read through the sql docs and online, but I cannot find anything that explains this error message. thanks for any help. |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2003-02-10 : 10:25:37
|
| I'll reply to myself...but I think that this may be a bug with SP3. Prior to installing SP3 on our SQL2000 server and the local MSDE installs we could replicate the data between sql and msde. Now we cannot. In fact, last night, I completely disabled and removed replication and started it over again. I even tried some fairly simple snapshot replications and they did not work. I should be clear...the Sql200 server creates the snapshot files, however the subscription fails with the error I reported in my first message.dw |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2003-02-10 : 17:49:33
|
| Again....me....It appears that there might have been some hole in security that SP3 fixed. This was allowing my replication process - an anonymous pull subscription - access to a share/file that should not have been allowed. At least this is the direction that someone at MS is going with me. That could be right...I will need to figure out a way to test this out and make sure that my dist. agent has permissions for the share where the replication files are located. Hopefully I'll know in a day or so. |
|
|
|
|
|
|
Replication Error -