Login failed for user 'sa'

• jeca73

  SSC-Addicted

  Points: 428

  More actions

  March 25, 2002 at 3:36 am

  #78494

  I setted up transactional replication between two Sql servers 2000, but when I try to insert data into subscriber , message appears 'Login failed for user 'sa'....

  Where is the problem?

  Thanks a lot,

  Jelena

• ramakrishna100

  SSC Veteran

  Points: 216

  More actions

  March 25, 2002 at 4:05 am

  #426002

  Hi Jelena

  To rectify this problem follow these steps.

  1) In publisher select the database

  2) Select Tools --> Replication --> Configure, Publisher, Subscriber and Distributor

  3) In the wizard click on Subscribers tab

  4) In the subscribers list, click on the small button in the list.

  5) Set the correct connection information

  6) click on "OK" to save the changes.

  Now synchronize the databases.

  All the best.

  Thanks

  Regards

  Ram

  ram@cntit.com