Authentication via internet explorer fails when connecting to reporting
services from a hostname other then the NETBIOS name.
for example my servers name is BOB
so if i do http://bob/ReportServer it works fine
I have an A record that points reportingservices.mydomain.com to BOB's ip
address
so if i go to http://reportingservices.mydomain.com/ReportServer I get the
user credentials box. How can I fix this?On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i dohttp://bob/ReportServerit works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> user credentials box. How can I fix this?
It seems like you should check the authentication methods of the
virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||The virtual directory is just part of the default web site
"EMartinez" wrote:
> On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> > Authentication via internet explorer fails when connecting to reporting
> > services from a hostname other then the NETBIOS name.
> >
> > for example my servers name is BOB
> >
> > so if i dohttp://bob/ReportServerit works fine
> >
> > I have an A record that points reportingservices.mydomain.com to BOB's ip
> > address
> >
> > so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> > user credentials box. How can I fix this?
> It seems like you should check the authentication methods of the
> virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||Hello,
I think this situation depends on security settings in IE.
Try to add http://reportingservices.mydomain.com/ website to your trusted
websites.
If still you 'll be prompted for login and password check security settings
in IE (for trusted sites).
Ensure that you have checked the last option for logging user (logging with
current user name and password).
I hope this will help.
Best regards,
Rados³aw £ebkowski
U¿ytkownik "Nick T" <NickT@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:2821371F-75FC-4BC7-A0E0-B7B01A512874@.microsoft.com...
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i do http://bob/ReportServer it works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go to http://reportingservices.mydomain.com/ReportServer I get the
> user credentials box. How can I fix this?
Showing posts with label servers. Show all posts
Showing posts with label servers. Show all posts
Tuesday, March 20, 2012
Monday, March 12, 2012
Reporting Services
A recent MSDN magazine article decribed SQL Server's Reporting Services.
Will Reporting Services work on MSDE?
TIA!
Wayne P.
No, you can't host Reporting Services on MSDE--it must be Standard Edition
or better. You CAN, however, extract data from MSDE databases and virtually
any other data source.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Wayne P." <infinite@.nospam-totalink.net> wrote in message
news:%23FzZKJobEHA.3476@.tk2msftngp13.phx.gbl...
> A recent MSDN magazine article decribed SQL Server's Reporting Services.
> Will Reporting Services work on MSDE?
> TIA!
> Wayne P.
>
|||Thanks for the info -
IMHO this is a shame - the toolset would have added a nice set of
functionality for smaller projects. Most of my clients end up using MSDE
solely due to the price of MS SQL.
Thanks again -
Wayne P.
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:eRtlsQobEHA.808@.tk2msftngp13.phx.gbl...
> No, you can't host Reporting Services on MSDE--it must be Standard Edition
> or better. You CAN, however, extract data from MSDE databases and
virtually
> any other data source.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Wayne P." <infinite@.nospam-totalink.net> wrote in message
> news:%23FzZKJobEHA.3476@.tk2msftngp13.phx.gbl...
>
|||In SQL Server 2005 we will have reporting services report controls included
in Visual Studio that will provide you report rendering, rather than server
functionality.
They will be free to redist as part of your app.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne P." <infinite@.nospam-totalink.net> wrote in message
news:#1ic7oobEHA.3804@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks for the info -
> IMHO this is a shame - the toolset would have added a nice set of
> functionality for smaller projects. Most of my clients end up using MSDE
> solely due to the price of MS SQL.
> Thanks again -
> Wayne P.
>
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:eRtlsQobEHA.808@.tk2msftngp13.phx.gbl...
Edition[vbcol=seagreen]
> virtually
> rights.
Services.
>
|||I look forward to the new version!
Wayne P.
"Euan Garden[MS]" <euang@.online.microsoft.com> wrote in message
news:emZeqvqbEHA.2544@.TK2MSFTNGP10.phx.gbl...
> In SQL Server 2005 we will have reporting services report controls
included
> in Visual Studio that will provide you report rendering, rather than
server
> functionality.
> They will be free to redist as part of your app.
> --
> -Euan
> Please reply only to the newsgroup so that others can benefit. When
posting,
> please state the version of SQL Server being used and the error
number/exact
> error message text received, if any.
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "Wayne P." <infinite@.nospam-totalink.net> wrote in message
> news:#1ic7oobEHA.3804@.TK2MSFTNGP10.phx.gbl...
MSDE
> Edition
> Services.
>
Will Reporting Services work on MSDE?
TIA!
Wayne P.
No, you can't host Reporting Services on MSDE--it must be Standard Edition
or better. You CAN, however, extract data from MSDE databases and virtually
any other data source.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Wayne P." <infinite@.nospam-totalink.net> wrote in message
news:%23FzZKJobEHA.3476@.tk2msftngp13.phx.gbl...
> A recent MSDN magazine article decribed SQL Server's Reporting Services.
> Will Reporting Services work on MSDE?
> TIA!
> Wayne P.
>
|||Thanks for the info -
IMHO this is a shame - the toolset would have added a nice set of
functionality for smaller projects. Most of my clients end up using MSDE
solely due to the price of MS SQL.
Thanks again -
Wayne P.
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:eRtlsQobEHA.808@.tk2msftngp13.phx.gbl...
> No, you can't host Reporting Services on MSDE--it must be Standard Edition
> or better. You CAN, however, extract data from MSDE databases and
virtually
> any other data source.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Wayne P." <infinite@.nospam-totalink.net> wrote in message
> news:%23FzZKJobEHA.3476@.tk2msftngp13.phx.gbl...
>
|||In SQL Server 2005 we will have reporting services report controls included
in Visual Studio that will provide you report rendering, rather than server
functionality.
They will be free to redist as part of your app.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne P." <infinite@.nospam-totalink.net> wrote in message
news:#1ic7oobEHA.3804@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks for the info -
> IMHO this is a shame - the toolset would have added a nice set of
> functionality for smaller projects. Most of my clients end up using MSDE
> solely due to the price of MS SQL.
> Thanks again -
> Wayne P.
>
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:eRtlsQobEHA.808@.tk2msftngp13.phx.gbl...
Edition[vbcol=seagreen]
> virtually
> rights.
Services.
>
|||I look forward to the new version!
Wayne P.
"Euan Garden[MS]" <euang@.online.microsoft.com> wrote in message
news:emZeqvqbEHA.2544@.TK2MSFTNGP10.phx.gbl...
> In SQL Server 2005 we will have reporting services report controls
included
> in Visual Studio that will provide you report rendering, rather than
server
> functionality.
> They will be free to redist as part of your app.
> --
> -Euan
> Please reply only to the newsgroup so that others can benefit. When
posting,
> please state the version of SQL Server being used and the error
number/exact
> error message text received, if any.
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "Wayne P." <infinite@.nospam-totalink.net> wrote in message
> news:#1ic7oobEHA.3804@.TK2MSFTNGP10.phx.gbl...
MSDE
> Edition
> Services.
>
Reporting Service with Analysis service
I compose two servers. One is for Reporting service and the other is for
Analysis Service. I developed one report with analysis services's cube as a
datasource.
but the report does not execute properly. the message is for datasource
connection error.
So I compose the server again as one server. The RS ans AS installed in this
server.
The report works properly!
Is it impossible to install at seperate server ?
I used SQL server 2000 with current sevicepack.Hey,
It does work with 2 different servers. You may be having issues with
authentication or permissions.
If possible use an admin account from Analysis server in the connection
properties of the datasource.
Bye
Sumit Pilankar
"fogcity" <fogcity@.discussions.microsoft.com> wrote in message
news:FA13FF31-94D4-4619-8E9B-212252B372EF@.microsoft.com...
>I compose two servers. One is for Reporting service and the other is for
> Analysis Service. I developed one report with analysis services's cube as
> a
> datasource.
> but the report does not execute properly. the message is for datasource
> connection error.
> So I compose the server again as one server. The RS ans AS installed in
> this
> server.
> The report works properly!
> Is it impossible to install at seperate server ?
> I used SQL server 2000 with current sevicepack.
>
Analysis Service. I developed one report with analysis services's cube as a
datasource.
but the report does not execute properly. the message is for datasource
connection error.
So I compose the server again as one server. The RS ans AS installed in this
server.
The report works properly!
Is it impossible to install at seperate server ?
I used SQL server 2000 with current sevicepack.Hey,
It does work with 2 different servers. You may be having issues with
authentication or permissions.
If possible use an admin account from Analysis server in the connection
properties of the datasource.
Bye
Sumit Pilankar
"fogcity" <fogcity@.discussions.microsoft.com> wrote in message
news:FA13FF31-94D4-4619-8E9B-212252B372EF@.microsoft.com...
>I compose two servers. One is for Reporting service and the other is for
> Analysis Service. I developed one report with analysis services's cube as
> a
> datasource.
> but the report does not execute properly. the message is for datasource
> connection error.
> So I compose the server again as one server. The RS ans AS installed in
> this
> server.
> The report works properly!
> Is it impossible to install at seperate server ?
> I used SQL server 2000 with current sevicepack.
>
Friday, March 9, 2012
Reporting Service on NLB and Virtual Servers
Trying to get reporting Services to work under a Virtual Server that is NLB.
I can access the reports manager and Reports via the Default Web and basic
reports via the virtual server. The problem I cannot access the reports if it
requires a param specified by the user. It fails with a browser DNS error.
Does any know how to make this work. Like I said prior non-param, reports are
working fine. The error only happens with Param reports.
IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
Folder>/<report Name>
Another weird thing is this works in our test environment without NLB.Actually after some more investigation I've figured out what was causing the
below mention problem but now something else is weird.
Okay so here is the weird thing. I have created the VDirectories under my
site since we do not use the Default Web Site like most people. Anyway, The
problem I'm having is if I view the VDir on the site Http://<Ip
address>/reportserver I get a cannot connect error "cannot find server
....". The weird thing is if I change the ip address to All Unassigned for
the Site it works fine. Of course this is not acceptable either.
I haven't been able to find anything in regards to what might be causing
this.. Does anyone have a idea?
"James" wrote:
> Trying to get reporting Services to work under a Virtual Server that is NLB.
> I can access the reports manager and Reports via the Default Web and basic
> reports via the virtual server. The problem I cannot access the reports if it
> requires a param specified by the user. It fails with a browser DNS error.
> Does any know how to make this work. Like I said prior non-param, reports are
> working fine. The error only happens with Param reports.
> IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
> Folder>/<report Name>
> Another weird thing is this works in our test environment without NLB.
I can access the reports manager and Reports via the Default Web and basic
reports via the virtual server. The problem I cannot access the reports if it
requires a param specified by the user. It fails with a browser DNS error.
Does any know how to make this work. Like I said prior non-param, reports are
working fine. The error only happens with Param reports.
IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
Folder>/<report Name>
Another weird thing is this works in our test environment without NLB.Actually after some more investigation I've figured out what was causing the
below mention problem but now something else is weird.
Okay so here is the weird thing. I have created the VDirectories under my
site since we do not use the Default Web Site like most people. Anyway, The
problem I'm having is if I view the VDir on the site Http://<Ip
address>/reportserver I get a cannot connect error "cannot find server
....". The weird thing is if I change the ip address to All Unassigned for
the Site it works fine. Of course this is not acceptable either.
I haven't been able to find anything in regards to what might be causing
this.. Does anyone have a idea?
"James" wrote:
> Trying to get reporting Services to work under a Virtual Server that is NLB.
> I can access the reports manager and Reports via the Default Web and basic
> reports via the virtual server. The problem I cannot access the reports if it
> requires a param specified by the user. It fails with a browser DNS error.
> Does any know how to make this work. Like I said prior non-param, reports are
> working fine. The error only happens with Param reports.
> IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
> Folder>/<report Name>
> Another weird thing is this works in our test environment without NLB.
Reporting Service in Cluster Web Server
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
>
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
>
Wednesday, March 7, 2012
Reporting Servers - Export to Multiple tabs in Excel
I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.
Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.
For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).
|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||I would like to do this also. Is there any way to name each Sheet?
|||Unfortunately no, you cannot control the sheet naming.|||Thanks for answering Mike.
Do you know if there are any plans to add this capability?
|||I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).
Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.
Reporting Servers - Export to Multiple tabs in Excel
I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.
Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.
For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).
|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||I would like to do this also. Is there any way to name each Sheet?
|||Unfortunately no, you cannot control the sheet naming.|||Thanks for answering Mike.
Do you know if there are any plans to add this capability?
|||I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).
Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.
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:
Reporting on two remote location databases
We have couple of SQL databases on different SQL Servers that are at
different remote locations in two different network domains. The
requirement is to generate reports by pulling in information from both
these databases.
What is the best way to go about it?
We have been asked to consider the linked server option, but we are
wondering what kind of impact will it have on performance? Is this a
efficient way to go about it? As far as the report ideally we would
like the reports on live data however if by linking the servers over
the internet causes performance issue we would like to research other
avenues.
Any ideas, suggestions or links in this subject will be greatly
appreciated.
Thanks
On Jun 27, 3:15 pm, "Will Alber" <j...@.crazy-pug.co.uk> wrote:
> As a lot of reports tend to present high-level (aggregated) overviews of
> data, linked servers sounds like a definite non-starter.
> Are you able to replicate the 'required subset' of tables from one or other
> (or both if neither is local) to the site at which the reports will be
> generated?
> Integration services, and replication are probably your best bets, unless
> the reports are extremely simple.
> "shub" <shubt...@.gmail.com> wrote in message
> news:1182974876.155463.320990@.q75g2000hsh.googlegr oups.com...
>
>
>
> - Show quoted text -
Thank you very much Will for reponding and you input.
I am assuming the reports are very simple, I mean it will probably
involve few simple joins. What kind of setup will be required to
connect to a SQL Server over the web or do we need a VPN connection to
make it secure and run faster?
Thanks
|||1) Check out linked server. I would recommend you encapsulate the remote
reports into sprocs if possible. Also, look to reduce the cross-server
joins and the amount of data returned.
2) Consider some form of encryption (VPN perhaps?) to ensure data security
if this is not an already secure network setup.
TheSQLGuru
President
Indicium Resources, Inc.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegr oups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>
different remote locations in two different network domains. The
requirement is to generate reports by pulling in information from both
these databases.
What is the best way to go about it?
We have been asked to consider the linked server option, but we are
wondering what kind of impact will it have on performance? Is this a
efficient way to go about it? As far as the report ideally we would
like the reports on live data however if by linking the servers over
the internet causes performance issue we would like to research other
avenues.
Any ideas, suggestions or links in this subject will be greatly
appreciated.
Thanks
On Jun 27, 3:15 pm, "Will Alber" <j...@.crazy-pug.co.uk> wrote:
> As a lot of reports tend to present high-level (aggregated) overviews of
> data, linked servers sounds like a definite non-starter.
> Are you able to replicate the 'required subset' of tables from one or other
> (or both if neither is local) to the site at which the reports will be
> generated?
> Integration services, and replication are probably your best bets, unless
> the reports are extremely simple.
> "shub" <shubt...@.gmail.com> wrote in message
> news:1182974876.155463.320990@.q75g2000hsh.googlegr oups.com...
>
>
>
> - Show quoted text -
Thank you very much Will for reponding and you input.
I am assuming the reports are very simple, I mean it will probably
involve few simple joins. What kind of setup will be required to
connect to a SQL Server over the web or do we need a VPN connection to
make it secure and run faster?
Thanks
|||1) Check out linked server. I would recommend you encapsulate the remote
reports into sprocs if possible. Also, look to reduce the cross-server
joins and the amount of data returned.
2) Consider some form of encryption (VPN perhaps?) to ensure data security
if this is not an already secure network setup.
TheSQLGuru
President
Indicium Resources, Inc.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegr oups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>
Reporting on two remote location databases
We have couple of SQL databases on different SQL Servers that are at
different remote locations in two different network domains. The
requirement is to generate reports by pulling in information from both
these databases.
What is the best way to go about it?
We have been asked to consider the linked server option, but we are
wondering what kind of impact will it have on performance? Is this a
efficient way to go about it? As far as the report ideally we would
like the reports on live data however if by linking the servers over
the internet causes performance issue we would like to research other
avenues.
Any ideas, suggestions or links in this subject will be greatly
appreciated.
ThanksAs a lot of reports tend to present high-level (aggregated) overviews of
data, linked servers sounds like a definite non-starter.
Are you able to replicate the 'required subset' of tables from one or other
(or both if neither is local) to the site at which the reports will be
generated?
Integration services, and replication are probably your best bets, unless
the reports are extremely simple.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>|||On Jun 27, 3:15 pm, "Will Alber" <j...@.crazy-pug.co.uk> wrote:
> As a lot of reports tend to present high-level (aggregated) overviews of
> data, linked servers sounds like a definite non-starter.
> Are you able to replicate the 'required subset' of tables from one or other
> (or both if neither is local) to the site at which the reports will be
> generated?
> Integration services, and replication are probably your best bets, unless
> the reports are extremely simple.
> "shub" <shubt...@.gmail.com> wrote in message
> news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
>
> > We have couple of SQL databases on different SQL Servers that are at
> > different remote locations in two different network domains. The
> > requirement is to generate reports by pulling in information from both
> > these databases.
> > What is the best way to go about it?
> > We have been asked to consider the linked server option, but we are
> > wondering what kind of impact will it have on performance? Is this a
> > efficient way to go about it? As far as the report ideally we would
> > like the reports on live data however if by linking the servers over
> > the internet causes performance issue we would like to research other
> > avenues.
> > Any ideas, suggestions or links in this subject will be greatly
> > appreciated.
> > Thanks- Hide quoted text -
> - Show quoted text -
Thank you very much Will for reponding and you input.
I am assuming the reports are very simple, I mean it will probably
involve few simple joins. What kind of setup will be required to
connect to a SQL Server over the web or do we need a VPN connection to
make it secure and run faster?
Thanks|||1) Check out linked server. I would recommend you encapsulate the remote
reports into sprocs if possible. Also, look to reduce the cross-server
joins and the amount of data returned.
2) Consider some form of encryption (VPN perhaps?) to ensure data security
if this is not an already secure network setup.
--
TheSQLGuru
President
Indicium Resources, Inc.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>
different remote locations in two different network domains. The
requirement is to generate reports by pulling in information from both
these databases.
What is the best way to go about it?
We have been asked to consider the linked server option, but we are
wondering what kind of impact will it have on performance? Is this a
efficient way to go about it? As far as the report ideally we would
like the reports on live data however if by linking the servers over
the internet causes performance issue we would like to research other
avenues.
Any ideas, suggestions or links in this subject will be greatly
appreciated.
ThanksAs a lot of reports tend to present high-level (aggregated) overviews of
data, linked servers sounds like a definite non-starter.
Are you able to replicate the 'required subset' of tables from one or other
(or both if neither is local) to the site at which the reports will be
generated?
Integration services, and replication are probably your best bets, unless
the reports are extremely simple.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>|||On Jun 27, 3:15 pm, "Will Alber" <j...@.crazy-pug.co.uk> wrote:
> As a lot of reports tend to present high-level (aggregated) overviews of
> data, linked servers sounds like a definite non-starter.
> Are you able to replicate the 'required subset' of tables from one or other
> (or both if neither is local) to the site at which the reports will be
> generated?
> Integration services, and replication are probably your best bets, unless
> the reports are extremely simple.
> "shub" <shubt...@.gmail.com> wrote in message
> news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
>
> > We have couple of SQL databases on different SQL Servers that are at
> > different remote locations in two different network domains. The
> > requirement is to generate reports by pulling in information from both
> > these databases.
> > What is the best way to go about it?
> > We have been asked to consider the linked server option, but we are
> > wondering what kind of impact will it have on performance? Is this a
> > efficient way to go about it? As far as the report ideally we would
> > like the reports on live data however if by linking the servers over
> > the internet causes performance issue we would like to research other
> > avenues.
> > Any ideas, suggestions or links in this subject will be greatly
> > appreciated.
> > Thanks- Hide quoted text -
> - Show quoted text -
Thank you very much Will for reponding and you input.
I am assuming the reports are very simple, I mean it will probably
involve few simple joins. What kind of setup will be required to
connect to a SQL Server over the web or do we need a VPN connection to
make it secure and run faster?
Thanks|||1) Check out linked server. I would recommend you encapsulate the remote
reports into sprocs if possible. Also, look to reduce the cross-server
joins and the amount of data returned.
2) Consider some form of encryption (VPN perhaps?) to ensure data security
if this is not an already secure network setup.
--
TheSQLGuru
President
Indicium Resources, Inc.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>
Reporting on two remote location databases
We have couple of SQL databases on different SQL Servers that are at
different remote locations in two different network domains. The
requirement is to generate reports by pulling in information from both
these databases.
What is the best way to go about it?
We have been asked to consider the linked server option, but we are
wondering what kind of impact will it have on performance? Is this a
efficient way to go about it? As far as the report ideally we would
like the reports on live data however if by linking the servers over
the internet causes performance issue we would like to research other
avenues.
Any ideas, suggestions or links in this subject will be greatly
appreciated.
ThanksAs a lot of reports tend to present high-level (aggregated) overviews of
data, linked servers sounds like a definite non-starter.
Are you able to replicate the 'required subset' of tables from one or other
(or both if neither is local) to the site at which the reports will be
generated?
Integration services, and replication are probably your best bets, unless
the reports are extremely simple.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>|||On Jun 27, 3:15 pm, "Will Alber" <j...@.crazy-pug.co.uk> wrote:
> As a lot of reports tend to present high-level (aggregated) overviews of
> data, linked servers sounds like a definite non-starter.
> Are you able to replicate the 'required subset' of tables from one or othe
r
> (or both if neither is local) to the site at which the reports will be
> generated?
> Integration services, and replication are probably your best bets, unless
> the reports are extremely simple.
> "shub" <shubt...@.gmail.com> wrote in message
> news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
>
>
>
>
>
> - Show quoted text -
Thank you very much Will for reponding and you input.
I am assuming the reports are very simple, I mean it will probably
involve few simple joins. What kind of setup will be required to
connect to a SQL Server over the web or do we need a VPN connection to
make it secure and run faster?
Thanks|||1) Check out linked server. I would recommend you encapsulate the remote
reports into sprocs if possible. Also, look to reduce the cross-server
joins and the amount of data returned.
2) Consider some form of encryption (VPN perhaps?) to ensure data security
if this is not an already secure network setup.
TheSQLGuru
President
Indicium Resources, Inc.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>
different remote locations in two different network domains. The
requirement is to generate reports by pulling in information from both
these databases.
What is the best way to go about it?
We have been asked to consider the linked server option, but we are
wondering what kind of impact will it have on performance? Is this a
efficient way to go about it? As far as the report ideally we would
like the reports on live data however if by linking the servers over
the internet causes performance issue we would like to research other
avenues.
Any ideas, suggestions or links in this subject will be greatly
appreciated.
ThanksAs a lot of reports tend to present high-level (aggregated) overviews of
data, linked servers sounds like a definite non-starter.
Are you able to replicate the 'required subset' of tables from one or other
(or both if neither is local) to the site at which the reports will be
generated?
Integration services, and replication are probably your best bets, unless
the reports are extremely simple.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>|||On Jun 27, 3:15 pm, "Will Alber" <j...@.crazy-pug.co.uk> wrote:
> As a lot of reports tend to present high-level (aggregated) overviews of
> data, linked servers sounds like a definite non-starter.
> Are you able to replicate the 'required subset' of tables from one or othe
r
> (or both if neither is local) to the site at which the reports will be
> generated?
> Integration services, and replication are probably your best bets, unless
> the reports are extremely simple.
> "shub" <shubt...@.gmail.com> wrote in message
> news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
>
>
>
>
>
> - Show quoted text -
Thank you very much Will for reponding and you input.
I am assuming the reports are very simple, I mean it will probably
involve few simple joins. What kind of setup will be required to
connect to a SQL Server over the web or do we need a VPN connection to
make it secure and run faster?
Thanks|||1) Check out linked server. I would recommend you encapsulate the remote
reports into sprocs if possible. Also, look to reduce the cross-server
joins and the amount of data returned.
2) Consider some form of encryption (VPN perhaps?) to ensure data security
if this is not an already secure network setup.
TheSQLGuru
President
Indicium Resources, Inc.
"shub" <shubtech@.gmail.com> wrote in message
news:1182974876.155463.320990@.q75g2000hsh.googlegroups.com...
> We have couple of SQL databases on different SQL Servers that are at
> different remote locations in two different network domains. The
> requirement is to generate reports by pulling in information from both
> these databases.
> What is the best way to go about it?
> We have been asked to consider the linked server option, but we are
> wondering what kind of impact will it have on performance? Is this a
> efficient way to go about it? As far as the report ideally we would
> like the reports on live data however if by linking the servers over
> the internet causes performance issue we would like to research other
> avenues.
> Any ideas, suggestions or links in this subject will be greatly
> appreciated.
> Thanks
>
Subscribe to:
Posts (Atom)