Replication between two servers without db_owner

Hello there
I have destination database which i'm not db_owner on it but guest
The user i'm using to access between two servers is:
1. Source is connected by linked server to destination
2. on the destination none of the servers roles are active for the user i'm
trying to access
3. the user has only access to one of my databases whith permittion of:
db_public, db_ddladmin
, db_datareader, db_datawriter
What else i need to use replication between two sides?
You'll need rights to create tables. There are two system tables which are
necessary and you should be able to precreate these using an account in the
ddl_admin role.
This is a push subscription right? What version of SQL Server is running on
the publisher and subscriber?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uu6vAScGGHA.3864@.tk2msftngp13.phx.gbl...
> Hello there
> I have destination database which i'm not db_owner on it but guest
> The user i'm using to access between two servers is:
> 1. Source is connected by linked server to destination
> 2. on the destination none of the servers roles are active for the user
> i'm trying to access
> 3. the user has only access to one of my databases whith permittion of:
> db_public, db_ddladmin
> , db_datareader, db_datawriter
> What else i need to use replication between two sides?
>
|||Thankes Hilary.
Now the replication succedded on the other side. In fact it gave me db_owner
to do that.
The problem now is that it create new tables what replicated with the
username owner that i used to access the subscriber, instead of entering the
data to my existing databses with dbo owners.
How can i cause the subscriber to transfare data to the original tables with
dbo owners?
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e$6nsyfGGHA.1180@.TK2MSFTNGP09.phx.gbl...
> You'll need rights to create tables. There are two system tables which are
> necessary and you should be able to precreate these using an account in
> the ddl_admin role.
> This is a push subscription right? What version of SQL Server is running
> on the publisher and subscriber?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:uu6vAScGGHA.3864@.tk2msftngp13.phx.gbl...
>
|||Right click on your publication and select properties, click on the articles
tab, and select the browse button to the right of each table, in the general
tab, specify destination table owner name to be dbo.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23xLlJkCHGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Thankes Hilary.
> Now the replication succedded on the other side. In fact it gave me
> db_owner to do that.
> The problem now is that it create new tables what replicated with the
> username owner that i used to access the subscriber, instead of entering
> the data to my existing databses with dbo owners.
> How can i cause the subscriber to transfare data to the original tables
> with dbo owners?
> --
>
> ' 03-5611606
> ' 050-7709399
> : roy@.atidsm.co.il
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:e$6nsyfGGHA.1180@.TK2MSFTNGP09.phx.gbl...
>
|||Thankes A lot hilary
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u6j6N8EHGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Right click on your publication and select properties, click on the
> articles tab, and select the browse button to the right of each table, in
> the general tab, specify destination table owner name to be dbo.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23xLlJkCHGHA.1032@.TK2MSFTNGP11.phx.gbl...
>

Replication --> Error 21122: Cannot drop destination database...

Good day!

I am getting a bizard error here...

I am trying to drop replication off a database, and funny enough went trough all the steps and I am still getting the error when I try to Disable publishing.

I also did an EXEC sp_removedbreplication 'databasename'

Any ideas?Was able to find the error...

It's all about who initially created the replication or a rights issue. In this case the owner (of the replication) needs to be the one deleting it.

Replication

I need to copy 10 Databases (150GB) to another SQL machine.
Now I need the destination machine to be updated every 24 hours.
Transcational replication is not helping me - cause it doesn't copy tables
without primary keys.
Snapshot replication is not helping me either - cause i can't transfer every
24 hours 150GB.
Help me please,
Aviad Avi.
You can use merge and configure it to only move the data one way. Add the
ExchangeType parameter to the merge agent with a value of 2.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||It seems you on something.
Can you please explain what do you meen by adding the ExchangeType parameter
with a value of 2?
Where should i configure the Merge?
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:QQXX4wl1EHA.768@.cpmsftngxa10.phx.gbl...
> You can use merge and configure it to only move the data one way. Add the
> ExchangeType parameter to the merge agent with a value of 2.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||Why does it called merge? because the uniqueidentifier colum that is added?
"Aviad Avi" <aviad00001@.yahoo.ca> wrote in message
news:%23RWGK1l1EHA.304@.TK2MSFTNGP11.phx.gbl...
> It seems you on something.
> Can you please explain what do you meen by adding the ExchangeType
parameter[vbcol=seagreen]
> with a value of 2?
> Where should i configure the Merge?
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:QQXX4wl1EHA.768@.cpmsftngxa10.phx.gbl...
the[vbcol=seagreen]
rights.
>
|||Moreover,
I think I need to run it with 1 value = push
don't I?
"Aviad Avi" <aviad00001@.yahoo.ca> wrote in message
news:%23RWGK1l1EHA.304@.TK2MSFTNGP11.phx.gbl...
> It seems you on something.
> Can you please explain what do you meen by adding the ExchangeType
parameter[vbcol=seagreen]
> with a value of 2?
> Where should i configure the Merge?
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:QQXX4wl1EHA.768@.cpmsftngxa10.phx.gbl...
the[vbcol=seagreen]
rights.
>
|||In the merge agent job, on the middle step, add -
ExchangeType 2 to the parameters list. This is one of
those cases where the parameter needs adding here rather
than to the profile. The values according to BOL are :
UPLOAD 1 Only merge Subscriber changes with the
Publisher.
DOWNLOAD 2 Only merge Publisher changes with the
Subscriber.
BIDIRECTIONAL 3 Merge all changes between the Publisher
and Subscriber (default).
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Snapshot and Transactional in their plain forms are
essentially unidirectional. Merge is bidirectional, and
the subscriber can change data offline, so there is the
potential that data can conflict. However, in certain
configurations a change to a different column on the same
row is not treated as a conflict and the changes
are 'merged'.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)