Replication and logins - HELP PLEASE
- From: "Giorgio" <george_Martinho@xxxxxxxxxxx>
- Date: 21 Aug 2006 02:48:12 -0700
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
.
- Follow-Ups:
- Re: Replication and logins - HELP PLEASE
- From: Hilary Cotter
- Re: Replication and logins - HELP PLEASE
- Prev by Date: Re: Is there a way to configure the replication agent to transfer the snapshot using PASV?
- Next by Date: Re: FTP and Replication Between Separate WANs
- Previous by thread: Is there a way to configure the replication agent to transfer the snapshot using PASV?
- Next by thread: Re: Replication and logins - HELP PLEASE
- Index(es):
Relevant Pages
|
