Avoid windows login prompt while accessing report server.

Hi,

We are using Microsoft Reporting Service 2005 to develop reports and we are accessing these reports through a J2EE application.
The front end is implemented using Tapestry and we using JBoss as our applicaiton server.
We are using Shared Data Sources for the reports and we set its data source type to SQL Server Analysis Services.
In the credential tab, by default "Use Windows authentication" is selected. All other options are disabled.

When I access my reportserver through my web application, I am always prompted for a windows login and password.
How can I avoid being shown the windows login prompt, since our web application will be used by several users and we do not want the users to type in a username/password everytime they want to access our reports.

Please suggest me solution for this scenario.

Thanks in advance!

Hi,

i think the core problem is, that you use windows integrated authentication. In this case the current login user on the client is used to authenticat the access to the database, if this user dont have access rights to the database, you get the login prompt.

Perhapse it is possible for you to set fixed credentials in the shared datasource?

Tibor Csizmadia

|||

How do I give the users access rights to the database? and there may be so many users invoking the reports through our web application.

As I mentioned in my earlier post when I create a new shared data source in my report project, in the Credentials tab "Use Windows Authentication (Integrated Security)" is selected by default. All other options are disabled so I cannot set any other credentials.

Why is it that I can select credential only as "Windows Authentication" is it because the data source type is selected as SQL Server Analysis Services?

Also one thing I forgot to mention is that we are using SQL Server 2005 Standard Edition

|||

Hi,

if you want to use the integrated security, i would create a security-group the the users who have access to the database. Then asign in the SQL-Server-Management Studio this security group to the database (Security/Logins, Add new User, choose the security-group from the AD, assign the Database to access throu this group).

I doent know why you can only use the windows Authentication for "Microsoft SQL-Server Analyse Services" in VS.NET, but if you define the share datasource in the reporting-managment website (http://localhost/Reports) you can set outher authentications...Perhaps MS have for this an explanation.

I hope this help you.

Tibor Csizmadia