February 2, 2010 at 7:42 am
I have a server running SQL2k5 that I've configured as a publisher & distributor. I have A SQL2k8 server in another domain configured as a subscriber (pull).
In the subscriber properties I've indicated the remote domain\user ID for the Agent Process Account - this account is on the domain, has been added to SQL Login with dbo on the database to publish. The Distributor connection is using SQL Authentication - this SQL account has been given dbo on the database to publish, too.
On the SQL2k5 server I've shared the Data\ReplData folder where the snapshot is written & grated Read access to the Agent Process Account specified in the subscription properties.
On the SQL2k5 server I'm getting an error: 'The process could not read the default location file name due to OS error 21. (Source MSSQL_Repl, Error number MSSQL_REPL20024).
Since the file exists & I've provided access to the folder to the agent account, then the only thing that makes sense to me is that I need to specify a different agent in the subscription - a SQL account. Is that correct? How would I do that, and what account on the distributor would I grant read access to in the ReplData folder?
Thanks,
BigSam
February 2, 2010 at 8:36 am
BigSam, I remember reading somewhere that the Distributor should be same or higher version than the Publisher or the subscriber. I am not sure if that is your issue.
-Roy
February 3, 2010 at 6:35 am
I changed the subscription from a pull to a push & all is well.
The version of the distributor isn't a factor in this case.
However, when replicating between SQL2k5 & SQL2k8, you need to add the subscriber via the SSMS on the SQL2k8 system.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply