.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

UserID parameter prompting for credentials

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

Hi :),

I have a report that is filtered with the User!UserID parameter, and I want to make it prompt the user to enter credentials or at least make the user select his credentials from the drop-down list of the parameter.

Does anyone know how to achieve this?

Thanks in advance,


View Complete Post

More Related Resource Links

SP 2010 Keeps prompting for Credentials

Whenever a user tries to edit a document in SP 2010 (Excel, Word, etc), they are able to click edit document and then it loads up into Word or Excel and keeps on nagging you for your domain credentials. If you add your proper credentials it still comes back. I guess the fact that it lets me click the edit document or check out button that my account has proper permissions. I've tried the recommendations of putting the fqdn into my trusted sites. I even get it without using the fqdn (https://sp)   Thanks! This is really bugging me...

Server 2003 prompting for credentials when connection to Sharepoint document library via UNC

Hi all

I have a sharepoint document library http://mycompany/sites/documentLibrary. When browsing to this site through Internet Explorer on a terminal server I can get to the site without being prompted for a username and password, which is what I want. The site appears as "local intranet"  according to IE.

When browsing to the UNC path \\mycompany\sites\documentLibrary we are being prompted for a username and password. After putting in the credentials the document library displays. I need for the server to be able to access the site via UNC path without being prompted for credentials as we have several in house applications relying on doing so

The funny thing is this was working until recently. What's changed? I have no idea. I have an almost identical terminal server on the same subnet/OS/windows patch level that allows access without prompting for a username or password, and the only thing I had to do for that server was enable the web client service..

Things I have tried so far:

- Checked the Web Client service is enabled, started and set to automatic. Restarted the server just to make sure.
- Added http://mycompany, \\mycompany etc to the trusted zone.
- Set the truste

Prompting for User Credentials


I have a 2 web applications configured. One web application is configured for an Intranet and the other is configured for a MySite. These web applications are accessed internally and externally. With the internal applications I'm using integrated windows authentication and with the external applications I'm using basic authentication.

Everything works great except when I access the application externally. I obviously have to authenticate to 2 applications, the Intranet application and MySite application. The issue is when I initially access a page on the Intranet that has user profile pictures from the MySite on it. If there are 6 profile images on the page then I'm asked to authenticate 6 times to the MySite web application. If there is 1 profile image then I only have to authenticate once. Once I leave that page then I don't have to authenticate again.

Why do I have to authenticate for each profile image? Why can't I just authenticate authenticate to the MySite once?

stop prompting credentials while opening report manager in SSRS 2008


Hi All,

Can u please help me on how to stop asking the credential while opening report manager/ report server  in SSRS 2008.

I know we can solve this easily in 2005 by setting permission to IIS.  But I don't know how is here?

I searched lot in google but no success.

Kindly help me.

Thanks a lot.

Enterprize library 4.1 getting output parameter after adding record in db, plz guide



I need to get output parameter (flag) from db after saving record in database. I am using Microsoft Enterprise Library 4.1 for DB. I am inserting record using I Data reader.

Please guide


Use a column as parameter for a sds in another column; gridview


Hola, I have a gridview which is bound to a sds which returns 7 columns and I added two columns from the GUI.  What I want is to fill up the 9th column with DDLs and these  DDLS will get their data from a different sds which is using a stored procedure with a single parameter.  I created the 9th row, used template field, made the sds for 9th row, the stored_procedure, threw a DDL in Item template and all  I need now is to pass a parameter in the first column to the sds in the 9th column.  I can code this but i'm getting tired of aspx.cs :) and would like to do it from the GUI.

Sort by gridview SortExpression parameter via Stored Procedure


I have a gridview that calls data via a stored procedure.  I am unable to enable the gridview columns to be sortable. I need to set the parameter in the Stored Procedure, can someone help me with this?

Here is my gridview:

