Custom Security Roles

I am trying to implement forms authentication in reporting services and I
would like to use the report manager for rendering reports. What I don't
want to use is the built-in tools for item level and system level security.
Is there a way to get information as to which item is being accessed in the
Getpermissions and CheckAccess function so I can check my custom database for
authorization?Brent,
I don't think you need to know the item accessed because the CheckAccess
overload is scoped at an item level. In other words, if the user tries to
run a report A, the Report Server will pass the security descriptor for
report A only. The job of the security extension is to find out if the user
has rights to carry the action by examing the security descriptor. Any yes,
you can use application-defined role membership policies to simplify the
user maintanance.
I have a two-part article in the works for the SQL Magazine which discusses
Forms Authentication in detail. It should be out in January-February issues
I think.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Brent Slezak" <Brent Slezak@.discussions.microsoft.com> wrote in message
news:4614209E-953D-4A4B-B2BD-96EFE79FFDAC@.microsoft.com...
> I am trying to implement forms authentication in reporting services and I
> would like to use the report manager for rendering reports. What I don't
> want to use is the built-in tools for item level and system level
security.
> Is there a way to get information as to which item is being accessed in
the
> Getpermissions and CheckAccess function so I can check my custom database
for
> authorization?|||Teo,
First of all, I want to thank you for your prompt response to my question
and I will be looking for that article when it comes out.
Let me go into further detail as to the situation with the reporting
services and how I would like to use them. I currrently have a proprietary
security system setup for my enterprise-scale application that manages
thousands of users and groups and tens of thousands of roles. I don't want to
have to re-define that information in the ReportSErver database. Actually I
would like it if I had absolutly no security definition at all in the
ReportServer database. That being said. How would I get the unique
identifier of the object (i.e. report,folder,datasource) being accessed so
that I can cross-reference MyDatabase1 for security access.
In a nutshell I want to be able to use the report manager for the report
rendering and not for managing role-based security. I think building our own
custom rendering UI is the only logical alternative.
Please let me know what you would consider the best option with this scenario.
Thank you in advance for your input.
Brent
"Teo Lachev [MVP]" wrote:
> Brent,
> I don't think you need to know the item accessed because the CheckAccess
> overload is scoped at an item level. In other words, if the user tries to
> run a report A, the Report Server will pass the security descriptor for
> report A only. The job of the security extension is to find out if the user
> has rights to carry the action by examing the security descriptor. Any yes,
> you can use application-defined role membership policies to simplify the
> user maintanance.
> I have a two-part article in the works for the SQL Magazine which discusses
> Forms Authentication in detail. It should be out in January-February issues
> I think.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "Brent Slezak" <Brent Slezak@.discussions.microsoft.com> wrote in message
> news:4614209E-953D-4A4B-B2BD-96EFE79FFDAC@.microsoft.com...
> > I am trying to implement forms authentication in reporting services and I
> > would like to use the report manager for rendering reports. What I don't
> > want to use is the built-in tools for item level and system level
> security.
> >
> > Is there a way to get information as to which item is being accessed in
> the
> > Getpermissions and CheckAccess function so I can check my custom database
> for
> > authorization?
>
>|||Brent,
I understand your scenario now. Of course, assuming that the reports will
be rendered on the server side of the application you don't have an issue
since you have an application front end. This is similar to the security
scenario I describe in Chapter 13 of my book.
However, the real problem is with URL addressability and custom security
extension. One approach that may be appropriate in your case is to get the
report path from the URL request. This could be similar to the approach I
describe in the following thread
http://groups.google.com/groups?q=Disable+Hyperlink+in+EXCEL&hl=en&lr=&selm=%23VCcwuh1EHA.1264%40TK2MSFTNGP12.phx.gbl&rnum=1
Once you get the report path, you can get the report identifier (the primary
key in table Catalgo) which is what you may want to use in your custom
security infrastructure.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Brent Slezak" <BrentSlezak@.discussions.microsoft.com> wrote in message
news:3741B21F-0963-457F-8EC6-A1F6403CB514@.microsoft.com...
> Teo,
> First of all, I want to thank you for your prompt response to my question
> and I will be looking for that article when it comes out.
> Let me go into further detail as to the situation with the reporting
> services and how I would like to use them. I currrently have a
proprietary
> security system setup for my enterprise-scale application that manages
> thousands of users and groups and tens of thousands of roles. I don't want
to
> have to re-define that information in the ReportSErver database. Actually
I
> would like it if I had absolutly no security definition at all in the
> ReportServer database. That being said. How would I get the unique
> identifier of the object (i.e. report,folder,datasource) being accessed so
> that I can cross-reference MyDatabase1 for security access.
> In a nutshell I want to be able to use the report manager for the report
> rendering and not for managing role-based security. I think building our
own
> custom rendering UI is the only logical alternative.
> Please let me know what you would consider the best option with this
scenario.
> Thank you in advance for your input.
> Brent
> "Teo Lachev [MVP]" wrote:
> > Brent,
> >
> > I don't think you need to know the item accessed because the CheckAccess
> > overload is scoped at an item level. In other words, if the user tries
to
> > run a report A, the Report Server will pass the security descriptor for
> > report A only. The job of the security extension is to find out if the
user
> > has rights to carry the action by examing the security descriptor. Any
yes,
> > you can use application-defined role membership policies to simplify the
> > user maintanance.
> >
> > I have a two-part article in the works for the SQL Magazine which
discusses
> > Forms Authentication in detail. It should be out in January-February
issues
> > I think.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MVP [SQL Server], MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ---
> >
> > "Brent Slezak" <Brent Slezak@.discussions.microsoft.com> wrote in message
> > news:4614209E-953D-4A4B-B2BD-96EFE79FFDAC@.microsoft.com...
> > > I am trying to implement forms authentication in reporting services
and I
> > > would like to use the report manager for rendering reports. What I
don't
> > > want to use is the built-in tools for item level and system level
> > security.
> > >
> > > Is there a way to get information as to which item is being accessed
in
> > the
> > > Getpermissions and CheckAccess function so I can check my custom
database
> > for
> > > authorization?
> >
> >
> >

