How to create replication

• abhi777_aiwa

  Old Hand

  Points: 358

  More actions

  January 8, 2009 at 5:25 pm

  #217325

  Hi friends,

  Please help me out with how to create replication, I want to create distributor as well as publisher.

  I tried through Microsofts SQL 2005 management studio. but getting

  following error.

  Please help me out with this issue. Please direct me to any tutorial or good blog.

  Property LoginSecure cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Management.Common.ConnectionSettings.ThrowIfConnectionStringIsSet(String propertyName)

  at Microsoft.SqlServer.Management.Common.ConnectionSettings.get_LoginSecure()

  at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.InstallDistributor(WizardInputs inputs, Boolean bScripting)

  at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.InstallDistributor(IProgress progress, Boolean bScripting, ApplicationException& outerEx, StringBuilder command)

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 8, 2009 at 7:45 pm

  #923861

  Have you read http://sqlserver-qa.net/blogs/replication/archive/2007/08/24/1713.aspx

  ---

  
  Shamless self promotion - read my blog http://sirsql.net