<asp:GridView ID="AllUsersGrid" runat="server" AutoGenerateColumns="False" DataKeyNames="UserName"
                        GridLines="Vertical" Width="900px" DataSourceID="SqlDataSource1" AllowSorting="True"
                        SelectedRowStyle-Height="30px" CellPadding="4" BackColor="White">
                            <asp:TemplateField HeaderText="Full Name" SortExpression="lastname">
                                    <asp:Label ID="DisplayName" runat="server" Text='<%# Eval("firstname").ToString() & " " & Eval("lastname").ToString() %>' />
                            <asp:BoundField HeaderText="User Name" DataField="UserName" />

type object parameter



I have a problem I can't figure out.

I've been trying to add a listbox with multi select enabled as a parameter to my select statement in sqldatasource.

So i created a function like this :

string strItemTypes = "";
foreach (ListItem li in lbItemType.Items)
   if (li.Selected)
      strItemTypes += "," + li.Value;
strItemTypes = strItemTypes.Substring(1);

which gives me the selected items like this for example : "1,2,3"...
Then I've been trying to add it to my sql select statement :

SELECT tblOfficesItems.idOfficesItems, tblStockItems.Name, tblStockItems.Description, tblStockItemTypes.TypeItem, tblStockItems.Notes FROM tblOfficesItems INNER JOIN tblStockItems ON tblOfficesItems.fkItem = tblStockItems.idItem INNER JOIN tblStockItemTypes ON tblStockItems.fkTypeItem = tblStockItemTypes.idTypeItem WHERE tblStockItems.fkTypeItem IN ( @fkTypeItems )

using a hiddenfield with a controlparameter of type=object
but it just don't seem to work, seems like the data just won't bind or something and I don't get any errors so I'm confused!!

then i tried this :

SELECT tblOfficesItems.idOfficesItems, tblStockItems.Name

MDX Query parameter from SSRS


I've a MDX Query that has where clause as shown below.
I'm designing report using SSRS 2008. How can i pass date as parameter ? I tried to setup @from and @to as parameter but not working ?
any ideas....

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )



Get ServerReport selected Parameter value to use in vb query


I'm using ReportViewer in Asp.net 2.0 to view a SSRS report. I need the value of the selected parameter to use in a vb query. The parameters are populated on the server and its a single selection. Doing searches I've come across  ReportViewer1.ServerReport.GetParameters() but I can't figure out if I can use this to determine which value the user has selected in the parameter dropdownlist. Any help would be appreciated.

Crystal Report parameter value window.


 Hi friends,

   I am using Crystal report which displays the result of stroed procedure which have 2 paramater.

  When i run report it shows two window for getting each parameter.

  My need is, can i have one window for getting all the paramter value for stored procedure.


  With Advanced thanks,






Crystal Report vs 2003 convert to vs 2008 parameter problem


Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??

Does someone can help me solve this problem??

Thank you

[How??] Lamda expression with ByRef parameter


How to write lamda expression with ByRef/ref parameter in c# ??

The code below causing syntax error:

item.OnAction = (p1, p2, ref p3) => {
   return true;

item.OnAction = (p1, p2, & p3) => {
   return true;

Security Briefs: Credentials and Delegation


I get loads of security questions from friends and former students, and recently I've gotten a number of questions about building secure data-driven Web sites for internal enterprise systems. I've decided to answer them here to hopefully save you some headaches in your own projects.

Keith Brown

MSDN Magazine September 2005

Security: Unify Windows Forms and ASP.NET Providers for Credentials Management


The .NET Framework 2.0 provides custom credentials management to ASP.NET apps out of the box. Using it, you can easily authenticate users without using Windows accounts. In this article the author presents a set of helper classes that let a Windows Forms application use the ASP.NET credentials management infrastructure as easily as if it were an ASP.NET application.

Juval Lowy

MSDN Magazine April 2005

parameter concatenation


I am trying to concatenate a href but doing some thing wrong..any ideas?

    Public Function limitChars(ByVal myString As String) As String

        If myString.Length > 300 Then
            myString = Left((Strip(myString)).ToString(), 300) & " <a href='<%# String.Format("../Detail.aspx?id={0}", Eval("ContentID"))%>' >more</a>"
        End If

        Return myString

    End Function

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend