Transactionla Replication

• OnlyOneRJ

  Hall of Fame

  Points: 3894

  More actions

  February 18, 2013 at 3:07 am

  #270241

  Very first step while configuring the Ditribution.. error comes on last step :w00t:

  Property LoginSecure cannot be changed or read after a connection string

  has been set(Microsoft SqlServer.Connection Info)

  ************************************
  Every Dog has a Tail !!!!! :-D

• Ramesh @ SQLCentral

  SSC Veteran

  Points: 246

  More actions

  March 7, 2013 at 11:47 am

  #1594623

  [font="Tahoma"]Incase you are using local dstribution, please try the below steps,

  1. Right click local publicaiton->Distributor properties

  2. Select the publisher in the list, click ...

  3. In agent connection mode, select "impoersonate the agent process account"[/font]