sql server replication: replication on remote hosted sql server -- sql server replication

replication on remote hosted sql server

Nick Stansbury
9/19/2003 8:01:50 PM

sql server replication:

Hi,
Is it possible to set up a subsciber to a remotely hosted database where
you don't and can't ever have sa permissions on the remote server? Our
webhosting company tell us it can't be done. Are they right? Setup is a
local sql 2000 box and a remote sql 7 box.

Thanks

Nick

replication on remote hosted sql server

Hilary Cotter
9/22/2003 6:09:06 AM

It sounds like your web hosting company is not been very
cooperative.

You need to have at least dbo rights on the subscriber for
this to work. You will most likely have to manually push
the data over as they will probably deny you rights to
access your snapshot via unc or ftp.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.