Custom Security and RS Standard Edition

My report service is Standard Edition and I implement custom security. When
I start the reporting server, the following error are shown in the log.
ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., CryptUnprotectData: Win32 error:-2146893813;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[] data, Int32 dwFlags)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[] data)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String data)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
-- End of inner exception stack trace --
ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
ERROR: Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
The encrypted value for configuration setting Dsn cannot be decrypted. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[] data, Int32 dwFlags)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[] data)
at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String data)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String encryptedData, String element)
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
occured with a config file change. New config file will not be used. Error:
The encrypted value for configuration setting Dsn cannot be decrypted.
ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i INFO:
RPC Server stopped
ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31:: Service
shutting down.Custom Security extensions are not supported with RS Standard Edition. They
require Enterprise edition (or developer edition for development).
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
> My report service is Standard Edition and I implement custom security.
> When
> I start the reporting server, the following error are shown in the log.
> ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., CryptUnprotectData: Win32 error:-2146893813;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be decrypted., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be
> decrypted. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> data, Int32 dwFlags)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> data)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> data)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> -- End of inner exception stack trace --
> ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> The encrypted value for configuration setting Dsn cannot be
> decrypted. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> data, Int32 dwFlags)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> data)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> data)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> encryptedData, String element)
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
> ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
> occured with a config file change. New config file will not be used.
> Error:
> The encrypted value for configuration setting Dsn cannot be decrypted.
> ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
> INFO:
> RPC Server stopped
> ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
> Service
> shutting down.|||Actually, we don't need any features of Enterprise version but we need to
spend $20,000 US dollar to buy this product just because of Custom Security
Extensions and Data Driven Subscriptions. I don't think it is worth. How
about SQL server 2005 version ?
"Jeff A. Stucker" wrote:
> Custom Security extensions are not supported with RS Standard Edition. They
> require Enterprise edition (or developer edition for development).
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
> > My report service is Standard Edition and I implement custom security.
> > When
> > I start the reporting server, the following error are shown in the log.
> >
> > ERROR: Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details., CryptUnprotectData: Win32 error:-2146893813;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
> > Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be decrypted., ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be
> > decrypted. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> > data, Int32 dwFlags)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > -- End of inner exception stack trace --
> > ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
> > ERROR: Exception caught starting RPC server:
> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
> > The encrypted value for configuration setting Dsn cannot be
> > decrypted. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> > more
> > details.
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
> > data, Int32 dwFlags)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
> > data)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
> > encryptedData, String element)
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
> > at
> > Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
> > ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
> > occured with a config file change. New config file will not be used.
> > Error:
> > The encrypted value for configuration setting Dsn cannot be decrypted.
> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
> > INFO:
> > RPC Server stopped
> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
> > Service
> > shutting down.
>
>|||No announcement has been made on features per version (there was a
presentation on improvements with 2005 but no mention of how things will be
packaged and what the costs would be). You say you don't need enterprise but
then you say you do, because data driven subscriptions and custom security
extensions are two major features of enterprise. There are not that many
things different. About the only other major difference other than those two
is support for web farms. I bet if you price versus Crystal that RS will
still come out ahead or at least even.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:73E4DC66-CC5D-4DB2-86BD-C0554280806B@.microsoft.com...
> Actually, we don't need any features of Enterprise version but we need to
> spend $20,000 US dollar to buy this product just because of Custom
> Security
> Extensions and Data Driven Subscriptions. I don't think it is worth. How
> about SQL server 2005 version ?
> "Jeff A. Stucker" wrote:
>> Custom Security extensions are not supported with RS Standard Edition.
>> They
>> require Enterprise edition (or developer edition for development).
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
>> news:6B887742-D891-45CB-8B42-30A3EBA1E7A4@.microsoft.com...
>> > My report service is Standard Edition and I implement custom security.
>> > When
>> > I start the reporting server, the following error are shown in the log.
>> >
>> > ERROR: Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details., CryptUnprotectData: Win32 error:-2146893813;
>> > Info:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > ReportingServicesService!library!11f0!12/16/2004-14:46:03:: e ERROR:
>> > Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be decrypted.,
>> > ;
>> > Info:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be
>> > decrypted. -->
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
>> > data, Int32 dwFlags)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > -- End of inner exception stack trace --
>> > ReportingServicesService!servicecontroller!11f0!12/16/2004-14:46:03:: e
>> > ERROR: Exception caught starting RPC server:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:
>> > The encrypted value for configuration setting Dsn cannot be
>> > decrypted. -->
>> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details.
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.UnprotectData(Byte[]
>> > data, Int32 dwFlags)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(Byte[]
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectData(String
>> > data)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > -- End of inner exception stack trace --
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(String
>> > encryptedData, String element)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString()
>> > at
>> > Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
>> > ReportingServicesService!configmanager!11f0!12/16/2004-14:46:03:: Error
>> > occured with a config file change. New config file will not be used.
>> > Error:
>> > The encrypted value for configuration setting Dsn cannot be decrypted.
>> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:30:: i
>> > INFO:
>> > RPC Server stopped
>> > ReportingServicesService!servicecontroller!efc!12/16/2004-15:08:31::
>> > Service
>> > shutting down.
>>

Custom Resolver in SQL Server 2005

I'm trying to implement .NET based custom resolver for SQL Server 2005. MS
example shows how to work with publisher / subscriber record data only. To
resolve a conflict I need more info about the business object represented by
record data. I need to run a query / procedure for this purpose. To make a
connection from within my resolver user / password are required. No such
thing is available in 'Microsoft.SqlServer.Replication.BusinessLogicSupp ort'
class.
Note: In SQL Server 2000 VB based COM custom resolver I have
'IReplRowChange' object as an INPUT param for 'IVBCustomResolver_Reconcile'
method which has 'GetSourceConnectionInfo' / 'GetDestinationConnectionInfo'
methods to get to GetLogin / GetPassword and than use ADODB to create a
connection string to run query or sp.
Appreciate any help on this subject.
Is there any workaround to use Custom Resolver COM created for SQL Server
2000 implementing IVBCustomResolver for SQL Server 2005?
|||I've found an example in
C:\Program Files\Microsoft SQL
Server\90\Samples\Replication\Merge\BusinessLogic\ CS
Thanks All

custom report item test justification.

Dear all,
i need to extend the functionality of the textbox in reporting services to
implement text justification align.
i made a research and found the concept of "custom report items" but it's
implmented as image i also see the sample of polygonCL in SDK extention
samples
i am asking if there are a way to take all the functionality of textbox and
on just extend the required functionality' or develop a new textbox and
render it as image?
thanksWhat do you mean by text justification?
If you mean you want to center, right align, or left align - those are
already availiable. Just click on the text box and clikc one of the
Justifications.
I dont think this is the problem you are facing. What, exactly, is the
issue? and what is it your tryingto accomplish?|||thanks a lot for your replaying
i mean by text justification is the text width is the same for all line
inside textbox
if you look at word u will see right, left, center and justify align
i need to use a justify align for textbox
by the way i am using RS 2005
thanks
"sorcerdon@.gmail.com" wrote:
> What do you mean by text justification?
> If you mean you want to center, right align, or left align - those are
> already availiable. Just click on the text box and clikc one of the
> Justifications.
> I dont think this is the problem you are facing. What, exactly, is the
> issue? and what is it your tryingto accomplish?
>

Custom Pagination in Sql Server Reports

Hi there,
Can we implement custom pagination in Sql Server Reports 2005?
Thanks
RaviYes using a formula to break at the given no of lines.
=Int((RowNumber(Nothing)-1)/n) here n is the no of lines in a page.
Amarnath
"Ravi Manda" wrote:
> Hi there,
> Can we implement custom pagination in Sql Server Reports 2005?
> Thanks
> Ravi|||Hi Amarnath , where do i apply and attach this code.
Thanks!
"Amarnath" wrote:
> Yes using a formula to break at the given no of lines.
> =Int((RowNumber(Nothing)-1)/n) here n is the no of lines in a page.
> Amarnath
> "Ravi Manda" wrote:
> > Hi there,
> >
> > Can we implement custom pagination in Sql Server Reports 2005?
> >
> > Thanks
> > Ravi

Custom Editor

Hi,

If I implement a custom editor by inheriting from UITypeEditor, Can I invoke it at RUN TIME from a standard control other than PropertyGrid, say a comboBox or a button ?

If it is possible, could you please let me know how to do it or could you please direct me to some URL which shows how to do it.

Do I have to create a custom control that inherits from control for doing this ?

Thank you.

regards.
S

UITypeEditors are for extending design-time support in the property grid only. So they can be used within the VS studio property grid on tasks and components, or within your custom UI if that uses a property grid. I assume you are asking this in the context of a SSIS component or task and providing improved designer support or a custom UI.

Custom Delivery Extension - SubscriptionID

I am attempting to implement a custom delivery extension for SSRS 2000. The custom delivery extension will deliver the report to a database(table). CreateSubscription WebMethod returns a SubscriptionID once a subscription is created. Is it possible to get this SubscriptionID at run-time i.e when the IDeliveryExtension.Deliver method is called? If so, how? I want to store the SubscriptionID with the report in the database. Thanks for your help.

Hi

I had the same question .

please help us.

Custom Delivery Extension - SubscriptionID

I am attempting to implement a custom delivery extension for SSRS 2000. The custom delivery extension will deliver the report to a database(table). CreateSubscription WebMethod returns a SubscriptionID once a subscription is created. Is it possible to get this SubscriptionID at run-time i.e when the IDeliveryExtension.Deliver method is called? If so, how? I want to store the SubscriptionID with the report in the database. Thanks for your help.

Hi

I had the same question .

please help us.

Custom Data Extension

I know that SRS Enterprise Edition (EE) is needed to implement a custom
security extension. Do I need Enterprise too if I want to implement a
custom data extension?
TIA.You shouldn't as noted here:
http://www.microsoft.com/sql/reporting/productinfo/features.asp
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:uKfS3ZS3EHA.4092@.TK2MSFTNGP14.phx.gbl...
> I know that SRS Enterprise Edition (EE) is needed to implement a custom
> security extension. Do I need Enterprise too if I want to implement a
> custom data extension?
> TIA.
>

Custom Auditing

We are having to implement restrictive security permissions on SQL, some of
which requires that we audit and log any access of any kind for specific
tables and columns. What would be the best way to do this? We can use
triggers to log any changes to specific tables and columns, but we can't use
those when a user is simply retrieving sensitive and encrypted data from a
table. We could lock down access permissions to those tables so that only
authorized users can execute stored procedures, and have code to log such
access in the procs themselves, but we need to ensure that even if the dbo
or sa were to access that data, that it would be logged.
TIA
Michael MacGregor
Database ArchitectMichael,
If you want to log accesses, even of the dbo or sa, then you pretty much
will have to use Profiler. You can put the traces into tables for online
auditing, either directly or by periodically importing the trace files.
There are also probably some third-party auditing tools.
RLF
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:OyGkG4tyHHA.3536@.TK2MSFTNGP06.phx.gbl...
> We are having to implement restrictive security permissions on SQL, some
> of which requires that we audit and log any access of any kind for
> specific tables and columns. What would be the best way to do this? We can
> use triggers to log any changes to specific tables and columns, but we
> can't use those when a user is simply retrieving sensitive and encrypted
> data from a table. We could lock down access permissions to those tables
> so that only authorized users can execute stored procedures, and have code
> to log such access in the procs themselves, but we need to ensure that
> even if the dbo or sa were to access that data, that it would be logged.
> TIA
> Michael MacGregor
> Database Architect
>|||Thanks again Russell.
MTM