Solved

SQL server 2008 r2 on Windows server 2008 r2

Posted on 2010-11-30
9
530 Views
Last Modified: 2012-05-10
HI,

Testing installing SQL Server 2008 R2 ent onto a 64bit Windows server 2008 r2 ent and having a few issues...

Ive ran all the updates on Windows server (including .NET4)

1: Once I try and install SQL Server 2008 Ent i get a Compatability issue saying i need to install SP1 on for it to work! (I dont remember getting this last time i installed it but may have been on a Win 2008 server not R2)???

2: I admit to not knowing much about .NET but i thought having .NET 4 would stop the need for 3.5, yet when i carried on with the install ignoring the compatability problem, it says .NET is not installed. I did a download of .NEt but it wont let me install the download, only install it via Server Manager and install a lot IIS and other features, which i dont want.

3: I was going to install multiple instances of SQL onto this server, so if i do have to install SP1 (Im also thinking ill just put on SP2 since its been out a while now) that i will have to install this per instance, ive never done any patch work on a multi instance server, how is tis done.

Thanks for any input.

S
 
0
Comment
Question by:stebennettsjb
[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
  • 4
  • 3
  • 2
9 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 34242279
When you install the service pack, it will prompt for you to choose which installed instances you want to apply the service pack to.  Just apply it to all you want to apply it to.  Make sure you have the right .Net distributable also.
0
 
LVL 7

Expert Comment

by:Cboudroz
ID: 34242354
-----> 2: I admit to not knowing much about .NET but i thought having .NET 4 would stop the need for 3.5 --> false


if the .net application is build on the framework 2.0 you need 2.0 install. if build on 3.5 you need 3.5 install.

If I correctly remember MS SQL 2008 r2 need the .net framework 3.5 whit SP1 and framework 4.5
0
 

Author Comment

by:stebennettsjb
ID: 34242387
Thanks BrandonGalderisi, that simplifies that part.

For .NETs, version 4 was from the Windows updates, Version 3 was via:

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=333325fd-ae52-4e35-b531-508d977d32a6&displaylang=en

which is just 3.5 it seems there is a 3.5 sp1 i can try that install, Could you confirm that i do have to install 3.5 even though i have 4 on?

 
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 500 total points
ID: 34242478
0
 

Author Comment

by:stebennettsjb
ID: 34243666
Thanks for all the replies..

So any idea if i can install 3.5 without having to install all the IIS stuff ie install 3.5 from an exe instead of via features?

Cheers
0
 
LVL 7

Expert Comment

by:Cboudroz
ID: 34243685
You can only select the needed component in windows add/remove features, no need to select all the IIS feature.

or

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=333325fd-ae52-4e35-b531-508d977d32a6&displaylang=en

0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 34304915
The solution was provided it's just not as easy and straight forward as you desire.
0
 

Author Comment

by:stebennettsjb
ID: 34308270
Hi Brandon,

Your right, I didnt recheck my question properly before closing to be honest, I can see you have answered 2 of the 3 questions (Questions 2,3) for question 1 the best answer i have found is to slipstream SP1 with the install.

Thanks for your help.

S

0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 34309690
It is not necessary to slipstream it, but it doesn't hurt.
0

Featured Post

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

751 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