SQL Server Performance

2005 Cluster (New Install) Snapshot

Discussion in 'SQL Server 2005 Replication' started by rgiles, Jan 26, 2006.

  1. rgiles New Member

    I have created a new 2005 Cluster. I brought in my 2000 databases. I had replication working fine on my 2000 cluster. When I am creating a merge publication, I get the following error when the Snapshot Agent attempts to run: Unable to start the execution of step 2 (reason: Errorauthenticating proxy domainusername, system erro: Logon failure: unknown user name or bad password). The step failed. The account being used is the database owener account. Anyone help??

    Ron Giles
  2. satya Moderator

    Check the privileges for the cluster admin account on SQL server and also any service account used for SQL SErver services.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. sureshtp2sureshtp2 New Member

    Hi,

    This error usually occurs when the account passowrd is updated recently. Update the SQL service account passowrd and cycle the SQL services.

    Regards
    Suresh.

Share This Page