Solved

Installation process of SQL, VS, IIS... evaluate

Posted on 2014-12-14
1
163 Views
Last Modified: 2014-12-18
At: https://social.msdn.microsoft.com/Forums/vstudio/en-US/ad871e4f-1ff0-4095-a09d-75f09bcac49d/installation-order-for-iis-75-visual-studio-2012-and-sql-server-2012?forum=vssetup

I found the following, rather lengthy, instructions. Please evaluate the followings. If you prefer, refer to x numbers as listed below:
================
(FYI, this is brand new Windows 7 Professional Laptop)

1) Prepare the initial system -- create a restore point on the existing machine (restore point #1)

--- run a file system and disk check on any installation disk volumes

--- disable any virus or malware protection software (temporarily)

---- confirm the you have the latest release of the Windows Installer

2) Run Windows Update -- install the required (not optional) updates

3) Install Visual Studio 2012 (Professional/Ultimate -- not Express)

4) Reboot the machine after install Step 3.

5) Create a new restore point (restore point #2)

6) Open Visual Studio and check for updates -- install required updates -- reboot

7) Create a new restore point (restore point #3)

8) Install IIS 8.0 (not 7.5) -- no need to reboot after IIS install, but run Windows Update

9) If new updates after IIS install and reboot, create another restore point ( restore pointy #4)

10) Check the RAM and disk storage requirements for SQL Sever 2012 -- confirm you meet the req.

a) If you have another SQL database system installed/running (MySQL, Oracle, etc.) recommend you shut the service down prior to beginning the SQL Server 2012 install.   <-- n/a

11) Install SQL Server 2012, reboot, run Windows Update, install any important updates, reboot again , and open the SQL Server Management Console (check the logs for any errors on SQL server service start up) -- be sure you download and install any required SQL Server drivers.

12) Create another restore point ( restore point #5)

The most important steps in the process is to make sure you have the latest Windows Installer and to  create restore points along the way and to reboot the machine after each installation of the software suites. Also running Windows Update as you go will save time overall and ensure you get each software new installed program updated before you move on.
Most important, check the install logs and confirm you didn't "miss" anything. The installs can take time and you might not catch any issues not serious enough to stop the install, but could crop up later.
===================
This process has lots of moving parts and each one of those that are not absolutely could turn into a trap. It is scary to me. What do you think?
0
Comment
Question by:Mike Eghtebas
1 Comment
 
LVL 35

Accepted Solution

by:
Miguel Oz earned 500 total points
ID: 40499237
Sadly that is the way it is, because you are installing a lot of products, the restore points are giving you rollback point in case something goes wrong.

Some observations to take in account:
- "disable any virus or malware protection software (temporarily)" Not required in my experience (I use Norton and Trend Micro - maybe other AVs)
- "8) Install IIS 8.0 (not 7.5) -- ". do this step after step 2. you are better off having IIS properly registered when VS installer will run.
- Unless it is job requirement, if you have MSDN I will install VS2013 (not VS2012 as per question)
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now