Generating Reports Error, dependent on local groups?

Hi,
I finished creating my reports and have had an issue with generating the
reports on http://localhost/reports. When I login to
http://localhost/reports with a user that is part of the Local Administrators
Group the reports run perfectly correct. But when I login with a user that
is not part of the Local Administrators Group I get the Reporting Services
Error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'OVSDPROD'.
(rsErrorOpeningConnection) Get Online Help
ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
The user that I am logged in with has the same exact item-level and
system-level roles as the BUILTIN\Administrators and can navigate throughout
the site to get to the reports but when its time to actually generate the
reports I get the error above.
MikeThis is a problem of the user connecting to Oracle, not to Report Server. The
error is coming form ODBC.
Test this by reconfiguring the data source and storing credentials on the
report server so that the credentials you use are the same as those being
used by the other person.
HTH
Charles Kangai, MCT, MCDBA
"mtam79" wrote:
> Hi,
> I finished creating my reports and have had an issue with generating the
> reports on http://localhost/reports. When I login to
> http://localhost/reports with a user that is part of the Local Administrators
> Group the reports run perfectly correct. But when I login with a user that
> is not part of the Local Administrators Group I get the Reporting Services
> Error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'OVSDPROD'.
> (rsErrorOpeningConnection) Get Online Help
> ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> SQLSetConnectAttr failed
> The user that I am logged in with has the same exact item-level and
> system-level roles as the BUILTIN\Administrators and can navigate throughout
> the site to get to the reports but when its time to actually generate the
> reports I get the error above.
> Mike|||The data source is configured with "Credentials stored securely in the report
server"...
Even though the error states that this is an ODBC issue, it confuses me
since I am able to generate reports with users that are part of the Local
Administrator Group, but anyone outside of that group can not Generate
Reports. If everyone was having problems generating reports then I would
definitely see how it is an ODBC issue.
Any other suggestions?
Thanks,
Mike
"Charles Kangai" wrote:
> This is a problem of the user connecting to Oracle, not to Report Server. The
> error is coming form ODBC.
> Test this by reconfiguring the data source and storing credentials on the
> report server so that the credentials you use are the same as those being
> used by the other person.
> HTH
> Charles Kangai, MCT, MCDBA
> "mtam79" wrote:
> > Hi,
> >
> > I finished creating my reports and have had an issue with generating the
> > reports on http://localhost/reports. When I login to
> > http://localhost/reports with a user that is part of the Local Administrators
> > Group the reports run perfectly correct. But when I login with a user that
> > is not part of the Local Administrators Group I get the Reporting Services
> > Error:
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'OVSDPROD'.
> > (rsErrorOpeningConnection) Get Online Help
> > ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> > error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> > SQLSetConnectAttr failed
> >
> > The user that I am logged in with has the same exact item-level and
> > system-level roles as the BUILTIN\Administrators and can navigate throughout
> > the site to get to the reports but when its time to actually generate the
> > reports I get the error above.
> >
> > Mike|||I figured out my problem had to do with the security permissions that were
assigned to the folder where my tnsnames.ora file was located. I needed to
set permissions for Everyone to be able to read that folder so they can
access the file and therefore run the reports.
"mtam79" wrote:
> The data source is configured with "Credentials stored securely in the report
> server"...
> Even though the error states that this is an ODBC issue, it confuses me
> since I am able to generate reports with users that are part of the Local
> Administrator Group, but anyone outside of that group can not Generate
> Reports. If everyone was having problems generating reports then I would
> definitely see how it is an ODBC issue.
> Any other suggestions?
> Thanks,
> Mike
> "Charles Kangai" wrote:
> > This is a problem of the user connecting to Oracle, not to Report Server. The
> > error is coming form ODBC.
> >
> > Test this by reconfiguring the data source and storing credentials on the
> > report server so that the credentials you use are the same as those being
> > used by the other person.
> >
> > HTH
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "mtam79" wrote:
> >
> > > Hi,
> > >
> > > I finished creating my reports and have had an issue with generating the
> > > reports on http://localhost/reports. When I login to
> > > http://localhost/reports with a user that is part of the Local Administrators
> > > Group the reports run perfectly correct. But when I login with a user that
> > > is not part of the Local Administrators Group I get the Reporting Services
> > > Error:
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'OVSDPROD'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text for
> > > error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
> > > SQLSetConnectAttr failed
> > >
> > > The user that I am logged in with has the same exact item-level and
> > > system-level roles as the BUILTIN\Administrators and can navigate throughout
> > > the site to get to the reports but when its time to actually generate the
> > > reports I get the error above.
> > >
> > > Mike|||Please also check this KB article, because you may run into the same
security permission issues when trying to setup subscriptions on these
reports: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"mtam79" <mtam79@.discussions.microsoft.com> wrote in message
news:E1E6AF79-39B8-4E1B-AFAA-69A00E5C4B19@.microsoft.com...
> I figured out my problem had to do with the security permissions that were
> assigned to the folder where my tnsnames.ora file was located. I needed
to
> set permissions for Everyone to be able to read that folder so they can
> access the file and therefore run the reports.
>
> "mtam79" wrote:
> > The data source is configured with "Credentials stored securely in the
report
> > server"...
> >
> > Even though the error states that this is an ODBC issue, it confuses me
> > since I am able to generate reports with users that are part of the
Local
> > Administrator Group, but anyone outside of that group can not Generate
> > Reports. If everyone was having problems generating reports then I
would
> > definitely see how it is an ODBC issue.
> >
> > Any other suggestions?
> >
> > Thanks,
> > Mike
> >
> > "Charles Kangai" wrote:
> >
> > > This is a problem of the user connecting to Oracle, not to Report
Server. The
> > > error is coming form ODBC.
> > >
> > > Test this by reconfiguring the data source and storing credentials on
the
> > > report server so that the credentials you use are the same as those
being
> > > used by the other person.
> > >
> > > HTH
> > >
> > > Charles Kangai, MCT, MCDBA
> > >
> > > "mtam79" wrote:
> > >
> > > > Hi,
> > > >
> > > > I finished creating my reports and have had an issue with generating
the
> > > > reports on http://localhost/reports. When I login to
> > > > http://localhost/reports with a user that is part of the Local
Administrators
> > > > Group the reports run perfectly correct. But when I login with a
user that
> > > > is not part of the Local Administrators Group I get the Reporting
Services
> > > > Error:
> > > >
> > > > An error has occurred during report processing.
(rsProcessingAborted) Get
> > > > Online Help
> > > > Cannot create a connection to data source 'OVSDPROD'.
> > > > (rsErrorOpeningConnection) Get Online Help
> > > > ERROR [08004] [Oracle][ODBC][Ora]Error while trying to retrieve text
for
> > > > error ORA-12154 ERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's
> > > > SQLSetConnectAttr failed
> > > >
> > > > The user that I am logged in with has the same exact item-level and
> > > > system-level roles as the BUILTIN\Administrators and can navigate
throughout
> > > > the site to get to the reports but when its time to actually
generate the
> > > > reports I get the error above.
> > > >
> > > > Mike