I have setup replication from one SQL 2000 server to
another. All I am replicating is one single small DB.
The replication of the data seems to work fine. however,
permissions (both on public and a special user) are not
replicated.
I have been unable to find how/where to specify
replication op permissions. Any help on this will be
greatly appreciated.
Joe
use the post snapshot command, or you can always replicate it to all of your
subscribers by using
sp_addscriptexec.
What this proc will do it so replicate to and execute the script on all
subscriber.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Joe Bunker" <admin@.yearone.com> wrote in message
news:9bad01c478c4$b04cc1c0$a501280a@.phx.gbl...
> I have setup replication from one SQL 2000 server to
> another. All I am replicating is one single small DB.
> The replication of the data seems to work fine. however,
> permissions (both on public and a special user) are not
> replicated.
> I have been unable to find how/where to specify
> replication op permissions. Any help on this will be
> greatly appreciated.
> Joe
|||Hi Hilary,
I've had inconsistent results with sp_addscriptexec - running on some
subscribers but not others (no anonymous) - particularly if a subscriber was
not connected at the time the command was run.
Have you experienced this at all?
Cheers,
Mary
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:O5bzLYMeEHA.596@.TK2MSFTNGP11.phx.gbl...
> use the post snapshot command, or you can always replicate it to all of
your
> subscribers by using
> sp_addscriptexec.
> What this proc will do it so replicate to and execute the script on all
> subscriber.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Joe Bunker" <admin@.yearone.com> wrote in message
> news:9bad01c478c4$b04cc1c0$a501280a@.phx.gbl...
>
|||Hilary,
Do you have any more information on the post snapshot
command? And/or a sample permissions script to use with
either sp_addscriptexec or @.post_snapshot_script?
Thank you.
>--Original Message--
>use the post snapshot command, or you can always
replicate it to all of your
>subscribers by using
>sp_addscriptexec.
>What this proc will do it so replicate to and execute the
script on all[vbcol=seagreen]
>subscriber.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Joe Bunker" <admin@.yearone.com> wrote in message
>news:9bad01c478c4$b04cc1c0$a501280a@.phx.gbl...
however,
>
>.
>
|||no, I have not. sp_addscriptexec is pooled in the distribution database and
it should be executed on ALL subscribers that are subscribed to the
publication.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mary Bray" <reply@.tonewsgroup.com.NOSPAMPLEASE> wrote in message
news:OYlm2MVeEHA.3412@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary,
> I've had inconsistent results with sp_addscriptexec - running on some
> subscribers but not others (no anonymous) - particularly if a subscriber
was
> not connected at the time the command was run.
> Have you experienced this at all?
> Cheers,
> Mary
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:O5bzLYMeEHA.596@.TK2MSFTNGP11.phx.gbl...
> your
>
|||for a permissions script connect to your database using EM. Right click on
the publication database, and select all tasks, generate SQL Script. In the
general tab, select the objects whose permissions you want to replicate, and
in the options tab, select Script Object Permissions.
Then generate the script, and edit it to remove all object creation/drop
statements until all that is left is the Grant and Deny commands.
Then save this script and this is the script you should propagate to all
subscribers.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Joe Bunker" <anonymous@.discussions.microsoft.com> wrote in message
news:b78001c4797c$c1fe9890$a401280a@.phx.gbl...[vbcol=seagreen]
> Hilary,
> Do you have any more information on the post snapshot
> command? And/or a sample permissions script to use with
> either sp_addscriptexec or @.post_snapshot_script?
> Thank you.
> replicate it to all of your
> script on all
> however,
sql
Showing posts with label replication. Show all posts
Showing posts with label replication. Show all posts
Friday, March 23, 2012
Friday, March 9, 2012
Permissions
They removed the share off of the drive where my snapshot replication step
(SS 2000 SP3a) writes to. That's all well and good because someone had
accidently shared out the whole drive. But now my snapshot step is failing
with "process could not create \\server\h\repl\unc".
Of course, we added a share to the repl folder and it failed with the same
error msg. Then we added in the share to the whole drive again and it still
failed.
So I am wondering if some permissions got clobbered or changed. So here are
my q's:
1. What permissions does snapshot replication run under? Does it just run
under the main sql server service account?
2. Can we just share out the subfolder, i.e. either the repl or the unc
subfolder?
3. Is there anything else we should be troubleshooting?
Any help would be much appreciated...Nevermind - I got it to work.
"CLM" wrote:
> They removed the share off of the drive where my snapshot replication step
> (SS 2000 SP3a) writes to. That's all well and good because someone had
> accidently shared out the whole drive. But now my snapshot step is failin
g
> with "process could not create \\server\h\repl\unc".
> Of course, we added a share to the repl folder and it failed with the same
> error msg. Then we added in the share to the whole drive again and it sti
ll
> failed.
> So I am wondering if some permissions got clobbered or changed. So here a
re
> my q's:
> 1. What permissions does snapshot replication run under? Does it just ru
n
> under the main sql server service account?
> 2. Can we just share out the subfolder, i.e. either the repl or the unc
> subfolder?
> 3. Is there anything else we should be troubleshooting?
> Any help would be much appreciated...
(SS 2000 SP3a) writes to. That's all well and good because someone had
accidently shared out the whole drive. But now my snapshot step is failing
with "process could not create \\server\h\repl\unc".
Of course, we added a share to the repl folder and it failed with the same
error msg. Then we added in the share to the whole drive again and it still
failed.
So I am wondering if some permissions got clobbered or changed. So here are
my q's:
1. What permissions does snapshot replication run under? Does it just run
under the main sql server service account?
2. Can we just share out the subfolder, i.e. either the repl or the unc
subfolder?
3. Is there anything else we should be troubleshooting?
Any help would be much appreciated...Nevermind - I got it to work.
"CLM" wrote:
> They removed the share off of the drive where my snapshot replication step
> (SS 2000 SP3a) writes to. That's all well and good because someone had
> accidently shared out the whole drive. But now my snapshot step is failin
g
> with "process could not create \\server\h\repl\unc".
> Of course, we added a share to the repl folder and it failed with the same
> error msg. Then we added in the share to the whole drive again and it sti
ll
> failed.
> So I am wondering if some permissions got clobbered or changed. So here a
re
> my q's:
> 1. What permissions does snapshot replication run under? Does it just ru
n
> under the main sql server service account?
> 2. Can we just share out the subfolder, i.e. either the repl or the unc
> subfolder?
> 3. Is there anything else we should be troubleshooting?
> Any help would be much appreciated...
Labels:
database,
drive,
microsoft,
mysql,
oracle,
permissions,
replication,
server,
share,
snapshot,
sp3a,
sql,
step,
writes
Permissions
They removed the share off of the drive where my snapshot replication step
(SS 2000 SP3a) writes to. That's all well and good because someone had
accidently shared out the whole drive. But now my snapshot step is failing
with "process could not create \\server\h\repl\unc".
Of course, we added a share to the repl folder and it failed with the same
error msg. Then we added in the share to the whole drive again and it still
failed.
So I am wondering if some permissions got clobbered or changed. So here are
my q's:
1. What permissions does snapshot replication run under? Does it just run
under the main sql server service account?
2. Can we just share out the subfolder, i.e. either the repl or the unc
subfolder?
3. Is there anything else we should be troubleshooting?
Any help would be much appreciated...Nevermind - I got it to work.
"CLM" wrote:
> They removed the share off of the drive where my snapshot replication step
> (SS 2000 SP3a) writes to. That's all well and good because someone had
> accidently shared out the whole drive. But now my snapshot step is failing
> with "process could not create \\server\h\repl\unc".
> Of course, we added a share to the repl folder and it failed with the same
> error msg. Then we added in the share to the whole drive again and it still
> failed.
> So I am wondering if some permissions got clobbered or changed. So here are
> my q's:
> 1. What permissions does snapshot replication run under? Does it just run
> under the main sql server service account?
> 2. Can we just share out the subfolder, i.e. either the repl or the unc
> subfolder?
> 3. Is there anything else we should be troubleshooting?
> Any help would be much appreciated...
(SS 2000 SP3a) writes to. That's all well and good because someone had
accidently shared out the whole drive. But now my snapshot step is failing
with "process could not create \\server\h\repl\unc".
Of course, we added a share to the repl folder and it failed with the same
error msg. Then we added in the share to the whole drive again and it still
failed.
So I am wondering if some permissions got clobbered or changed. So here are
my q's:
1. What permissions does snapshot replication run under? Does it just run
under the main sql server service account?
2. Can we just share out the subfolder, i.e. either the repl or the unc
subfolder?
3. Is there anything else we should be troubleshooting?
Any help would be much appreciated...Nevermind - I got it to work.
"CLM" wrote:
> They removed the share off of the drive where my snapshot replication step
> (SS 2000 SP3a) writes to. That's all well and good because someone had
> accidently shared out the whole drive. But now my snapshot step is failing
> with "process could not create \\server\h\repl\unc".
> Of course, we added a share to the repl folder and it failed with the same
> error msg. Then we added in the share to the whole drive again and it still
> failed.
> So I am wondering if some permissions got clobbered or changed. So here are
> my q's:
> 1. What permissions does snapshot replication run under? Does it just run
> under the main sql server service account?
> 2. Can we just share out the subfolder, i.e. either the repl or the unc
> subfolder?
> 3. Is there anything else we should be troubleshooting?
> Any help would be much appreciated...
Labels:
database,
drive,
microsoft,
mysql,
oracle,
permissions,
replication,
server,
share,
snapshot,
sp3a,
sql,
step,
writes
Subscribe to:
Posts (Atom)