Solved

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

Posted on 2014-12-13
6
251 Views
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:

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?
0
Comment
Question by:Mike Eghtebas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 81

Accepted Solution

by:
David Johnson, CD, MVP earned 400 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.
0
 
LVL 11

Assisted Solution

by:LordWabbit
LordWabbit earned 100 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?
0
 
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:
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
Is Your Team Achieving Their Full Potential?

74% of employees feel they are not achieving their full potential. With Linux Academy, not only will you strengthen your team's core competencies but also their knowledge of of the newest IT topics.

With new material every week, we'll make sure that you stay ahead of the game.

 
LVL 81

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
0
 
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.
0
 
LVL 11

Expert Comment

by:LordWabbit
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.
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

707 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