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

Generating Report Error, Local Administrator Group

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.
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.
I am using ODBC Drivers from Oracle.....
Thanks,
MikeI 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:
> 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.
> 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.
> I am using ODBC Drivers from Oracle.....
> Thanks,
> Mike|||I
"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.
> 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.
> I am using ODBC Drivers from Oracle.....
> Thanks,
> Mikesql

Generate images from SharePoint picture library?

I have a picture which saved in the sharepoint piture library, I can see it
via IE, the url is http://sharepoint/My20Pictures/01.jpg
But when I add it as an external image, it does't show when I review the
report.
Please advise! Thanks a lot!When you drag the image control and a option list shows up, when you selected
web, and you must have given URL at that time it gave any error ? Just check.
if it gives then there is a problem in accessing the jpg, So you need to
sort out there itself to proceed. Just check for access as well.
Amarnath
"CEO" wrote:
> I have a picture which saved in the sharepoint piture library, I can see it
> via IE, the url is http://sharepoint/My20Pictures/01.jpg
> But when I add it as an external image, it does't show when I review the
> report.
> Please advise! Thanks a lot!|||Thanks Amarnath,
There wasn't any problem when I darg the image control and type in the URL
for the picture, the image can be seen in the design model.
I think it is a permission issue when it go live, because sharepoint save
the picture in sql server database. And the reporting services running under
Local System.
But I'm not sure how to add user permission to show the picture.
Thanks!
"Amarnath" wrote:
> When you drag the image control and a option list shows up, when you selected
> web, and you must have given URL at that time it gave any error ? Just check.
> if it gives then there is a problem in accessing the jpg, So you need to
> sort out there itself to proceed. Just check for access as well.
> Amarnath
> "CEO" wrote:
> > I have a picture which saved in the sharepoint piture library, I can see it
> > via IE, the url is http://sharepoint/My20Pictures/01.jpg
> >
> > But when I add it as an external image, it does't show when I review the
> > report.
> >
> > Please advise! Thanks a lot!|||Infact when you select from the image control and preview it really connects
live and if it works, it has connection permission. So probabily, you can
check out the error, what exactly it gives, otherwise if you can add your
image(jpg) as a project and access from reports.
Amarnath
"CEO" wrote:
> Thanks Amarnath,
> There wasn't any problem when I darg the image control and type in the URL
> for the picture, the image can be seen in the design model.
> I think it is a permission issue when it go live, because sharepoint save
> the picture in sql server database. And the reporting services running under
> Local System.
> But I'm not sure how to add user permission to show the picture.
> Thanks!
>
> "Amarnath" wrote:
> > When you drag the image control and a option list shows up, when you selected
> > web, and you must have given URL at that time it gave any error ? Just check.
> > if it gives then there is a problem in accessing the jpg, So you need to
> > sort out there itself to proceed. Just check for access as well.
> >
> > Amarnath
> >
> > "CEO" wrote:
> >
> > > I have a picture which saved in the sharepoint piture library, I can see it
> > > via IE, the url is http://sharepoint/My20Pictures/01.jpg
> > >
> > > But when I add it as an external image, it does't show when I review the
> > > report.
> > >
> > > Please advise! Thanks a lot!|||I have the same problem with the authentication. I found in IIS log, that
requests for the picture from the pic library returns error 401. how to solve
the permissions problem?
Thanks
"Amarnath" wrote:
> Infact when you select from the image control and preview it really connects
> live and if it works, it has connection permission. So probabily, you can
> check out the error, what exactly it gives, otherwise if you can add your
> image(jpg) as a project and access from reports.
> Amarnath
>
> "CEO" wrote:
> > Thanks Amarnath,
> >
> > There wasn't any problem when I darg the image control and type in the URL
> > for the picture, the image can be seen in the design model.
> >
> > I think it is a permission issue when it go live, because sharepoint save
> > the picture in sql server database. And the reporting services running under
> > Local System.
> >
> > But I'm not sure how to add user permission to show the picture.
> >
> > Thanks!
> >
> >
> > "Amarnath" wrote:
> >
> > > When you drag the image control and a option list shows up, when you selected
> > > web, and you must have given URL at that time it gave any error ? Just check.
> > > if it gives then there is a problem in accessing the jpg, So you need to
> > > sort out there itself to proceed. Just check for access as well.
> > >
> > > Amarnath
> > >
> > > "CEO" wrote:
> > >
> > > > I have a picture which saved in the sharepoint piture library, I can see it
> > > > via IE, the url is http://sharepoint/My20Pictures/01.jpg
> > > >
> > > > But when I add it as an external image, it does't show when I review the
> > > > report.
> > > >
> > > > Please advise! Thanks a lot!