IIS 5.0 isolation mode

I have a Reporting Services setup on a web server on Windows 2003. It is
working fine. There is a web application that is having some problems and we
have set the web server to IIS 5.0 isolation mode. Will Reporting Services
run under 5.0 isolation mode?
At first it looks like a rights issue and giving the ASPNET account the same
rights as the NETWORK SERVICE account got us past the original access denied
type errors.
However now we are getting the error: The report server cannot decrypt the
symmetric key used to access sensitive or encrypted data in a report server
database. You must either restore a backup key or delete all encrypted
content and then restart the service.
What needs to be done to run under 5.0 isolation mode?
--
LehrSJHello,
You may want to try the following steps:
1. open C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file.
Search for this tag, <InstallationID> and take the GUID (For example, the
GUID for me is {93850a3c-a856-4ce9-af25-6b3cdaa98dd8})
2. Use the GUID that we got before and try to remove the keys in the table
like this
RSKEYMGMT -R "{<guid>}"
3. Then run
RSACTIVATE -C "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" > (make sure the path is the
one you installed Reporting Services)
If the issue persists, please make sure ASP.NET account has the proper
permission on the SQL server/Reprotserver databases.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Thread-Topic: IIS 5.0 isolation mode
| thread-index: AcVm2ZoBIp9L/GQKRtOvDPnUBn1T/g==| X-WBNR-Posting-Host: 70.118.121.7
| From: =?Utf-8?B?TGVoclNK?= <lehr524@.noemail.nospam>
| Subject: IIS 5.0 isolation mode
| Date: Wed, 1 Jun 2005 11:42:02 -0700
| Lines: 17
| Message-ID: <0021FD03-66E4-44D5-9D54-F102D1F6727F@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45125
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a Reporting Services setup on a web server on Windows 2003. It is
| working fine. There is a web application that is having some problems
and we
| have set the web server to IIS 5.0 isolation mode. Will Reporting
Services
| run under 5.0 isolation mode?
|
| At first it looks like a rights issue and giving the ASPNET account the
same
| rights as the NETWORK SERVICE account got us past the original access
denied
| type errors.
|
| However now we are getting the error: The report server cannot decrypt
the
| symmetric key used to access sensitive or encrypted data in a report
server
| database. You must either restore a backup key or delete all encrypted
| content and then restart the service.
|
| What needs to be done to run under 5.0 isolation mode?
| --
| LehrSJ
|