OS Error 5: Access is Denied

  • Hi, I use an Sql2000 server on NT as distributor & publisher, use another MSDE on Windows 2000 as pull subscriber. However I receive the below error when I try to start the distributor agent:

    The process could not read file '\\DATA-SERVER\D\Program Files\Microsoft SQL

    Server\MSSQL\ReplData\unc\...\*.sch' due to OS error 5.

    Any idea about this? Please help, thanks.

  • I seems that the distributor can't read the snapshot file. You should check that in that path you have all the snapshots files needed to start the syncronization. If the path is right, then also check for permissions in the folders. The windows account that start de SQL Agent, should also have read permissions in that folder.

    If everything is right, then you could try adding the -AltSnapshotFolder option, to the distribution agent specifying another folder for the snapshot.

    Both windows account that start the agent services in the server, should be domain accounts.

  • Hi

    I have a similar problem, but when I checked, the permissions were set to Everyone with full control, so there shouldn't be an access problem should there?

    Any ideas?

Viewing 3 posts - 1 through 2 (of 2 total)

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