Cannot create a connection to data source

I am running SQL Server 2005, SP2 on a Windows Server 2003, SP1.
When I open a report in the Report Server I get the following error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
The ConnectionString property has not been initialized.
I am connecting to an Oracle database (using the Oracle client).
I have run into the problem before and have always been able to fix it by
giving the Web Service Identity, ASP.NET Service Account read/execute
permissions on the Oracle driver folder. This is not fixing the issue in
this case. The ASP.NET Service Account that I see in the Reporting Services
Configuration Manager is "NT Authority\Network Service". When I am adding
permissions to the security of the Oracle driver folder, I don't find an
exact match for this user (NT Authority\Network Service), I only find NETWORK
SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
folder. But no luck.
Any suggestions?
Thank you.
--
LaurieTCan you create a read-only user on the Oracle side and then enter those
credentials in the report connection?
"LaurieT" wrote:
> I am running SQL Server 2005, SP2 on a Windows Server 2003, SP1.
> When I open a report in the Report Server I get the following error:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
> The ConnectionString property has not been initialized.
> I am connecting to an Oracle database (using the Oracle client).
> I have run into the problem before and have always been able to fix it by
> giving the Web Service Identity, ASP.NET Service Account read/execute
> permissions on the Oracle driver folder. This is not fixing the issue in
> this case. The ASP.NET Service Account that I see in the Reporting Services
> Configuration Manager is "NT Authority\Network Service". When I am adding
> permissions to the security of the Oracle driver folder, I don't find an
> exact match for this user (NT Authority\Network Service), I only find NETWORK
> SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
> folder. But no luck.
> Any suggestions?
> Thank you.
> --
> LaurieT|||The issue is not with accessing the report data in Oracle (this works fine in
the business intelligence development studio, I can preview the reports here
with no issue) ... it is just with getting the Oracle client to run. When I
try to run reports through the Report Manager, I believe that Reporting
Services uses the Web Service Identity account to access and run the Oracle
client and in my case, it does not have the correct permissions to access and
run the client ... but I can't figure out how to change it.
--
LaurieT
"lonnye" wrote:
> Can you create a read-only user on the Oracle side and then enter those
> credentials in the report connection?
> "LaurieT" wrote:
> > I am running SQL Server 2005, SP2 on a Windows Server 2003, SP1.
> >
> > When I open a report in the Report Server I get the following error:
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
> > The ConnectionString property has not been initialized.
> >
> > I am connecting to an Oracle database (using the Oracle client).
> >
> > I have run into the problem before and have always been able to fix it by
> > giving the Web Service Identity, ASP.NET Service Account read/execute
> > permissions on the Oracle driver folder. This is not fixing the issue in
> > this case. The ASP.NET Service Account that I see in the Reporting Services
> > Configuration Manager is "NT Authority\Network Service". When I am adding
> > permissions to the security of the Oracle driver folder, I don't find an
> > exact match for this user (NT Authority\Network Service), I only find NETWORK
> > SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
> > folder. But no luck.
> >
> > Any suggestions?
> >
> > Thank you.
> > --
> > LaurieT|||You can change the service accounts by using the Reporting Services
Configuration Tool... Here is a link to more info on how to do this:
http://technet.microsoft.com/en-us/library/bb326419.aspx
--
~lb
"LaurieT" wrote:
> The issue is not with accessing the report data in Oracle (this works fine in
> the business intelligence development studio, I can preview the reports here
> with no issue) ... it is just with getting the Oracle client to run. When I
> try to run reports through the Report Manager, I believe that Reporting
> Services uses the Web Service Identity account to access and run the Oracle
> client and in my case, it does not have the correct permissions to access and
> run the client ... but I can't figure out how to change it.
> --
> LaurieT
>
> "lonnye" wrote:
> > Can you create a read-only user on the Oracle side and then enter those
> > credentials in the report connection?
> >
> > "LaurieT" wrote:
> >
> > > I am running SQL Server 2005, SP2 on a Windows Server 2003, SP1.
> > >
> > > When I open a report in the Report Server I get the following error:
> > > An error has occurred during report processing. (rsProcessingAborted)
> > > Cannot create a connection to data source 'ASCCSP'. (rsErrorOpeningConnection)
> > > The ConnectionString property has not been initialized.
> > >
> > > I am connecting to an Oracle database (using the Oracle client).
> > >
> > > I have run into the problem before and have always been able to fix it by
> > > giving the Web Service Identity, ASP.NET Service Account read/execute
> > > permissions on the Oracle driver folder. This is not fixing the issue in
> > > this case. The ASP.NET Service Account that I see in the Reporting Services
> > > Configuration Manager is "NT Authority\Network Service". When I am adding
> > > permissions to the security of the Oracle driver folder, I don't find an
> > > exact match for this user (NT Authority\Network Service), I only find NETWORK
> > > SERVICE. I gave NETWORK SERVICE read/execute rights to the Oracle client
> > > folder. But no luck.
> > >
> > > Any suggestions?
> > >
> > > Thank you.
> > > --
> > > LaurieT