Click here to Skip to main content
13,458,022 members
Click here to Skip to main content
Add your own
alternative version


14 bookmarked
Posted 12 May 2012

Configuring IIS 7 for ASP.NET Applications Deployment and SQL Server 2008 Integration

, 13 May 2012
Rate this:
Please Sign up or sign in to vote.
This article is important and essential for beginners and intermediate ASP.NET developers. It will help them set their development environment


This article is important and essential for beginners and intermediate ASP.NET developers. It will help them set their development environment for publishing their applications for testing before deploying, and connecting with SQL Server 2005 and 2008.


When I started programming web applications using ASP.NET in Visual Studio 2010 and SQL Server 2008, I had numerous challenges in configuring the application for deployment. I had to search online for bits of code, and help forums, sometimes successfully and sometimes unsuccessfully. This has therefore motivated me to come up with a tutorial for configuring your IIS 7 Application server for ASP.NET development in your local machine.

Step 1: For those who don’t have IIS 7 installed

Download the Microsoft Web Platform Installer 3.0 from and install it in your computer. The Microsoft Web Platform Installer helps you install most developer tools for Microsoft. Using this tool, install those Microsoft products that you feel will be necessary in your ASP.NET development.

Step 2

Go to control Panel and Select Administrative Tools. In the resulting window, select Computer Management and Open (or if you think this process is too long, you can open RUN and type compmgmt.msc, and hit ENTER). This Console Window is important in the management of your computer.

Step 3

In the Console Window, in the Services and Applications drop down, select Internet Information Services (IIS) Manager, and in the Connections list, select Application Pools List.

In the Application Pools List, Right-Click ASP.NET v4.0 and select Advanced Settings. In the resulting window, at Process Models, set Identity to LocalSystem. You may leave the other items in their defaults. Hit OK.

Since you are using IIS 7, you may feel it necessary to set all your application pools to .NET Framework v4.0. To do this, Right-Click each application at a time and select Basic Settings. In the resulting window, set .NET Framework version to .NET Framework v4.0.xxxxx. Hit OK.

When you are through with this process, you will be able to use your SQL Server 2008 in your ASP.NET applications, and upon deployment, your applications will run in any .NET v4.0 Framework.

Problems being solved

  1. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET v4.0'. Error
  2. Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive. - This error occurs because the attribute 'targetFramework' is not a valid attribute in .NET Frameworks prior to v4.0.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer
Kenya Kenya
I'm a Systems Developer with a passion for programming (i.e. Software Engineering). I code Java, C and C++; and minimally C#. I also like Bash scripting and PHP.

You may also be interested in...


Comments and Discussions

QuestionVery good Pin
Member 1090090323-Jun-14 3:00
memberMember 1090090323-Jun-14 3:00 
AnswerRe: Very good Pin
pwanjau23-Jun-14 3:14
professionalpwanjau23-Jun-14 3:14 
GeneralMy vote of 3 Pin
pradeepbrh21-Mar-13 0:02
memberpradeepbrh21-Mar-13 0:02 
Questionsome parts missing in application pool. Pin
pradeepbrh20-Mar-13 23:45
memberpradeepbrh20-Mar-13 23:45 
AnswerRe: some parts missing in application pool. Pin
pradeepbrh26-Mar-13 2:50
memberpradeepbrh26-Mar-13 2:50 
GeneralMy vote of 5 Pin
Patrick Wanjau15-May-12 20:14
memberPatrick Wanjau15-May-12 20:14 
GeneralMy vote of 1 Pin
rgatcode15-May-12 5:11
memberrgatcode15-May-12 5:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.180323.1 | Last Updated 13 May 2012
Article Copyright 2012 by patwanjau
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid