Solved

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

Posted on 2014-12-14
1
183 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 36

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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

761 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