Installation error

Hi,
I've been trying to get Reporting Services to activate but I keep
getting an error. The error is
The Report Server Web service has not generated a public key.
I am trying to install RS on a W2K SP4 Advanced Server with SQL Server
2K SP3. I am using a named instance (TTBITEST2K\JAI).
The attached WebService log file shows no error. I've tried deleting
and recreating the keys many times. I've installed MDAC 2.7 SP1
Refresh. I use a Windows Domain Account that is a W2K local
Adminstrator and SS2K Systems Administrator.
I'm at a loss as to what to try next.
I'm open to suggestions.
Regards,
Rick Sjogren
<<<<<<<<<<<<<<<<<< ReportServerService__10_08_2004_13_22_24.log
>>>>>>
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>AUS Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__10_08_2004_13_22_24.log</Path>
<SystemName>TTBITEST2K</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration
file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing IsSchedulingService to 'True' as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing IsNotificationService to 'True' as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration
file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration
file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified
in Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as
specified in Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in
Configuration file.
ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration
file.
ReportingServicesService!resourceutilities!1018!8/10/2004-13:22:24:: i
INFO: Running on 4 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!1018!8/10/2004-13:22:24:: i
INFO: Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: v
VERBOSE: Hooking up AppDomain handler
ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 45455 seconds
ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!f80!8/10/2004-13:22:25:: i INFO:
Initializing crypto as user: TOLL\sdSQL
ReportingServicesService!library!f80!8/10/2004-13:22:25:: v VERBOSE:
Transaction begin.
ReportingServicesService!crypto!f80!8/10/2004-13:22:25:: i INFO:
Exporting public key
ReportingServicesService!crypto!f80!8/10/2004-13:22:27:: i INFO: NT
Service self activating
ReportingServicesService!library!f80!8/10/2004-13:22:27:: v VERBOSE:
Transaction commit.
ReportingServicesService!library!f80!8/10/2004-13:22:27:: v VERBOSE:
Transaction begin.
ReportingServicesService!library!f80!8/10/2004-13:22:27:: v VERBOSE:
Transaction commit.
ReportingServicesService!dbpolling!f80!10/08/2004-13:22:27::
EventPolling polling service started
ReportingServicesService!dbpolling!f80!10/08/2004-13:22:27::
NotificationPolling polling service started
ReportingServicesService!dbpolling!f80!10/08/2004-13:22:27::
SchedulePolling polling service started
ReportingServicesService!dbpolling!cd4!8/10/2004-13:22:27::
EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!f7c!8/10/2004-13:22:27::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!738!8/10/2004-13:22:27:: Polling
startedRick Sjogren wrote:
> I've been trying to get Reporting Services to activate but I keep
> getting an error. The error is
> The Report Server Web service has not generated a public key.
Rick, google pulls up a bunch of hits on that error string. Here are a
couple of them:
http://groups.google.com/groups?q=%22generated+a+public+key%22&hl=en&lr=&group=microsoft.public.sqlserver.reportingsvcs&selm=dbf9e5e6.0406241253.22fdae9f%40posting.google.com&rnum=6
http://groups.google.com/groups?hl=en&lr=&threadm=1784a01c418d2%249dc1a950%24a401280a%40phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26q%3D%2522generated%2Ba%2Bpublic%2Bkey%2522%26btnG%3DSearch%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.reportingsvcs
Of course, if you've already gone through all of the google hits, this
doesn't provide much help! Seems like this may be caused by a number of
different configuration issues.
-BA|||Rick,
Does the report server windows service run after you setup? Is there
an error log in it?
When you try to access the report server web service in IE or you
browser of choice, what is the error message you get (turn nice error
messages off)?
-Lukasz
Rick Sjogren wrote:
> Hi,
> I've been trying to get Reporting Services to activate but I keep
> getting an error. The error is
> The Report Server Web service has not generated a public key.
> I am trying to install RS on a W2K SP4 Advanced Server with SQL
Server
> 2K SP3. I am using a named instance (TTBITEST2K\JAI).
> The attached WebService log file shows no error. I've tried deleting
> and recreating the keys many times. I've installed MDAC 2.7 SP1
> Refresh. I use a Windows Domain Account that is a W2K local
> Adminstrator and SS2K Systems Administrator.
> I'm at a loss as to what to try next.
> I'm open to suggestions.
> Regards,
> Rick Sjogren
> <<<<<<<<<<<<<<<<<< ReportServerService__10_08_2004_13_22_24.log
> >>>>>>
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>AUS Eastern Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__10_08_2004_13_22_24.log</Path>
> <SystemName>TTBITEST2K</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing ConnectionType to '1' as specified in Configuration
> file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in
Configuration
> file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified
> in Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as
> specified in Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in
> Configuration file.
> ReportingServicesService!library!1018!8/10/2004-13:22:24:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in
Configuration
> file.
> ReportingServicesService!resourceutilities!1018!8/10/2004-13:22:24::
i
> INFO: Running on 4 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!1018!8/10/2004-13:22:24::
i
> INFO: Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: v
> VERBOSE: Hooking up AppDomain handler
> ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i
INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i
INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i
INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i
INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 45455 seconds
> ReportingServicesService!runningjobs!1018!8/10/2004-13:22:24:: i
INFO:
> Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!f80!8/10/2004-13:22:25:: i INFO:
> Initializing crypto as user: TOLL\sdSQL
> ReportingServicesService!library!f80!8/10/2004-13:22:25:: v VERBOSE:
> Transaction begin.
> ReportingServicesService!crypto!f80!8/10/2004-13:22:25:: i INFO:
> Exporting public key
> ReportingServicesService!crypto!f80!8/10/2004-13:22:27:: i INFO: NT
> Service self activating
> ReportingServicesService!library!f80!8/10/2004-13:22:27:: v VERBOSE:
> Transaction commit.
> ReportingServicesService!library!f80!8/10/2004-13:22:27:: v VERBOSE:
> Transaction begin.
> ReportingServicesService!library!f80!8/10/2004-13:22:27:: v VERBOSE:
> Transaction commit.
> ReportingServicesService!dbpolling!f80!10/08/2004-13:22:27::
> EventPolling polling service started
> ReportingServicesService!dbpolling!f80!10/08/2004-13:22:27::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!f80!10/08/2004-13:22:27::
> SchedulePolling polling service started
> ReportingServicesService!dbpolling!cd4!8/10/2004-13:22:27::
> EventPolling heartbeat thread started.
> ReportingServicesService!dbpolling!f7c!8/10/2004-13:22:27::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!738!8/10/2004-13:22:27:: Polling
> started|||lukaszp@.gmail.com wrote in message news:<1097215597.146796.209040@.c13g2000cwb.googlegroups.com>...
> Rick,
> Does the report server windows service run after you setup? Is there
> an error log in it?
> When you try to access the report server web service in IE or you
> browser of choice, what is the error message you get (turn nice error
> messages off)?
> -Lukasz
>
Hi Lukasz,
The Report Server Service does run and I don't get an error log - at
least as far as I can tell.
When I access the Report Server via IE, I get the following (with
Friendly HTTP messages turned off):
-2147467259 (0x80004005)
And that's it!
With Friendly HTTP messages turned on, I get the following:
HTTP 500 - Internal server error
It appears that the part of the Service that generates keys can do it,
but the bit that reads it isn't authorised!
I'm stumped!
Regards,
Rick|||Brian Almond <pythonista@.sbcglobal.net> wrote in message news:<uVgQSOPrEHA.2596@.TK2MSFTNGP12.phx.gbl>...
> Rick Sjogren wrote:
> > I've been trying to get Reporting Services to activate but I keep
> > getting an error. The error is
> >
> > The Report Server Web service has not generated a public key.
> Rick, google pulls up a bunch of hits on that error string. Here are a
> couple of them:
> http://groups.google.com/groups?q=%22generated+a+public+key%22&hl=en&lr=&group=microsoft.public.sqlserver.reportingsvcs&selm=dbf9e5e6.0406241253.22fdae9f%40posting.google.com&rnum=6
> http://groups.google.com/groups?hl=en&lr=&threadm=1784a01c418d2%249dc1a950%24a401280a%40phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26q%3D%2522generated%2Ba%2Bpublic%2Bkey%2522%26btnG%3DSearch%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.reportingsvcs
> Of course, if you've already gone through all of the google hits, this
> doesn't provide much help! Seems like this may be caused by a number of
> different configuration issues.
> -BA
Hi Brian,
Thanks for the links but I'd already tried them. No dice!
Do you have any other suggestions? I'm stumped!
Regards,
Rick