|
Home > Archive > MS SQL Server Replication > May 2005 > Merge replication does not apply schema
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Merge replication does not apply schema
|
|
| scotch 2005-05-27, 7:23 am |
| Hi there,
The situation is as follows:
We have a central server running MS SQL 2000 SP3 on Win2k3 SP1 and bunch
of clients running MSDE SP3 (planning to update to SP4) on WinXP/Win2kpro.
To synchronize data between server and clients we use merge replication
with pull subscription. The initial snapshot is delivered via ftp (a
huge security risk but UNC does not work over Internet, do they? ;) ).
Now in theory the snapshot should create database structure on
subscriber (I mean tables and relationships between them). So why this
doesn’t happen? I get this error:
Table 'NAMAS' does not exist in the Subscriber database.
(Source: GOBLIN\MSPROJECT (Data source); Error number: 21078)
---------------------------------------------------------------------------------------------------------------
'. Check sysobjects.
(Source: GOBLIN\MSPROJECT (Data source); Error number: 2501)
---------------------------------------------------------------------------------------------------------------
The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
---------------------------------------------------------------------------------------------------------------
If create the database in subscriber manually from a script, the
initialization succeeds but all relationships are mysteriously gone!
So why is this happening? Any ideas?
| |
| Christian Donner 2005-05-27, 7:23 am |
| 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 ...
| |
| scotch 2005-05-30, 3:23 am |
| 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?
|
|
|
|
|