SQL Server Performance


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?
  2. prabhabk New Member

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

    MS SQL Server DBA
  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.

    MS SQL Server DBA
  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..


    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page