Reporting Services may not be able to run reports against Oracle databases (870668)
The information in this article applies to:
- Microsoft SQL Server 2000 Reporting Services
- Microsoft SQL Server 2005 Reporting Services
SYMPTOMSIf you are using Microsoft SQL Server Reporting Services,
Reporting Services subscriptions may not be able to run any reports against
Oracle databases.
You may receive a System.DllNotFoundException
exception.CAUSEThis problem occurs because some Oracle files and
directories must have additional security settings so that reports can run
against Oracle databases.WORKAROUNDTo work around this problem, add permissions for the NETWORK
SERVICE security principal to the Oracle\ Oracle
version\bin directory and to the Oracle\ Oracle
version\network\admin directory. To do this, follow these steps. - Locate the Oracle\Oracle
version\bin directory, right-click the directory, and then click
Properties.
- Click the Security tab, and then click
Add.
- Under Enter object names to select, type
network service, and then click
OK.
- In the Group or user names box, click
NETWORK SERVICE.
- Under Permissions for Network Service,
click to select the Read & Execute check box.
- Click Advanced.
- Click the Allow inheritable permissions from the
parent to propagate to this object and all child objects. Include these with
the entries explicitly defined here box, and then click
OK.
- Click OK.
- Locate the Oracle\Oracle
version\network\admin directory, right-click the directory, and
then click Properties.
- Repeat steps 2 through 8.
- Click Start, point to
Administrative Tools, and then click
Services.
- Locate the ReportServer service.
- Right-click the ReportServer service, and then click
Restart.
For
Reporting Services 2005, the issue not only affects the execution of
subscriptions through the Reporting Services Windows Service, but also affects
the regular execution of reports through the Reporting Services Web Service.
Therefore, the account for the Reporting Services Windows Service and the
Reporting Services Web Service must have read & execute permissions on the Oracle installation directories from the previous procedure.
Note To verify the configured account for the Reporting Services Web
Service, you can open the RSReportServer.config file. You will find
informaiton that is similar to the following: <WebServiceAccount>NT
Authority\NetworkService</WebServiceAccount> STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
Modification Type: | Major | Last Reviewed: | 11/22/2005 |
---|
Keywords: | kbprb KB870668 kbAudDeveloper |
---|
|