asked on

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?

ASKER CERTIFIED SOLUTION

David Johnson, CD

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

LordWabbit

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike Eghtebas

ASKER

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?

David Johnson, CD

dynamic activation only applies if you have more than 100 websites .. and no my recomendations stand .. some programs require sqlexpress and not sql server

Mike Eghtebas

ASKER

Thank you all. Please see a followup question at: https://www.experts-exchange.com/questions/28580506/Installation-process-of-SQL-VS-IIS-evaluate.html if you have couple time.

LordWabbit

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.