I need the LOGON_USER information for a module I'm creating on my intranet to run a query. I am not successful. Page.User.Identity.Name.ToString() does not work for me. Any guidance would be greatly appreciated. I am using Michael Washington's AlternateDAL to gain access to an external table and the code below is not working for me.

Dim myParam As SqlParameter = New SqlParameter("@samAccountName", SqlDbType.NChar, 75)
myParam.Value = "Home\paskettj"                               >>>this WORKS
myParam.Value = Page.User.Identity.Name.ToString()   >>>this does NOT work
GetUser(SqlHelper.ExecuteReader(ConnectionString, CommandType.StoredProcedure, "Select_User_By_SAM", myParam))

Thanks in advance for help. <JP>

Hi Michael,

I believe the problem is getting the proper value to the stored procedure. As far as having a method that works, it is hard coded to pass my credentials to test whether the sproc is actually doing the job, and it is.

When I try this code:

Page.User.Identity.Name.ToString()

while logged into my DotNetNuke site it is set to "FormsIdentity" and returns just "Host" if I'm logged in as Host.

- Page.User.Identity {System.Web.Security.FormsIdentity} System.Security.Principal.IIdentity
+ System.Web.Security.FormsIdentity {System.Web.Security.FormsIdentity} System.Web.Security.FormsIdentity
AuthenticationType "Forms" String
IsAuthenticated True Boolean
Name "host" String

So perhaps that is the problem, you're getting forms authendication when you want to get Windows Authendication?