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.
No comments:
Post a Comment