manual activation of RS -- sql server reporting services

sql server reporting services : manual activation of RS

jez
2/4/2005 1:11:13 PM

Hi

I'm having problems manually activating the report server after installation
on Windows 2000 server sp4 , SQL Server 2000 sp3 and Reporting Services sp1.

I have followed other fixes I have seen but still get the same error "The
Report Server Web service has not generated a public key"

I have done the following:

rskeymgmt -d

rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t

but still get the same error. Can anyone help?

Thanks,

Jez

v-mingqc NO[at]SPAM online.microsoft.com
2/5/2005 6:30:19 AM

Hi jez,

From your descriptions, I understood that you encounter error message "The
Report Server Web service has not generated a public key" during your
Reporting Services installation. Have I understood you? Correct me if I was
wrong.

Based on my experience, RSActivate is only used for setting up web farms.
As the error states, the problem is most likely an unrelated failure when
the web service starts. You can get a more detailed description of the
underlying problem by navigating to http://localhost/reportserver.

Please give full permissions to IUSR, IWAM, and ASPNET users on the
following key using regedt32 and reinstalled SQL Server Reporting Services

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application

Let me know whether it works or you need more detailed steps about how to
perform these steps.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

jez
2/6/2005 10:22:56 PM

Cheng,

Yes you have understood this correctly.

In the past I have successfully install RS on XP but now I'm trying to
install it on Windows 2000 Server and I run into this error. I have tried
to follow your advice but have observed the following:

1) When I try and access the page reportserver I get "HTTP 500 - Internal
Server error". I then checked that the configuration pointed to version
1.1.4322 of the .NET Framework which it did.

Then I looked at the Event Viewer and the only messages in there relating to
Reporting Services where entries every 12 hours by the "Schedule and
Delivery" source recording "The ReportServer service has been activated"

2) regedit - On Windows 2000 Server I do not get a "permissions" option when
I right click the registry key as you would on XP. I have checked under the
"Local User and Groups" heading in the Computer Management console and noted
that these users belonging to the following groups:

IUSR - Guest

IWAM - Guest

ASPNET - Administrators; Guest; VS Developers; Web Applications

I then added IUSR and IWAM to the administrators group and reinstalled RS
but still get the same error.

Can you suggest what I should do next?

Thanks,

Jez

[quoted text, click to view]

v-mingqc NO[at]SPAM online.microsoft.com
2/7/2005 12:52:32 PM

Hi jez,

Expand the Registery Key to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application

Right click "Application" in the Left Panel,
Click "Permissions..."
Add IUSR, IWAM and ASPNET full permissions explicitly

Let me know whether it works.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

jez
2/7/2005 1:24:45 PM

Cheng,

To administer the server I'm using NetMeeting or Terminal Services and
logging on as the local Administrator but when I right click "Application" I
do not see a Permissions option. The only choices I have are:
Collapse
New
Find
Delete
Rename
Copy Key Name

Are you sure that this option is avaible under Windows 2000 Server?

If it is then it must be the properties of NetMeeting or Terminal Services
but I just don't understand that?

Thanks,
Jez

[quoted text, click to view]

v-mingqc NO[at]SPAM online.microsoft.com
2/8/2005 6:11:24 AM

Hi Jez,

Oops, I didn't realize that you are using Windows 2000

So, please follow the steps below to open Regstry Editor
- Start -> Run -> "regedt32"
- Go to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
- Click Menu "Security" -> "Permissions"

Let me know whether it works this time.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

jez
2/8/2005 9:42:10 AM

Cheng,

User error on my behalf as I was using regedit and not regedt32!!! Have set
the permissions and reinstalled RS but still get the same error on
installation that reporting services requires manual activation.

Any ideas where to look next?

Many thanks for your help,
Jez

[quoted text, click to view]

jez
2/10/2005 8:54:23 AM

Cheng,

In the end I reinstalled the .Net 1.1 framework and then reinstalled RS and
it now all works!

Thanks for you help,

Jez

[quoted text, click to view]

v-mingqc NO[at]SPAM online.microsoft.com
2/10/2005 12:24:04 PM

Hi Jze,

Thanks for your kindly letting me know about this, it's great to hear that
it!

Based on my experience, setting the permission will do resolve this issue,
anyway, it's great to hear that it works now. If you have any questions or
concerns next time, don't hesitate to let me know. We are always here to be
of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn