May 29, 2003 at 2:24 am
hi expert,
I'm implementing a replication
1) Replication Type
- Transactional publication
* WITH setting
Immediate Update
Test case
PC1 is Publisher and Distributor
PC2 is subscriber
When insert new record into PC1,then PC2
can see the new record. This is fine
PROBLEM::
When insert new record into PC2, then
a error displayed "Cannot execure stored procedure" then the stored procudure name.
i think PC2 having permission to access PC1
i have already set the permission on the subscriber to access the Publisher by using this command,
sp_link_publication
please guide, thanks in advance
May 29, 2003 at 6:00 am
It does sound like a permission issue. Does the subscriber login you're using have execute rights on that proc? Try temporarily adding the login to db_owner, see if problem goes away.
Andy
June 1, 2003 at 1:03 pm
Thanks for your reply.
Forget to mention, PC2 is a desktop engine (MSDE), base on the MS documentation, MSDE is not support transactional as Publisher only, i don't think is this issue as well.
But i try to install a PC3 with personal edition, then make it as a subscriber for the same table as PC2 and insert a new record, this is working fine.
Anyway, i should use the MSDE instead of personal edition resulting from costing
Is MSDE really not supported or something is wrong. I used a dbo(from PC2) to login to PC1 but the result is the same
Please guide
June 1, 2003 at 6:56 pm
Cant do immediate from MSDE. See this link, look for the paragraph on replication:
http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp
Andy
June 1, 2003 at 7:04 pm
Cant do immediate from MSDE. See this link, look for the paragraph on replication:
http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp
Andy
June 5, 2003 at 5:42 am
Thanks to Andy Warran.
base on that paragraph, if i'm using
MSDE 2000, then only can make the PC2 as a standard subscriber for Transactional publication, which means that cannot set the replication as Immediate Updating and Queued Updating anymore. Am i right ?
Anyway, please guide again, i will have 16 (or more then that) MSDE where all of them must have the up to date data (not really in real time, but should update as fast as possible), if using merge replication (what option can be used ??), will it be caused the performance issue. (One MSDE might have more than 10000 record per day)
Thank
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply