Permissions replication

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

Permission Issues On REPL folder

I'm replicating a database from a SQL server in our DMZ to a server in the
internal network. There is only a one way trust from internal box to
external box (external box cannot see internal). I setup DMZ database as
Publisher and Distributor. The internal box can only pull. When I initiate
a PULL I get a permission's error on REPL folder: The process could not
read file
'\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch' due to OS error 1326.
Any thoughts on how to resolve this permission issue.
thanks
rob
from your internal network on your subscriber can you ping ServerName your
publisher by the netbios name? If not make an entry in the hosts file.
Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
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
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
> I'm replicating a database from a SQL server in our DMZ to a server in the
> internal network. There is only a one way trust from internal box to
> external box (external box cannot see internal). I setup DMZ database as
> Publisher and Distributor. The internal box can only pull. When I
> initiate
> a PULL I get a permission's error on REPL folder: The process could not
> read file
> '\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch'
> due to OS error 1326.
> Any thoughts on how to resolve this permission issue.
> thanks
> rob
>
|||I can ping server with netbios name. I can access share folder using
\\servername\share\ at cmd prompt.
When I run "net view" at the xp_cmdshell I get "System error 5 has occurred"
and "Access is denied"
When I run "dir" at xp_cmdshell I get "Logon failure: unknown user name or
bad password."
Its definitely user access error. I can get the two servers to communicate
in windows, but not sure how to pass security thru to another sql server on
a separate network (DMZ).
thanks again
rob
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OiaaERKHGHA.3904@.TK2MSFTNGP10.phx.gbl...
> from your internal network on your subscriber can you ping ServerName your
> publisher by the netbios name? If not make an entry in the hosts file.
> Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
> about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
> --
> 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
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
>