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.
>>