MS SQL Server Reporting Services

Author

Avoid User Login

Wayne Wengert

2005-10-31, 8:24 pm

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

Ches

2005-10-31, 8:24 pm

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)

Wayne Wengert

2005-10-31, 8:24 pm

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

"Ches" <chesire@usa.net> wrote in message
news:1130792183.610988.65760@g47g2000cwa.googlegroups.com...
> 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)
>

Ches

2005-10-31, 8:24 pm

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)

Wayne Wengert

2005-10-31, 8:24 pm

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

"Ches" <chesire@usa.net> wrote in message
news:1130795769.474852.279180@g43g2000cwa.googlegroups.com...
> 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)
>

Sponsored Links