Wednesday, March 21, 2012

merge replication problem

I am working on merge replication.I am using sql server 2005 standard edition.Will things workout for me if i use this standard edition(just to know).

2. i have been working on merge replication on the same server but different databases.the way i do it is as follows

a.I create a database.

b.Create a publication(is has successfully been created)

c.Create a subscription(successfully created it)

d.Now when i look at the replication monitor when i click on my merge replication

under all subscription tab

status shows:uninitialized subscription and

Connection :it shows unknown

when i double click that it takes me to synchrinization history which has nothing going on with in it.

What would be the reason for the problem.

Please

Can you try the replication monitor and the sync history after you add some articles to the publication then run the snapshot agent on the publisher, and then run the merge agent to initialize the subscriber.|||

Thanks for your attention

after adding some articles.when i run the snapshot agent from

Local publications->my publication->view snap shot agent status->click start

it tries to start but then comes with a message saying "The agent has never been run."

and under local subscritpions->my subscription->view synchronization->

when i click start it says "No agent status information is available".

when i look at view history tab

The job failed. Unable to determine if the owner (xyz\myname) of job 1234511-testdb_merge-merge-27G6Y91-merge_sub- 0 has server access (reason: Could not obtain information about Windows NT group/user 'xyz\myname', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).

What would be the casue if security permission.How should i set them.

please let me know.


sql

No comments:

Post a Comment