does it work if you use a pull subscription?
-Mike
>Hi,
>This is the error that I receive when I try to set up Transactional Replication between Server3 and Server2
>
>Sql Server Enterprise Manager encountered errors creating push subscription for the following Subscribers:
>
>Server2: Error 21281: Publication 'DBOrders_Main_Transactional' cannot be
>subscribed to by Subscriber database 'DBOrders' because it contains one or more articles that have been subscribed to by the same Subscriber database at merge level.
>
>
>I do not understand this error because I have deleted all perviously created Publications on both servers.
>
>Has anyone here encountered this error?
>
>P.S: I tried to push this publication to another server that I have setup and I receive no errors. It seems to only occur between Server3 and Server2.
>
>Thanks for you help.
>
>Alvin