sanpshot replication with immediating update 
Author Message
 sanpshot replication with immediating update
Hi All,

I am using the sanpshot replication mode with checking out immediating
update option, but I always run into an error "can't connec to subscriber".
I can use SQL MMC to register and connect this subscribers. How to set up
this replication mode with immediating update?

thanks,
Jordan



Thu, 04 Jul 2002 03:00:00 GMT
 sanpshot replication with immediating update

There is no snapshot with immediate updating subscribers.  I'm assuming you
mean transactional with immediate updating subscribers.  You may be able to
connect from the MMC because it is using your account credentials to access
each server.  When replication runs, it uses the account credentials and
authority that you have the SQL Server Agent running under.  If this account
does not have the authroity to access the subscriber, then it won't connect.

--

Mike
New product reviews: http://www.mssqlserver.com/products
Book reviews: http://www.mssqlserver.com/books
Replication Primer: http://www.mssqlserver.com/replication
Disaster recovery plans: http://www.mssqlserver.com/backup
SYSOP PASS Discussion Forums: http://www.sqlpass.org
Please post all replies to the newsgroup unless stated otherwise.



Fri, 05 Jul 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Replicating (sanpshot replication) Referenced tables

2. testing last sanpshot in QNX platform

3. table sanpshot

4. sanpshot output

5. sanpshot too old

6. testing last sanpshot in QNX platform

7. after replication timeout: update with identical values no replication

8. Updating primary key with Cascade Update fails Replication

9. Transactional replication - Queued updating - Cannot update more than one row at the subscriber

10. Update Trigger not firing after Transactional replication of an Update

11. 2-way replication Update Anywhere, Update trigger

12. SQL server 2000/Multiple publishers/single subscriber/transactional replication cannot update existing row


 
Powered by phpBB® Forum Software