12 thoughts on “Allowing IIS 7.5 Applications to communicate with SQL server via Windows Authentication

  1. Hi Giles, Thanks for the helpful post. Can you tell me does creating a SQL Server login for IIS 7.5 application pool work for a SQL Server 2008 database on a different machine on the same name? We have tried the above but get an error message indicating the IIS APPPOOL\(app pool) can not be found. Your help is much appreciated!

  2. Ooops to clarify SQL Server and IIS 7.5 are on different computers on the same domain. Do I need to preface IIS APPPOOL\MyApplicationPool with domain name/machine name? If so can you provide syntax? Thanks much in advance!

  3. Pingback: [RESOLVED]when deploy in server,how can i do integrated Security with windows logged user.thank u very much | ASP Questions & Answers

  4. Pingback: [RESOLVED]when deploy in server,how can i do integrated Security with windows logged user.thank u very much | ASP Web Form Data Control

  5. Pingback: [RESOLVED]when deploy in server,how can i do integrated Security with windows logged user.thank u very much | ASP.NET MVC

  6. this will definitely not work if your SQL Server is on a different machine than your IIS server (which would be the case for most decent sized enterprise applications). For this scenario, you will need to use a service account in AD.

  7. Wow man you saved me a lot of time. Been working on this for hours, once I came across your post, boom done!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s