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

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:

ASP.net, SSRS, SSIS, SSAS

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?
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
 
David Johnson, CD, MVPConnect With a Mentor OwnerCommented:
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.
0
 
LordWabbitConnect With a Mentor Commented:
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?
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Thank you for good information. The following link describes IIS activation in conjunction with vs 2005:
http://msdn.microsoft.com/en-us/library/ms181052%28v=vs.80%29.aspx

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

revised:
I see that iis 8.5 is activated dynamically (automatically?):
http://www.iis.net/learn/get-started/whats-new-in-iis-85/dynamic-site-activation-in-iis85

Dose this changes your instruction?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
David Johnson, CD, MVPOwnerCommented:
dynamic activation only applies if you have more than 100 websites .. and no my recomendations stand .. some programs require sqlexpress and not sql server
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
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.
0
 
LordWabbitCommented:
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.
0
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.

All Courses

From novice to tech pro — start learning today.