sql server replication: Merge agent start failure -- sql server replication

Re: Merge agent start failure

Hilary Cotter
1/6/2005 2:24:44 PM

sql server replication:

can you check the SQL error log for any information?

I have encountered intermittent memory problems of the form - could not
reserve contiguous memory blocks around the time I experienced these errors.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]

Merge agent start failure

rr
1/6/2005 6:04:29 PM

Hello All -

I have a problem with push merge subscription. The publisher/distributer
reside on same host with several clients connecting for merge replication.

The startup of one of the merge agents fails. The error message "Login
failed for user 'dbApp'. Reason: not associated with a trusted SQL server
connection. Error 18452".

I am able to connect to the client via QueryAnalyer using the 'dbApp' login.
I've done A/B checking with the security info for the bad client with a good
client and can not see any diffs.

I don't know what has happened. This client machine did work several weeks
ago. I suspect maybe some software installation munged the settings
somewhere but am at a loss as to where to check for this.

Any clues?

Thanks,
bruce