Does Replication work on XP

• Michael Pinnock

  SSC Rookie

  Points: 45

  More actions

  November 3, 2006 at 2:14 pm

  #91889

  Hello,

  I am trying to setup transactional replication on MS SQL Server 2000 and have ran into a few problems. One, I can create the publisher and subscription, however, when I try to pull or push the subscription I am unable to connect to the server - I get error "connection fail - not associated with a trusted sql server".

  I have tried a number of settings without luck. Is this due to XP or is there another setting that I am missing?

  Thanks

  Michael

• Derek Giovanni

  Valued Member

  Points: 52

  More actions

  November 3, 2006 at 2:59 pm

  #669923

  Hello,

  Did you set the authentication settings on SQL Server Properties / Security to "SQL Server and Windows"?

  Here is a Microsoft support document that may help you:

  http://support.microsoft.com/kb/889615

• Michael Pinnock

  SSC Rookie

  Points: 45

  More actions

  November 3, 2006 at 3:09 pm

  #669927

  Thanks so much for your help - this was very helpful.

  Michael