Post reply

Sql 6.5 Replication across domains

  • March 19, 2002 at 4:30 am

    #78176

    We have a site (A) publishing a databse and two sites (B) and (C) subscribing to it. all sites are in different domains. when we setup replication and do an automatic Sync, site B sync's and the owner of the tables on site B is DBO, but when site C sync's the owner of the tables is Repl_Publisher. what is causinfg this???

    Edited by - miketomkies on 03/19/2002 06:24:00 AM

  • March 19, 2002 at 6:29 am

    #425628

    I have found the problem and solved it. the solution was:- the repl_publisher login was not an alias of DBO. once i dropped all the tables and made the login an alias of DBO it created the tables with the owner DBO. Don't know how or who changed it.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply