Solved

step by step guide to installing sql server 2008 R2 on standalone machine (not cluster) + SP2 + CU4

Posted on 2013-01-24
28
1,723 Views
Last Modified: 2013-03-06
Dear all,

Any good step by step guide to installing sql server 2008 r2 procedure, step by step guide to installing sql server 2008 r2 SP2 and step by step guide to installing sql server 2008 r2 SP2 CU4?

the step by step guide for SP2 and CU4 for SQL server 2008 R2 should include the cluster and standalone machine installation.

DBA100.
0
Comment
Question by:marrowyung
  • 17
  • 4
  • 4
  • +2
28 Comments
 
LVL 1

Author Comment

by:marrowyung
ID: 38817726
Any need to known issue before installing, during install and post configuration ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38817734
anyone tried the CU4, is it stable ?
0
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 200 total points
ID: 38820241
I've applied CU4 it in a few places and haven't had any issues - also, a quick search didn't turn up any complaints about CU4 specifically, and list of issues resolved post-SP2 is pretty impressive, so I'd advise applying it (though test it on a non-critical installation if you can, obviously).

For a standalone installation, this guide is about as comprehensive as it gets (it's for SQL 2008, but the installation for R2 is almost exactly the same):

http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

For a clustered instance of SQL Server, this is by far the best walk-through I've found, as it includes configuration for the Windows cluster, MSDTC, and SQL Server:

http://dbperf.wordpress.com/2010/07/10/walkthrough-cluster-setup-sql-win-2008/

If you need something more specific, please let me know and I'll try to provide it.
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 200 total points
ID: 38820997
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 38824279
Looks like you already have some pretty good links and suggestions...
0
 
LVL 35

Expert Comment

by:David Todd
ID: 38824763
Hi

... and of course you are at least going to apply this to a test instance or your workstation first, right?

Regards
  David
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38830517
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38833549
yes, it will
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38833684
EugeneZ also give good reply too !
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 38833786
Those walkthroughs should give you what you need - for the service pack, there shouldn't be any difference at all between SQL 2008 and 2008 R2. For service packs, just accept all the default choices and you'll be fine.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38834338
The CU4 has the following component:

1) SQLServer2008R2-KB2777358-x64.exe
2) sqlncli.msi
3) rsSharePoint.msi
4)MasterDataServices.msi

do anyone one of your tried that before and know which one should be deploy, I just deploy all of them and it seems that only item 1 is needed, am I right?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38834342
ryanmccauley,

I just run the SP2 update, CU4 update will give exactly the same steps.

But what if we deploy SP2 and CU4 on cluster nodes? what should we do ?

it seems that this the SP2 and CU4 update do not need to stop the SQL server in advance !
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38834382
Here attach some message after installing the SQL server 2008 R2 +SP2+CU4, anyone know why? specially the error of installatin error of database engine but it is working fine.
SQL-server-2008-installation-.ne.jpg
SQL-server-2008-installation-reg.jpg
SQL-server-2008-installation-rep.jpg
SQL-server-2008-installation-SSI.jpg
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38834612
check if the errors like these were before; are they reoccurring or have the same timestamp when you did installs sp2 cu4?

some of the error you probably got during install: sql server was running, objects locked and as result info\warning log was recorded..

if sql server\ db \ cluster are working fine - I would not worry about these errors too much - however, keep eyes opened
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 100 total points
ID: 38834669
OK, first you install 2008 R2

Then once that is OK (and you have checked errors et al), you apply SP2

Or, you install 2008 R2 with SP2

Not sure why you are applying CU4 as well at this stage. Please read : http://www.microsoft.com/en-au/download/details.aspx?id=30437 and http://support.microsoft.com/kb/2527180 and decide if you really need CU4

When are you getting the errors ?

The first (and subsequent) looks like files cannot be found, or, are not accessible, or, has picked up the wrong one.

I have seen a connect issue logged where installing VS10 first also installs SQL 2008 and probably needs to be removed.

Always best to first install 2008 R2

