Re: Replication and logins - HELP PLEASE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

According to BOL "Only members of the sysadmin fixed server role or db_owner
fixed database role can execute sp_addpublication."

This implies that the minimum set of permissions should merely be dbo
permissions in the selected databases you wish to replicate.

Your error message seems to indicate that the user will require more rights,
can you give us the complete error message and number?
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Giorgio" <george_Martinho@xxxxxxxxxxx> wrote in message
news:1156153692.579868.157330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a database on a SQL Server 2000 that needs to be setup as merge
replication to another SQL Server 2000 but the other server is from a
customer so we setup a VPN between our networks and I can login and
make queries on their server and they can also do the same on our
server so the VPN setup is ok.

The problem is that they are responsible for setting up and maintaining
the replication ;-), but I have more than one database on our server
which I am not happy at all to give them access to.

I did setup a login for the database to be replicated BUT I am getting
an error that says that the user has no rights to the extended sp
replica.... on master database. So I would have to give my customer
admin rights which means he has full access to all databases on our
server!

So my question is, how can I create a user for a database to allow my
customer to login to my SQL server and setup the replication BUT also
he cannot access any other databases?

I would really appreciate some urgent help on this.

Thanks a lot in advance



.

Relevant Pages

  • Re: Publishers disappeared from under replication monitor
    ... Basically the only database on the server being replicated suddenly had 'no' ... This seemed like some kind of corruption in the database. ... The next day we set up transactional replication again (Yes, ... > distribution agent name you can get a condition like this. ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Subscriber Transaction Logs Too Large
    ... mentioned not shrinking the file too much on SQL 2000. ... SQL 2005 (Server B). ... alter database databaseName ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)