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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-16 : 22:21:26
|
Sam writes "I've built a SQL 2000 Merge Replication that runs fine on a single Windows 2000 server(SR-1). Now I want to run the same replication between two SQL 2000 servers, the second on a Windows 2000 Pro(SR-1). I deleted the subscription from the 1st server and added the same subscription to the 2nd server. (All of these tasks were accompolished via Enterprise manager and wizards.)
A message from a step in the Job History: "The schema script '\\Server1\D$\Microsoft SQL Server\MSSQL\ReplData\unc\Server1_Northwind_FieldSales\20010110102619\Suppliers_1.sch'could not be propagated to the subscriber."
The next step's message: "The process could not read file '\\Server1\D$\Microsoft SQL Server\MSSQL\ReplData\unc\Server1_Northwind_FieldSales\20010110102619\Suppliers_1.sch' due to OS error 5."
And next message: "Access is denied."
Using Explorer I can see the Suppliers_1.sch, open it in NotePad, change it and save it back.
I've added a group with my user ID to the permissions on the 1st server.
I've changes Server1 SQL Properties Security to 'Sql Server and Windows'. I've tried using the system account for the Publisher's SQL Server Authentication, as well as an account with 'Log on as a Service right'.
It is almost as though the sa account from my second server does not have the access to files that my user ID has. I'm stumped.
I'm new to SQl, but a new project mandates I upgrade from the Access technology due to size, security and reliablity.
I've been bagging my head againt the wall for over a week on this matter. I've even resorted to trying to learn the matter by using an example from a Microsoft publication. Still nothing. Any help would be greatly appreciated.
Thanks,
Sam" |
|
|
|
|
|
SQL 2000 Replication