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
CE

I’ve moved to relevant forum.
Luis Martin
Moderator
SQL-Server-Performance.com 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.

]]>