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 |
|
SQLTEAMSteve
Starting Member
8 Posts |
 Posted - 2005-08-18 : 10:59:48
|
| Good Morning.Trying to see if anyone has had an failures using Transactional or Snapshot replication on an Sp3/SP3a box publishing TO an Sp4 box.We've implemented SQL Server Reporting Services @ SP2, and to make SP2 work, the datasource box in the farm must be running SQL2K SP4.I'm having one heck of a time getting a simple snapshot initialized, sync_obj* tables keep failing on the bulk load side, and just trying to kick off the distributor I've gotten "ACCESS DENIED".To work around this, I have been making local snapshot versions, backing up and restoring on the destination subscriber box, THEN kicking off Transactional replication.This is just in our QA system to test and get sign off that they (the client here) does NOT need to upgrade all boxes. This all started due to the AWE issue that they didn't realize there was a fix for._________________________Stephen R Montgomery |
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-08-18 : 13:40:04
|
| Hi,Is this possibly access denied to the ReplData share on the Publisher/Distributor? Have domain, NT privileges, or service account security contexts changed? The account that SQL Agent uses as its security context needs to have read privileges to the ReplData share on the D/P.Best I can offer you.Good luck. |
 |
|
|
|
|
|
Replication Woes - SP3/SP3a to SP4