anonymous subscription | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

anonymous subscription

I am trying to set up another replication of the same database to another network (serverB). The first replication works fine – I used a push subscription and allow anonymous subscriptions.
The publisher database is set up to run and start the server with a specified login – ‘LoginA’
However, with this new replication I get the error message ‘Could not connect to serverB – login failed for LoginA’. If I include this login in ServerB then the replication works ok but the table is created with LoginA as the owner (whereas I want dbo as owner). It is strange because I don’t get these problems with the replication I did last time and I have matched all the properties the same so it should work the same. Is there anything that I should look for in the properties of ServerB that could be causing this difference? Thanks
I’ve moved to relevant forum.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.