sql server reporting services: Assuming you mean no security.... check your connection. In the
Connect Using area do you have "Credentials Stored Security on the
Report Server" selected with appropriate userID and password? If so
you shouldn't be getting a log in. (You might be able to get away with
"Credentials are not Required" as well if the data is open)

I have an ASP.NET application that includes a Report Viewer form. The user
clicks on a radio button list item to sekect the report to be viewed. The
system requires the user to enter a userid and password to view the report.

Is there a way to simply have the report display? I do not want users to
have to log in.

TIA

Wayne

Ok more assumptions :)

not using a shared data source...

Edit your datasource, click on the ... next to the datasource field,
then you'll find a credentials tab. Play with the options you find
there.

using a shared data source...

double click on your shared datasource and edit the credentials tab.

Alternately if it's already been deployed (and it's shared)... from the
front end of the report server look in your report folder making sure
Show Details is on, and edit your datasource from there (all on one
page)

Ches;

Thanks for the response. Wherehow do I check the connection settings? I
tried editing the data set asnd I don't see a connection setting there. The
property settings for the project are also no help nor are the properties
for "Reports" or the solution.

Wayne

[quoted text, click to view]

Ches;

Thanks for the additional information. My reports are based on Views in an
SQL Server. For the "DataSet" they each simply show the name of the
database. Clicking on the "..." opens a window with 5 tabs, Query, Fields,
Data Options, Parameters and Filters? I noticed another elipse next to the
"Data Source" textbox on the Query tab and that opens another window where
there is a Credentials tab and it does have the userid and PW.

I believe the login request the user is getting is the login and PW for the
report server, not the back end database.

I do appreciate all your help. There are so many layers to everything ot is
a real challange to find what you want.

Wayne

[quoted text, click to view]

I had been using the Report Viewer Control Add-In and as far as I can tell,
it does not have a method to pass credentials to the RS server. I found a
code snippet that renders the report directly, allowing you to pass
credentials. See snippet below: (rs1 must be defined as a proxy class
pointing to your RS server)



*******************************

rs1.Credentials = New System.Net.NetworkCredential("<myLogin>", "<myPW>",
"")

Dim results As Byte(), image As Byte()

Dim streamids As String(), streamid As String

' Render the report to HTML4.0

results = rs1.Render(Session("ReportPath"), "HTML4.0", _

Nothing,
"<DeviceInfo><StreamRoot>/WebApplication1/</StreamRoot></DeviceInfo>",
Nothing, _

Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, streamids)

Response.BinaryWrite(results)

**************************************



Wayne



[quoted text, click to view]

Great! We haven't had that issue yet :) We're doing most of our
permissions through AD and back end tables, so a bit different from the
rest of the world.

Good luck with your Reporting :)

Ches