Can you please describe the sequence of events ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38834720
EugeneZ,

"check if the errors like these were before; are they reoccurring or have the same timestamp when you did installs sp2 cu4?
"

Yes, some of them are reoccurring, but the DB is working fine. can't see why.

mark_wills,

"
Not sure why you are applying CU4 as well at this stage"

basically I don't mind to install it and as people in this group keep suggesting it, I would like to try.  if I dont' install it now, I don't think I have chance to install and Vendor said install the latest one and CU4 has no impact on their tools.

Yeah, I cna't tset it as no test platform for this at all but no platform upgraded to SQL server 2008 R2 also.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38834721
mark_wills,

"Not sure why you are applying CU4 as well at this stage. Please read : http://www.microsoft.com/en-au/download/details.aspx?id=30437 and http://support.microsoft.com/kb/2527180 and decide if you really need CU4"

both link you send me is a downalod link, any other link doubt about the CU4 ?
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 38834744
Second link should be the CU4 contents - read through the bug list and see if any apply to you.

Also has a list of versions to double check against your current install.

Dont worry about the download link - was going to suggest re-applying in case of corruption.

You didnt mention when you got the errors - were there any prior to CU4 ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38835550
mark_wills,

"You didnt mention when you got the errors - were there any prior to CU4 ? "

the error should be just after install SP2.

and after installing Cu4 the same thing happen also.

I remember the .net error and last time I saw that I post a ticket here and the correct reply is just restart it. as it can't just find the .net compiler something like this.

but this time after I reboot, the whole error still there.

I will install one more SQL server 2008 R2 server and see if the same thing happen again.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38842712
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 38843006
Arent they the same errors as before ?

Not too worried about the full text stuff - by the looks you werent using it.

It does look like you already have Visual Studio, or, it errored with Data Tiers - again not a real problem and can be fixed later (if you ever go to use it).

Some of those errors arent, some are warnings and really wouldnt be worried about SSIS using default package.

Questio though... Did you have any other instances running on that machine, and is this the first time attempted, and do you have Visual Studio installed ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38849765
mark_wills,

"Arent they the same errors as before ?"
 some of them are some of them are not !


"Not too worried about the full text stuff - by the looks you werent using it."

Hopefullly.

"It does look like you already have Visual Studio, or, it errored with Data Tiers - again not a real problem and can be fixed later (if you ever go to use it)."

No. I don't have this installed, but  I think the software (SQL Server 2005 Express or SQLserver 2008R2) install the component MS Vistual Studio C++ 2008 redistribute x64 9.0.xxx for me.

so  I can ignore it  and it is not related to SQL server 2008 R2 installation ?

"Some of those errors arent, some are warnings and really wouldnt be worried about SSIS using default package."

ok then ignore it.

"Questio though... Did you have any other instances running on that machine, and is this the first time attempted, and do you have Visual Studio installed ? "

I think it is the SQL server 2005 express edition, the monitoroing tools install it. but I remember that I just install the SQL server 2005 client component on it.

so this is not related?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38849772
This should be another clean machine I have, this only has one monitoring tools installed.

the other one withe Windows 2008 R2 on it but will install with SQL server 2005 to simulation on of our migration situation .
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38849795
if you have fully functional installed sql server - you are good,''


some of the errors just informational
and can be ignored or if you wish - you can open an another EE questions for each of the errors or check web,

I would say; this case is resolved
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38849831
EugeneZ,

I know what you mean, as you can see that I keep opening new ticket and tell you all to answer, the objective is the same, this ticket should be over.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38853970
I've requested that this question be closed as follows:

Accepted answer: 200 points for ryanmccauley's comment #a38820241
Assisted answer: 200 points for EugeneZ's comment #a38820997
Assisted answer: 100 points for mark_wills's comment #a38843006
Assisted answer: 0 points for marrowyung's comment #a38849831

for the following reason:

pleaes help to answer this.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_28018706.html
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38850171
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38956926
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
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.

747 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

10 Experts available now in Live!

Get 1:1 Help Now