After some work we have successfully gotten IIS to let us log on to the website with our Windows login credentials but when we attempt to log on to SQL Server all we recieve is;

.Net SqlClient Data Provider

Login failed for user 'NT Authority\Anonymous Logon'

Same error in SQL Server log so I know it's trying to get to DB. If I use SQL Authentication all works fine, just not windows Authentication. I know I have groups and userids both set as valid logins to SQL and DB but can't seem to get website to pass windows credentials.

Any help would be great. Main reason we are looking at this is because it uses integrated authentication as we do not use SQL authentication of anyting outside of app logins.

Thanks,

Marty

I will have to admit sorry not too up-to-date on proper formatting in these files. If I code exactly what you have here I get syntax error in system.web file. It looked like I should just simply change <identity impersonate="true"> to <identity impersonate="true" /> but then still just received same anonymous errors. Here is a shot of my web.config file for this section please advise on correct syntax for this statement. Thanks Marty

<system.web>
<pages
validateRequest="false"
smartNavigation="false"
theme=""
/>

<identity impersonate="true">

<compilation defaultLanguage="c#" debug="true" />

<globalization
requestEncoding="utf-8"
responseEncoding="utf-8"
culture="en-US"
/>

With this I get the following error

Parser Error Message: The 'identity' start tag on line 20 does not match the end tag of 'system.web'. Line 148, position 4.

Source Error:

Line 146: </case>
Line 147: </browserCaps>
Line 148: </system.web>
Line 149:
Line 150:</configuration>

Thanks for the reply. We did seem to find the solution. Here is a shot of my new web.config file settings that we needed to change for full windows authentication to work. And we do plan to use windows authentication because we are only going to use this product in our intranet IIS servers not via the internet.

<system.web>
<pages
validateRequest="false"
smartNavigation="false"
theme=""
/>
<authentication mode="Windows"/>

<identity impersonate="true" />

<compilation defaultLanguage="c#" debug="true" />

<globalization
requestEncoding="utf-8"
responseEncoding="utf-8"
culture="en-US"
/>

<customErrors mode="Off" />

<authorization>
<allow users="*" />
</authorization>

We had to add the authentication mode section, identity section as you indicated and then switch allow users="?" to allow users="*" as we had in another .net app we had running here. This allowed us to log on to the web and db with our windows credentials successfully. Thanks again for the help and hopefully this will help any others that attempt this later.

Thanks,

Marty