Avatar of RSchalhoub
RSchalhoub
Flag for United States of America asked on

"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
Windows Server 2008Windows Server 2003Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
JestersGrind

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
Kent Olsen

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.
RSchalhoub

ASKER
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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
JestersGrind

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Lee W, MVP

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

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.