"in place" upgrade Windows Server 2003 to Windows server 2008 with SQL 2005 installed

Is it possible to "in place" upgrade from server 2003 R2 to server 2008 R2, if it has MSSQL 2005 on it?
I am looking at my options.

Thank you,

Steve
RSchalhoubAsked:
Who is Participating?
 
JestersGrindCommented:
I believe there are issues if it is a clustered SQL Server.  Otherwise, make sure that you have the latest SQL service packs and patches applied.
0
 
JestersGrindCommented:
That should be a fairly simple upgrade.  There are some tools to help on this page.  
https://technet.microsoft.com/en-us/library/cc755199(v=ws.10).aspx

That said, if possible, I would rebuild the server on a test server and test it thoughly before doing the upgrade.  

Greg
0
 
Kent OlsenData Warehouse Architect / DBACommented:
Agree with Greg.

I've got a lot of WS 2003 Servers that I'm upgrading to 2008 right now.  It's a pretty easy process and I haven't found anything that has caused a problem so far.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
RSchalhoubAuthor Commented:
I'm not too worried about the actual server upgrade.
My question is upgrading a server with SQL server 2005 installed on it.
Do you see any SQL issues after the upgrade?
I understand that starting fresh is the best policy, but I am just seeing if this is a possibility.
I plan on cloning the server and upgrading the clone for testing.
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
You failed to specify if your 2003 server is 32 bit or 64 bit.  There is no 32 bit version of 2008 R2 and you cannot upgrade ANY 32 bit system to a 64 bit system.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
That's a good point Lee.
But if it's a Windows Server 2003 64bit then the upgrade to Windows Server 2008R2 won't have any impact in the SQL Server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.