Results 1 to 2 of 2

Thread: Merge replication in SQL Server 2K - Resolved.

  1. Feb 19th, 2003, 04:56 AM #1
    axion_sa
    axion_sa is offline

    Thread Starter
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724

    Merge replication in SQL Server 2K - Resolved.

    I'm trying to set up replication (merge), and in the "Configure Publishers, Subscribers & Distributors" wizard I get the error:
    "SQL Server agent currently uses the system account which causes replication between servers to fail. In the following dialog box, specify another account for the service startup account".

    So, I create a new Windows user & try to use that as the startup account, and get this:
    Error 22042
    xp_SetSQLSecurity returned error -2147023564 "No mapping between account names and security IDs was done."


    What am I doing wrong?
    Last edited by axion_sa; Feb 19th, 2003 at 05:43 AM.
    Build solutions from Windows Explorer
    Reply With Quote Reply With Quote
  2. Feb 19th, 2003, 05:42 AM #2
    axion_sa
    axion_sa is offline

    Thread Starter
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724
    NM - got the answer
    Build solutions from Windows Explorer
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width