IIS login putting username into variable

[HebieBug]

Have some users that will login to a virtual site that is protected with a Windows 2000 username and password.
My aim is that once they enter their login details into the microsoft login then their username (if successful) will then show their unique page. It's not really unique but the username will be used in an SQL string which will display the current work they have outstanding.
Anyone know how I can do it?

 

[yandso]

You could try this for asp.

<%
Username=Request.ServerVariables(&quot;LOGON_USER&quot
%>