December 8, 2006 at 2:47 am
Hi All,
Trying to replicate databases between SQL2K (Publisher) on a Windows 32bit server and
SQL 2005 (Subscriber) on a Windows 64bit server. Both servers are running Windows 2003.
The distributor runs at the publisher and I’m using a snapshot pull subscription at the subscriber
The servers are both in separate domains and have a tried and tested two way trust relationship.
This is the error I’m getting…
2006-12-08 09:06:12.141 The process could not read file '\\VIENNA\D$\MSSQL\distribution\ReplData\unc\VIENNA_IMP_KLI_IMP_KLI\20061207180011\M_APBAL_1.sch'
due to OS error 5.
The data is shared at the \ReplData\ level and ‘Everyone’ in the Publishers domain has access, in addition
the accounts used to run the SQL server agents on both machines have full permissions on the share. I also
changed the security on the \ReplData\ directory to be the same and sub folders have inherited these
permissions.
Should I be sharing this directory at the \unc\ level?
Bit stuck as to what I should try next. Anyone got any ideas?
Thanks in advance
Dave
December 8, 2006 at 2:13 pm
If I am not mistaken OS Error 5 is access denied error. Make sure you have sufficient permission to read the files.
Best test will be run EXEC MASTER..XP_CMDSHELL 'DIR \VIENNA\D$\MSSQL\distribution\ReplData\unc\VIENNA_IMP_KLI_IMP_KLI\20061207180011\'
Is SQL agent service account is domain account? does it has access to this folder?
MohammedU
Microsoft SQL Server MVP
December 11, 2006 at 10:19 am
Hi,
Put both servers in the same domain which fixed the problem.
Thanks
Dave
December 11, 2006 at 12:32 pm
So it was security issue.. not the sql issue...
MohammedU
Microsoft SQL Server MVP
December 12, 2006 at 5:19 am
Yep seems like it. Both servers are going to move domain anyway but they will have to move at the same time.
Cheers
Dave
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply