Link to home
Start Free TrialLog in
Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America

asked on

What is the proper order of installation for IIS, SQL Server, and Visual Studio?

Please tell me which of the following (A, B, or C) is a proper installation order. My apology in advance for second guessing the inputs from the experts in the following links.

Question: What is the proper order of of installation for IIS, SQL Server, and Visual Studio?

Option C is my choice with explanations included. Please correct me and tell me why C is not correct.

Option A as discussed at https://www.experts-exchange.com/questions/28580506/Installation-process-of-SQL-VS-IIS-evaluate.html , the order is:
A1. Visual Studio
A2. IIS
A3. SQL Server

Option B as discussed at https://www.experts-exchange.com/questions/28580435/new-computer-new-installation-sequence-sql-vs-iis-activation.html which suggests order like:
B1. IIS
B2. Visual Studio
B3. SQL Server

Option C, my personal choice with open mind to learn. I have include explanations with each step:
C1. IIS                        <-- is required by both SQL Server (for SSRS) and Visual Studio.
C2. SQL Server        <-- it better to install SQL Sever prior to Visual Studio despite the fact
                                                   recent Visual Studio include SQL Server (compact version) internally.
C3. Visual Studio    <-- Finally Visual Studio

Revised:
From : http://msdn.microsoft.com/en-us/library/jj248684.aspx it seems to suggest the followings:
D1: IIS                            <-- I will install whatever the defaule IIS is in my computer.
D2: Wisual Studio       <-- I will install vs  2013 Ultimate
D3: SQL Server            <-- I will install SQL Server 2014 Developer

Reading more, I see that SSRS has nothing to do with IIS in native mode. But in the integrated mode (with sharepoint and because sharepoint has dependency on IIS), SSRS has indirect dependency with IIS.

Bottom line, because I will be doing SSRS in native mode and Visual Studio has it internal IIS (IIS Express?), I do not need to worry about IIS for now. However, later on I suppose when I am ready for sharepoint, I can configure IIS along with whatever sharepoint needs.

With IIS out of this list. it seems I can install SQL Server and VS 2013 in any order (preferably VS 2013 last).
Question 2: Does my assessment makes sense? Is it accurate?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike Eghtebas

ASKER

Miguel,

But we have: SQL Server 2014 Business Intelligence 32-bit (English)  1 GB

Then I do SQL Server 2014 Developer, then vs 2013, and late BI version of SQL Server 2014

In your opinion, is this a good plan?