Windows Authentication In ASP.NET SQL 2005 VB

[Daxthecon]

I'm using VS 2008 and Microsoft SQL Server Express Edition to program an ASP.NET/VB web application. The web application has to do with putting in products to populate a table veiwed by another page where the person veiwing that page will have the permissions to deny/allow the purchase of the product to the user. Now down to what needs to be done...

1. I need to know how to use Windows Authentication to be passed from on Web app into this one. So that I can access and display the user email name and all properties associated with the Authentication because they will be coming from an internal site(Sharepoint and Intranet alike).

2. I am having issues with the SQL server telling me that when I go to debug(after I have linked the DataGrid to the DB and Table that it is associated with) that the Login failed and the stack trace tells me the Windows Authentication can not be imitated. I suspect that it has something to do with the way the computer is set up in that it is imaged from a remote desktop on to the screens where I work. No tower is involved. I don't know how to go about fixing this.

I would imagine these are some hefty questions that are hard to answer or maybe understand. Please if you need any guidance into what I was trying to say post your questions politely and I will get back to you quickly between 8-4pm CST.

Thank you in advance for any assistance provided.

Fixed issue number 2 as it was a VS issuing a login of it's own as a windows default authentication and the sql server wasn't looking for it. I created it under the sql server and it is now working fine.

Althought I now have a few more things to add.

3. I set up the datagrid to take information to a table but it doesn't want to add them. I have the correct settings for it in sql and in the data grid and all the google sites plus 4guysfromroll.com tell me I am doing it right but it is still not wanting to right to the table. Please let me know if there is any other code I need to be aware of to fix this issue.

[Daxthecon]

Still need very much some help with this.

[Curtis Rutland]

Well, for #1 you can get the domain user name with:

Page.User.Identity.Name

You might have to do some Active Directory work after that to get the email address, as this is just a string.

For #3, if you are using .NET 3.5, you can use a GridView. I think that it is easier to use than a DataGrid. Also, you might have to .DataBind() to make your data appear in the grid.

HTH

[Daxthecon]

Thank you for the guidance I am completing some of the harder stuff I couldn't get done with the data grid right now. As for the environment coding it's going to take some AD digging and know-how. Does anyone have any web pages other than what I can google to suggest?