Report ownership

I have 2 reports that run against a Oracle database. They run fine on my
development PC. Had huge problems getting them to run on the Reports Manager
scheduled. We finally got one working, after days of beating on it, it was
uploaded by the senior DBA (so owned by his userid also), the connection file
was also uploaded by the senior DBA, this report runs fine. The other,
report gets an error saying:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'cdbprod'.
(rsErrorOpeningConnection) Get Online Help
Error while trying to retrieve text for error ORA-12154
--
www.duanelawrence.comThe ReportServer Windows service is responsible for executing scheduled
reports. It will be doing this under the specified service user account
(which is typically a low-privileged user account). You may run into file
permission issues related to tnsnames.ora or other Oracle client dlls.
Please verify based on KB 870668 that the service account has sufficient
permissions:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> I have 2 reports that run against a Oracle database. They run fine on my
> development PC. Had huge problems getting them to run on the Reports
Manager
> scheduled. We finally got one working, after days of beating on it, it
was
> uploaded by the senior DBA (so owned by his userid also), the connection
file
> was also uploaded by the senior DBA, this report runs fine. The other,
> report gets an error saying:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'cdbprod'.
> (rsErrorOpeningConnection) Get Online Help
> Error while trying to retrieve text for error ORA-12154
> --
> www.duanelawrence.com
>|||Thanks Robert
I wish to add some information that I did not say in the first post. We are
using a
"shared data source" with "Credentials stored securely in the report server
" set to on. You see, we are scheduling the reports to run in the Reports
Manager (you can not create a schedule until you use "Credentials stored
securely in the report server " option). When you look at the Reports
Manager in a web browser and click on "Show Details", you will see a
"Modified By" column. The user id in the modified by column has to have read
and execute privileges to the 2 named directories in the article.
I have read many articles saying exactly what you say below, but I have
proof that it is not true. I added my user id to the 2 directories named in
the article you listed and the reports work fine. The user id in the "shared
data source" under "Credentials stored securely in the report server " only
has the privileges created by the Oracle DBA, no network privaleges at all.
Duane
"Robert Bruckner [MSFT]" wrote:
> The ReportServer Windows service is responsible for executing scheduled
> reports. It will be doing this under the specified service user account
> (which is typically a low-privileged user account). You may run into file
> permission issues related to tnsnames.ora or other Oracle client dlls.
> Please verify based on KB 870668 that the service account has sufficient
> permissions:
> http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
> message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > I have 2 reports that run against a Oracle database. They run fine on my
> > development PC. Had huge problems getting them to run on the Reports
> Manager
> > scheduled. We finally got one working, after days of beating on it, it
> was
> > uploaded by the senior DBA (so owned by his userid also), the connection
> file
> > was also uploaded by the senior DBA, this report runs fine. The other,
> > report gets an error saying:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'cdbprod'.
> > (rsErrorOpeningConnection) Get Online Help
> > Error while trying to retrieve text for error ORA-12154
> >
> > --
> >
> > www.duanelawrence.com
> >
> >
>
>|||More supporting evidence
http://www.sqlmonster.com/Uwe/ForumPost.aspx?article=sql-server-reporting:6675:77E633A0-1B40-4766-936D-73B640F3DBF8%40microsoft.com
I consider this closed.
Duane
"duanelawrence.com" wrote:
> Thanks Robert
> I wish to add some information that I did not say in the first post. We are
> using a
> "shared data source" with "Credentials stored securely in the report server
> " set to on. You see, we are scheduling the reports to run in the Reports
> Manager (you can not create a schedule until you use "Credentials stored
> securely in the report server " option). When you look at the Reports
> Manager in a web browser and click on "Show Details", you will see a
> "Modified By" column. The user id in the modified by column has to have read
> and execute privileges to the 2 named directories in the article.
> I have read many articles saying exactly what you say below, but I have
> proof that it is not true. I added my user id to the 2 directories named in
> the article you listed and the reports work fine. The user id in the "shared
> data source" under "Credentials stored securely in the report server " only
> has the privileges created by the Oracle DBA, no network privaleges at all.
> Duane
>
>
> "Robert Bruckner [MSFT]" wrote:
> > The ReportServer Windows service is responsible for executing scheduled
> > reports. It will be doing this under the specified service user account
> > (which is typically a low-privileged user account). You may run into file
> > permission issues related to tnsnames.ora or other Oracle client dlls.
> > Please verify based on KB 870668 that the service account has sufficient
> > permissions:
> > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
> > message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > > I have 2 reports that run against a Oracle database. They run fine on my
> > > development PC. Had huge problems getting them to run on the Reports
> > Manager
> > > scheduled. We finally got one working, after days of beating on it, it
> > was
> > > uploaded by the senior DBA (so owned by his userid also), the connection
> > file
> > > was also uploaded by the senior DBA, this report runs fine. The other,
> > > report gets an error saying:
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'cdbprod'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > Error while trying to retrieve text for error ORA-12154
> > >
> > > --
> > >
> > > www.duanelawrence.com
> > >
> > >
> >
> >
> >|||I'm not sure I understand your last posting. Does it work now for the shared
data source in your case?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote in
message news:5AEAE806-5968-4D04-A55C-8F5C55C432E5@.microsoft.com...
> More supporting evidence
>
http://www.sqlmonster.com/Uwe/ForumPost.aspx?article=sql-server-reporting:6675:77E633A0-1B40-4766-936D-73B640F3DBF8%40microsoft.com
> I consider this closed.
> Duane
>
>
> "duanelawrence.com" wrote:
> > Thanks Robert
> >
> > I wish to add some information that I did not say in the first post. We
are
> > using a
> > "shared data source" with "Credentials stored securely in the report
server
> > " set to on. You see, we are scheduling the reports to run in the
Reports
> > Manager (you can not create a schedule until you use "Credentials stored
> > securely in the report server " option). When you look at the Reports
> > Manager in a web browser and click on "Show Details", you will see a
> > "Modified By" column. The user id in the modified by column has to have
read
> > and execute privileges to the 2 named directories in the article.
> >
> > I have read many articles saying exactly what you say below, but I have
> > proof that it is not true. I added my user id to the 2 directories
named in
> > the article you listed and the reports work fine. The user id in the
"shared
> > data source" under "Credentials stored securely in the report server "
only
> > has the privileges created by the Oracle DBA, no network privaleges at
all.
> >
> > Duane
> >
> >
> >
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > The ReportServer Windows service is responsible for executing
scheduled
> > > reports. It will be doing this under the specified service user
account
> > > (which is typically a low-privileged user account). You may run into
file
> > > permission issues related to tnsnames.ora or other Oracle client dlls.
> > > Please verify based on KB 870668 that the service account has
sufficient
> > > permissions:
> > > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B870668
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > >
> > > "duanelawrence.com" <duanelawrencecom@.discussions.microsoft.com> wrote
in
> > > message news:9DA7837D-D8D8-4300-A32E-8AEA0127ACA7@.microsoft.com...
> > > > I have 2 reports that run against a Oracle database. They run fine
on my
> > > > development PC. Had huge problems getting them to run on the
Reports
> > > Manager
> > > > scheduled. We finally got one working, after days of beating on it,
it
> > > was
> > > > uploaded by the senior DBA (so owned by his userid also), the
connection
> > > file
> > > > was also uploaded by the senior DBA, this report runs fine. The
other,
> > > > report gets an error saying:
> > > >
> > > > An error has occurred during report processing.
(rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot create a connection to data source 'cdbprod'.
> > > > (rsErrorOpeningConnection) Get Online Help
> > > > Error while trying to retrieve text for error ORA-12154
> > > >
> > > > --
> > > >
> > > > www.duanelawrence.com
> > > >
> > > >
> > >
> > >
> > >