I am trying to set up a website where I want the person viewing to be authenticated using windows authentication mode. However in connecting to the sql server database I want to use a windows service account.
Can anyone help? Basically either I can connect to the database but the windows user is then not pulling through or windows auth works but the datbase connection is saying the user is anonymous.