Solved

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

Posted on 2014-12-13
6
232 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
  • 2
  • 2
  • 2
6 Comments
 
LVL 78

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 33

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 78

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 33

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
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.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

919 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

12 Experts available now in Live!

Get 1:1 Help Now