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-11 : 12:32:58
|
| I thought I had this one figured out...but now I don't know where to look. We have snapshot and transactional replication publications setup on a Sql2000 server(sp3) that is both the publisher and the distributor. The clients are running msde (also upgraded to sp3) and after connecting to the Sql2000 server and initializing the replication job, there is always a failure error like:The process could not read file '\\myServer\Repl\unc\myServer_myDB_myDP_Repl\20030209040006\CreateTempUserTable_1.sch' due to OS error 5. The step failed.The sql agent is set to run under a windows domain account that does have access/permissions to the above share: \\myServer\Repl . I even logged on to that machine using the windows account and was able to access, copy, delete, etc. files from that share and below.So...I cannot figure out why the replication process cannot access this share or files.Thanks for any help or advice. |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2003-02-12 : 10:57:57
|
| Apparently....at least according to a message I just read on the MS Sql newsgroup, there is a problem with replication since SP3. I read several threads about this....and one person stated that they called MS support and was given a hotfix to remedy their replication problems. He said that the MS is suppose to make the hotfix available later this week. Hopefully, this will solve my issue too. |
 |
|
|
|
|
|
Replication agent cannot access files...