Alternate Synchronisation Partner

I am using merge replication and trying to configure an alternate
synchronisation partner (ASP). My topology is V-shape and replication is
working OK as long as I do not perform a sync of the subscriber with the ASP.
My subscription contains articles having identity columns managed by merge
replication, and this is casuing me some grief due to error 'Violation of
PRIMARY KEY constraint...Cannot insert duplicate key in object
'MSrepl_identity_range'.'. For ASP, it is not possible to have different
publications to that of the Primary publisher, hence disabling automatic
range management is not an option. Does anyone have an answer to this problem?
Also, does anyone know if it is possible to implement redundancy with merge
replication, similar to a peer-to-peer topology available with transactional
replication in SQL Server 2005?
Paul
MCDBA, MCSE
ASP do not provide redundancy to merge replication topologies. What they do
is allow a merge subscriber to connect with another publisher if the main
publisher goes offline for a brief time. It is unable to parcel out new
identity ranges.
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
"Paul Mu" <PaulMu@.discussions.microsoft.com> wrote in message
news:51DAB05E-232F-4FF0-A89D-2B7EF6859258@.microsoft.com...
> I am using merge replication and trying to configure an alternate
> synchronisation partner (ASP). My topology is V-shape and replication is
> working OK as long as I do not perform a sync of the subscriber with the
ASP.
> My subscription contains articles having identity columns managed by merge
> replication, and this is casuing me some grief due to error 'Violation of
> PRIMARY KEY constraint...Cannot insert duplicate key in object
> 'MSrepl_identity_range'.'. For ASP, it is not possible to have different
> publications to that of the Primary publisher, hence disabling automatic
> range management is not an option. Does anyone have an answer to this
problem?
> Also, does anyone know if it is possible to implement redundancy with
merge
> replication, similar to a peer-to-peer topology available with
transactional
> replication in SQL Server 2005?
> --
> Paul
> MCDBA, MCSE

allowing access to database only through stored procedures

I have read that it is possible to configure sql server express so that the database can only beaccessed through stored procedures. Can anyone tell me how to do this.

Many thanks.

martin

Really? Where is the original article which mentions this? I guess it actually talks about security management in SQL. Yes you can limit permissions of logins (or users after mapping the logins to databases). Image such a scenario: you want a login to do some specific updates to a table, but you do not want to grant UPDATE permission on the table to the login (if you do so, the login can do any UPDATE as he like on the table). In this case you can create a stored procedure to do the specific update, and then you give the EXECUTE permission to the login. This is one of the advantages of SPs.

Stored procedures offer numerous advantages. They can:

Share application logic with other applications, thereby ensuring consistent data access and modification.

Stored procedures can encapsulate business functionality. Business rules or policies encapsulated in stored procedures can be changed in a single location. All clients can use the same stored procedures to ensure consistent data access and modification.

|||

thank you for your reply

martin

Allow both Anonymous Access and Windows Integrated Access on RS

How can I configure IIS to allow anonymous and integrated requests to a
single Reporting Services 2005 installation?
If I try to mix the two securities (anonymous access and Windows integrated
authentication), all requests run as anonymous (under the IUSR account) and
therefore I get an access denied errors when trying to access a report/folder
that does not allow IUSR as a report "browser").
I have tried to set up a separate web site on the IIS box that points to the
Reporting Sever folders that implements either security; but with out
success. It appears that RS 2005 requires to be installed on the "Default
Web Site"?
--
LulkTwo different questions here. The two websites that need to be running as
integrated are: reports and reportserver. Your other websites can run
anonoymous.
Your second question: As far as the default website. The install for 2000
made it very difficult to not have it as the default. However, with 2005
this should be possible. I haven't done it. For this question (how to
install where not the default website), I suggest another posting so someone
will know your question and can answer it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:05F07710-5C48-47F2-B1BC-EA8E8D768A29@.microsoft.com...
> How can I configure IIS to allow anonymous and integrated requests to a
> single Reporting Services 2005 installation?
> If I try to mix the two securities (anonymous access and Windows
> integrated
> authentication), all requests run as anonymous (under the IUSR account)
> and
> therefore I get an access denied errors when trying to access a
> report/folder
> that does not allow IUSR as a report "browser").
> I have tried to set up a separate web site on the IIS box that points to
> the
> Reporting Sever folders that implements either security; but with out
> success. It appears that RS 2005 requires to be installed on the "Default
> Web Site"?
> --
> Lulk|||I have a single web site set up to strictly to access Reporting Services.
One I want to run Integrated and allow Anonymous. I tried creating a separate
web site that points to the same app directories, but that's not working
cleanly.
--
Lulk
"Bruce L-C [MVP]" wrote:
> Two different questions here. The two websites that need to be running as
> integrated are: reports and reportserver. Your other websites can run
> anonoymous.
> Your second question: As far as the default website. The install for 2000
> made it very difficult to not have it as the default. However, with 2005
> this should be possible. I haven't done it. For this question (how to
> install where not the default website), I suggest another posting so someone
> will know your question and can answer it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
> news:05F07710-5C48-47F2-B1BC-EA8E8D768A29@.microsoft.com...
> > How can I configure IIS to allow anonymous and integrated requests to a
> > single Reporting Services 2005 installation?
> > If I try to mix the two securities (anonymous access and Windows
> > integrated
> > authentication), all requests run as anonymous (under the IUSR account)
> > and
> > therefore I get an access denied errors when trying to access a
> > report/folder
> > that does not allow IUSR as a report "browser").
> > I have tried to set up a separate web site on the IIS box that points to
> > the
> > Reporting Sever folders that implements either security; but with out
> > success. It appears that RS 2005 requires to be installed on the "Default
> > Web Site"?
> > --
> > Lulk
>
>|||You cannot run both anonymous and integrated. That just doesn't work. Once
you are anonymous you are anoymous.
If you are in an intranet environment, most domains have a generic Users
group which is everybody in that domain. That would allow you to let
everyone access to the report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E2CC088F-2D45-4BD1-91C7-409823061287@.microsoft.com...
>I have a single web site set up to strictly to access Reporting Services.
> One I want to run Integrated and allow Anonymous. I tried creating a
> separate
> web site that points to the same app directories, but that's not working
> cleanly.
> --
> Lulk
>
> "Bruce L-C [MVP]" wrote:
>> Two different questions here. The two websites that need to be running as
>> integrated are: reports and reportserver. Your other websites can run
>> anonoymous.
>> Your second question: As far as the default website. The install for 2000
>> made it very difficult to not have it as the default. However, with 2005
>> this should be possible. I haven't done it. For this question (how to
>> install where not the default website), I suggest another posting so
>> someone
>> will know your question and can answer it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
>> news:05F07710-5C48-47F2-B1BC-EA8E8D768A29@.microsoft.com...
>> > How can I configure IIS to allow anonymous and integrated requests to a
>> > single Reporting Services 2005 installation?
>> > If I try to mix the two securities (anonymous access and Windows
>> > integrated
>> > authentication), all requests run as anonymous (under the IUSR account)
>> > and
>> > therefore I get an access denied errors when trying to access a
>> > report/folder
>> > that does not allow IUSR as a report "browser").
>> > I have tried to set up a separate web site on the IIS box that points
>> > to
>> > the
>> > Reporting Sever folders that implements either security; but with out
>> > success. It appears that RS 2005 requires to be installed on the
>> > "Default
>> > Web Site"?
>> > --
>> > Lulk
>>