Question about Active Directory

We have a product that is based on a oracle database supplied by 3rd
party. With the license we are not allowed to alter the database funny
enough.
The reports produced from this product do not fit for purpose and
obviously we couldnt alter it due to the additional cost. So we are
thinking to find alternatives by re designing reports in MS Access
using ODBC to Oracle database and give users interface where they can
enter parameter to view the reports.
Now, from my reserach I dont think you can link Active Directory to MS
Access. Is this right?
So I am thinking "reporting service" within SQL server. I am thinking
of having SQL Server as a shell (with no tables stored), use the
linked server to connect to the Oracle database, SQL server can link
with AD then finally produce a web form report.
Am I crazy? Is it possible to do so? The main thing is that whatever
solution, it NEEDS to use active directory for authentication.
Anyone has better idea? Many thanks
PeppeOn 25 Oct, 19:37, nujcha...@.googlemail.com wrote:
> We have a product that is based on a oracle database supplied by 3rd
> party. With the license we are not allowed to alter the database funny
> enough.
> The reports produced from this product do not fit for purpose and
> obviously we couldnt alter it due to the additional cost. So we are
> thinking to find alternatives by re designing reports in MS Access
> using ODBC to Oracle database and give users interface where they can
> enter parameter to view the reports.
> Now, from my reserach I dont think you can link Active Directory to MS
> Access. Is this right?
> So I am thinking "reporting service" within SQL server. I am thinking
> of having SQL Server as a shell (with no tables stored), use the
> linked server to connect to the Oracle database, SQL server can link
> with AD then finally produce a web form report.
> Am I crazy? Is it possible to do so? The main thing is that whatever
> solution, it NEEDS to use active directory for authentication.
> Anyone has better idea? Many thanks
> Peppe
anyone please help me I am stuck :(