Re: Merge replication does not apply schema

Christian Donner wrote:
Have you verified that the tables are not existing in the subscriber? This error can occur, when the publisher tables have a different owner than the subscriber tables. If in doubt make 'dbo' owner of all your tables (execute sp_changeobjectowner) and try again ...
I have checked the owner on both servers and they match (both are dbo). So are there other ideas?

Btw, I am running SQL server agent on different account then System witch is default. So perhaps I should grant all access to the particular database for this account?
.

Relevant Pages

  • Table record editing permissions
    ... The 'dbo' account means that 'sa' is the owner. ... without being granted permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: looking for more info on merge repl problem
    ... just change the owner on each table individually to user 'dbo' or should I ... >> Publisher or Subscriber, or non dbo owner names on both your Publihser ... >> Looking for a book on SQL Server replication? ...
    (microsoft.public.sqlserver.replication)
  • All tables are invalid objects
    ... tables still exist and find out who the owner is by ... dbo with the table owner if not dbo) ... My guess is that somehow the account your using to connect ... >Server Config, Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • changing table owner name- sp_changemergearticle
    ... I have a db with a few tables which has owner than dbo. ... subscriber. ... In order to avoid this i went to the article properties on the ...
    (microsoft.public.sqlserver.replication)
  • Re: Object Created under DBO to different owner name
    ... Yes it would be easier to have the owner dbo. ... My users want the owner to be thier login ... anything and have SQL Server use thier login account. ...
    (microsoft.public.sqlserver.security)