SQL Server Performance

replication

Discussion in 'Performance Tuning for SQL Server Replication' started by kidlat, May 27, 2007.

  1. kidlat New Member

    hi guys, im new to replication i start to configure the publication,distribution under replication. there was an error "sql server agent uses system account which causes replication to fail." as a distributor. what i am trying to setup is from my laptop to my desktop. il create a publication from my desktop and distribute to my laptop. is there any things that i should prepare first?
    kidlat, May 27, 2007
    #2

  2. prabhabk New Member

    You should use Service Account to configure Replication,Logshipping...

    Thanks,
    Prabhakaran
    MS SQL Server DBA
    prabhabk, May 28, 2007
    #2

  3. prabhabk New Member

    You have to create a Windows Service account with Admin rights in domain after that Configure that Service account to use to run sqlserver,sqlserver agent services.

    Thanks,
    Prabhakaran
    MS SQL Server DBA
    prabhabk, May 28, 2007
    #2

  4. MohammedU New Member

    First of all post the exact error message what you are getting..

    I don't think you need to have domain account....
    you can create sql login with dbo rights on subscriber and configure the subscriber to use the sql log created with dbo rights..





    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
    MohammedU, May 28, 2007
    #2

Share This Page