I have the most perplexing issue with merge replication. This is a
configuration that has worked well on several other systems, both XP Pro and
Windows Server. This installation is on an XP Pro box that is set up as
close to identical to the development machine as possible.
I'm getting the error, 80045003 "Initialializing SQL Server Reconciler has
filed."
When I look under the Misc. Agents, I have the message, "The job failed.
Unable to determine if the owner of job replication agents checkup has
server access (reason: could not obtain information about Windows NT
group\user [doman\username] SQL State 42000 error 8198).
I've added the domain user as dbo and given access to the master database.
I've added the distributor_admin as user to the database that I'm
replicating.
Any advice on where to look next would be appreciated.
Earl,
try changing all replication job owners to sa and see if that helps.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Showing posts with label face. Show all posts
Showing posts with label face. Show all posts
Monday, March 26, 2012
Friday, March 9, 2012
Merge Replication Fail
Hello
I am face the following problem.
Invalid object name 'sysmergearticles'.
The merge replication is falling please help me.
Best regards,
FDB
Is this failure when setting up replication or did it cause the merge agent
to fail suddenly?
Sysmergearticles is an important system table, Did you apply any service
packs patches before you saw this error?
thanks
gopal
|||This failure happen when i setting up replication.
I have SQL Server 2000 Personal Edition SP3.
My server is a subscriber.
"Gopal Ashok [MS]" <gopal@.online.microsoft.net> wrote in message
news:XJjN7gMIEHA.3568@.cpmsftngxa06.phx.gbl...
> Is this failure when setting up replication or did it cause the merge
agent
> to fail suddenly?
> Sysmergearticles is an important system table, Did you apply any service
> packs patches before you saw this error?
> thanks
> gopal
>
I am face the following problem.
Invalid object name 'sysmergearticles'.
The merge replication is falling please help me.
Best regards,
FDB
Is this failure when setting up replication or did it cause the merge agent
to fail suddenly?
Sysmergearticles is an important system table, Did you apply any service
packs patches before you saw this error?
thanks
gopal
|||This failure happen when i setting up replication.
I have SQL Server 2000 Personal Edition SP3.
My server is a subscriber.
"Gopal Ashok [MS]" <gopal@.online.microsoft.net> wrote in message
news:XJjN7gMIEHA.3568@.cpmsftngxa06.phx.gbl...
> Is this failure when setting up replication or did it cause the merge
agent
> to fail suddenly?
> Sysmergearticles is an important system table, Did you apply any service
> packs patches before you saw this error?
> thanks
> gopal
>
Merge replication fail
Hello
I am face the following problem.
Invalid object name 'sysmergearticles'.
The merge replication is falling please help me.
Best regards,
FDB
Are you getting this while deploying your snapshot?
If so go to your publishing database, expand your table collection, right
click on the table sysmergearticles and select copy. go to your subscribing
database, open up isqlw and change to your database, select Edit, Paste,
execute it, and start your merge agent again
"news.microsoft.com" <fabiobarion@.hotmail.com> wrote in message
news:%23Jhjq6$GEHA.2052@.TK2MSFTNGP12.phx.gbl...
> Hello
> I am face the following problem.
> Invalid object name 'sysmergearticles'.
> The merge replication is falling please help me.
> Best regards,
> FDB
>
I am face the following problem.
Invalid object name 'sysmergearticles'.
The merge replication is falling please help me.
Best regards,
FDB
Are you getting this while deploying your snapshot?
If so go to your publishing database, expand your table collection, right
click on the table sysmergearticles and select copy. go to your subscribing
database, open up isqlw and change to your database, select Edit, Paste,
execute it, and start your merge agent again
"news.microsoft.com" <fabiobarion@.hotmail.com> wrote in message
news:%23Jhjq6$GEHA.2052@.TK2MSFTNGP12.phx.gbl...
> Hello
> I am face the following problem.
> Invalid object name 'sysmergearticles'.
> The merge replication is falling please help me.
> Best regards,
> FDB
>
Subscribe to:
Posts (Atom)