new computer, new installation sequence (sql, vs, iis activation)

Posted on 2014-12-13
Medium Priority
Last Modified: 2016-02-18
In the past, I go into trouble because I didn't installed/activated the following in a proper order.

- SQL Server 2014 and maybe SQL Express 2014 as well.
- VS 2012 Ultimate and maybe VS 2013
- Activate IIS.

Intended operations:


Q1:  Is this sequence correct: SQL Server, Activate IIS, and  VS 2012 Ultimate correct order?

At one point, I recall (if I am not mistaken), for SSRS, IIS activation was required prior to SQL Server installation.
Q2: Any comment on this you may have?

And, also, apparently IIS has to be done before VS installation (when I was trying the process with vs 2008 or 2010).
Q3: Is IIS handled differently with VS 2012 or VS 2013? Is activation done the same way as the prior versions or it is activated automatically (or differently)?

Q4: Any other advise you may have to make sure I will have good installations?
Question by:Mike Eghtebas
  • 2
  • 2
  • 2
LVL 85

Accepted Solution

David Johnson, CD, MVP earned 1600 total points
ID: 40498663
Visual Studio will install SQL Express and is stand alone.
SQL Server Reporting Services requires IIS

So the sequence is
1. IIS
2. Visual Studio
3. SQL Server it may still install older V Studio components.
LVL 11

Assisted Solution

LordWabbit earned 400 total points
ID: 40498771
While Davids comments are valid, I have a slightly different install order.
1. Install IIS - if you don't do this first you have to repair it afterwards.
2. Install SQL Server
3. Install Visual Studio - but choose a custom install and deselect sql express.  Why have two instances of sql running?
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40498857
Thank you for good information. The following link describes IIS activation in conjunction with vs 2005:

Has the been any changes since for newer versions of vs?

I see that iis 8.5 is activated dynamically (automatically?):

Dose this changes your instruction?
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 85

Expert Comment

by:David Johnson, CD, MVP
ID: 40498876
dynamic activation only applies if you have more than 100 websites .. and no my recomendations stand .. some programs require sqlexpress and not sql server
LVL 34

Author Closing Comment

by:Mike Eghtebas
ID: 40498905
Thank you all. Please see a followup question at: http://www.experts-exchange.com/Programming/Languages/.NET/Q_28580506.html if you have couple time.
LVL 11

Expert Comment

ID: 40499036
Yet again, I agree with David, for most websites SQL express is more than sufficient.  But if you are going to install a full SQL instance it is pointless installing SQL express as well.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
SingleRun is a tool that ensures that only one instance of an application is started, running it again brings the application to focus.
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question