MS SQL Server Reporting Services - Cannot create a connection to data source

Author

Cannot create a connection to data source

rjohnstone

2005-08-31, 8:24 pm

I ran into the same issue. I have modified security to report however
I noticed that it is using the users credentials who is accessing the
report to initiate Oracle connection. It looks like the user
requires elevated permissions on C:\Program Files\Oracle and possibly
other directories.

Still investigating...

Ryan

Tina (MSFTE)

2005-08-31, 8:24 pm

If you creaye a secure use in RSthat user can have the elevated priviledges
and not your real life users - better from a security point of view - that is
why I selected the options I did. See if that works to Oracle as well.

Cioa
Tina

"rjohnstone" wrote:

> I ran into the same issue. I have modified security to report however
> I noticed that it is using the users credentials who is accessing the
> report to initiate Oracle connection. It looks like the user
> requires elevated permissions on C:\Program Files\Oracle and possibly
> other directories.
>
> Still investigating...
>
> Ryan
>
>

Sponsored Links