Hi,

In my INSERT SQL statement I am currently use suser_name() as a default to my data field name UserInput, I am using Windows Authenticated at the moment and my newly insert record shown as MyPCName\ASPNET instead of what I am hoping for is MyWindowsDomain\MyAccountID.

Any help is much appreciated.

Thanks,

1- Your IIS site should be configured for Windows Authentication

2- Your application's web.config file should allow impersonation with Windows Authentication by inserting these lines

<authentication mode="Windows"/>

<identity impersonate="true"/>

Hope this helps.

Ed