I am trying to install RS on two web servers which are clustered. First, I install the report service and report database on a sql server. then after i successfully install RS on the 1st webserver in web farm, i have problem install RS on the 2nd web server in web farm. below is the log. all three machines are in the same domain.
any thoughts, recommendations, suggestions?
thanks
***********************************************************
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!4d8!7/28/2004-17:22:46:: i INFO: Running on 1 physical processors, 1 logical processors
ReportingServicesService!resourceutilities!4d8!7/28/2004-17:22:46:: i INFO: Reporting Services starting SKU: Enterprise
ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO: Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO: Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO: Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO: Execution Log Entry Expiration timer enabled: Cycle: 31033 seconds
ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO: Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!library!834!7/28/2004-17:22:47:: e 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!834!7/28/2004-17:22:47:: 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!library!834!7/28/2004-17:22:47:: Exception caught while starting service. Error: 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.ConnectionManager..ctor()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!834!7/28/2004-17:22:47:: Attempting to start service again...
**********************************************
<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__main_07_28_2004_17_22_45.log</Path>
<SystemName>WEB0001</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4d8!7/28/2004-17:22:46:: e 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!4d8!7/28/2004-17:22:46:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException: The encrypted value for configuration setting LogonUser cannot be decrypted., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException: The encrypted value for configuration setting LogonUser 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!4d8!7/28/2004-17:22:46:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException: The encrypted value for configuration setting LogonUser 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_CatalogUser()
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer()
ReportingServicesService!servicecontroller!4c8!7/28/2004-17:22:47:: Total Physical memory: 267833344Are you running setup on the second machines? It looks like you are copying
the config files from one machine to the other. This will not work as there
is information in the config files that can only be decrypted by the machine
that encrypted them. Setup should allow you to add a machine to a web farm.
Is it not working for you?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"dennis" <dennis@.discussions.microsoft.com> wrote in message
news:71BE4356-29BE-483E-AD9C-1B1FA5C83DED@.microsoft.com...
> I am trying to install RS on two web servers which are clustered. First, I
install the report service and report database on a sql server. then after i
successfully install RS on the 1st webserver in web farm, i have problem
install RS on the 2nd web server in web farm. below is the log. all three
machines are in the same domain.
> any thoughts, recommendations, suggestions?
> thanks
> ***********************************************************
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!resourceutilities!4d8!7/28/2004-17:22:46:: i
INFO: Running on 1 physical processors, 1 logical processors
> ReportingServicesService!resourceutilities!4d8!7/28/2004-17:22:46:: i
INFO: Reporting Services starting SKU: Enterprise
> ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 31033 seconds
> ReportingServicesService!runningjobs!4d8!7/28/2004-17:22:46:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!library!834!7/28/2004-17:22:47:: e 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!834!7/28/2004-17:22:47:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInfor
mationException: The encrypted value for configuration setting Dsn cannot be
decrypted., ;
> Info:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInfor
mationException: 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(By
te[] data, Int32 dwFlags)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(Byte[] data)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(String data)
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(S
tring encryptedData, String element)
> -- End of inner exception stack trace --
> ReportingServicesService!library!834!7/28/2004-17:22:47:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInfor
mationException: 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(By
te[] data, Int32 dwFlags)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(Byte[] data)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(String data)
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(S
tring encryptedData, String element)
> -- End of inner exception stack trace --
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(S
tring encryptedData, String element)
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_ConnectionString
()
> at Microsoft.ReportingServices.Library.ConnectionManager..ctor()
> at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!834!7/28/2004-17:22:47:: Attempting to
start service again...
> **********************************************
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Central Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__main_07_28_2004_17_22_45.log</Path>
> <SystemName>WEB0001</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration
file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:45:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!4d8!7/28/2004-17:22:46:: e 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!4d8!7/28/2004-17:22:46:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInfor
mationException: The encrypted value for configuration setting LogonUser
cannot be decrypted., ;
> Info:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInfor
mationException: The encrypted value for configuration setting LogonUser
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(By
te[] data, Int32 dwFlags)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(Byte[] data)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(String data)
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(S
tring encryptedData, String element)
> -- End of inner exception stack trace --
> ReportingServicesService!servicecontroller!4d8!7/28/2004-17:22:46:: e
ERROR: Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInfor
mationException: The encrypted value for configuration setting LogonUser
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(By
te[] data, Int32 dwFlags)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(Byte[] data)
> at
Microsoft.ReportingServices.Diagnostics.DataProtectionLocal.LocalUnprotectDa
ta(String data)
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(S
tring encryptedData, String element)
> -- End of inner exception stack trace --
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.DecryptCatalogData(S
tring encryptedData, String element)
> at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_CatalogUser()
> at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServe
r()
> ReportingServicesService!servicecontroller!4c8!7/28/2004-17:22:47:: Total
Physical memory: 267833344
>
Showing posts with label cluster. Show all posts
Showing posts with label cluster. Show all posts
Friday, March 9, 2012
Saturday, February 25, 2012
Reporting Server - Replication Topology
Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything
works great. Our application runs on two IIS web servers and connects to the
SQL back end.
When people are running reports the SQL server can get taxed. What is the
best replication method where uses can connected to a different SQL server
and run reports on that server? The data has to be as current as possible.
Thanks!
Transactional replication.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
> Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything
> works great. Our application runs on two IIS web servers and connects to
> the
> SQL back end.
> When people are running reports the SQL server can get taxed. What is the
> best replication method where uses can connected to a different SQL server
> and run reports on that server? The data has to be as current as possible.
> Thanks!
>
|||Hilary,
Where can I find a good "How To" to set this up properly? Is this fairly
easy? What do you have to watch for? I have setup log shipping before and
that is pretty simple. Thanks!
"Hilary Cotter" wrote:
> Transactional replication.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
>
>
|||On SQL Server 2000 I have used transactional replication and log shipping
for this - please see this article for the pros and cons of each approach:
http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Google around for transactional replication tutorials - or check out my
book. The best approach is to get your hands dirty right away and post back
here if you encounter problems.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:DB1C8113-C62C-41E4-8D85-390B8424EE3D@.microsoft.com...[vbcol=seagreen]
> Hilary,
> Where can I find a good "How To" to set this up properly? Is this fairly
> easy? What do you have to watch for? I have setup log shipping before and
> that is pretty simple. Thanks!
> "Hilary Cotter" wrote:
works great. Our application runs on two IIS web servers and connects to the
SQL back end.
When people are running reports the SQL server can get taxed. What is the
best replication method where uses can connected to a different SQL server
and run reports on that server? The data has to be as current as possible.
Thanks!
Transactional replication.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
> Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything
> works great. Our application runs on two IIS web servers and connects to
> the
> SQL back end.
> When people are running reports the SQL server can get taxed. What is the
> best replication method where uses can connected to a different SQL server
> and run reports on that server? The data has to be as current as possible.
> Thanks!
>
|||Hilary,
Where can I find a good "How To" to set this up properly? Is this fairly
easy? What do you have to watch for? I have setup log shipping before and
that is pretty simple. Thanks!
"Hilary Cotter" wrote:
> Transactional replication.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
>
>
|||On SQL Server 2000 I have used transactional replication and log shipping
for this - please see this article for the pros and cons of each approach:
http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Google around for transactional replication tutorials - or check out my
book. The best approach is to get your hands dirty right away and post back
here if you encounter problems.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:DB1C8113-C62C-41E4-8D85-390B8424EE3D@.microsoft.com...[vbcol=seagreen]
> Hilary,
> Where can I find a good "How To" to set this up properly? Is this fairly
> easy? What do you have to watch for? I have setup log shipping before and
> that is pretty simple. Thanks!
> "Hilary Cotter" wrote:
Subscribe to:
Posts (Atom)