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 |
|
KlausHuyke
Starting Member
3 Posts |
 Posted - 2007-08-31 : 09:06:53
|
| Hi all,when starting a replikation I got the following error:The process could not read file '\\DEFMSVSQ001\d$\database\MSSQL\ReplData\unc\DEFMSVSQ001_rmsummarydatabase_rmsummarydatabase\20070830141010\SDB_CLIENTHISTORY_1.sch' due to OS error 2.What is going wrong ?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-31 : 09:21:30
|
Found with Google searching for+"http://support.microsoft.com/default.aspx?scid=kb;EN-US;872585"
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-31 : 09:27:04
|
It seems the share is not properly set with permission and other things.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
KlausHuyke
Starting Member
3 Posts |
Posted - 2007-08-31 : 09:34:18
|
| The Article is not available at microsoft.comThe Replikation is done with the sa account |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-31 : 09:36:41
|
On computer DEFMSVSQ001, do the directoryd:\database\MSSQL\ReplData\unc\DEFMSVSQ001_rmsummarydatabase_rmsummarydatabase\20070830141010\ exist?It it does, what read permissions is set?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
KlausHuyke
Starting Member
3 Posts |
Posted - 2007-08-31 : 09:50:07
|
| For test purposes I set Permisson Full ControlAslo I can open the Folder from the subscription server. I can also open the mentioned file. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-31 : 10:00:06
|
And from the publisher?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 16:21:34
|
| Does sql service account have permission to access that location? |
|
|
|
|
|
|
The process could not read file due to OS error 2.