[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Upgrading from SBS2003 Standard SP1 to SBS2003 R2 Premium

Posted on 2008-06-15
6
Medium Priority
?
998 Views
Last Modified: 2012-08-13
hi all,

I have a client who runs a SBS2003 Standard SP1 box.  They need to run SQL Server 2005 so it seems to me the most cost effective way to do that is for them to upgrade to SBS2003 R2 Premium which includes SQL Server 2005 on the Premium Technologies CD.  I just need to confirm the upgrade path.  From what i can see, none of the SBS upgrade products will jump straight from SBS2003 SP1 Standard to Premium R2.  It would appear I first need to upgrade to 2003 R2 Standard (via Microsoft product id T72-01415) then go from R2 Standard to R2 Premium via another upgrade pack (T75-01260).

Can anyone confirm if this is the correct path to perform this migration?  I'm trying to avoid having to install R2 Premium on a new box and migrate everything over.  It's only a small busines with 8 PCs and very basic AD structure so i don't see an issue.

ta
nathan
0
Comment
Question by:natrat22
  • 3
  • 3
6 Comments
 
LVL 9

Accepted Solution

by:
waynewilliams earned 2000 total points
ID: 21788857
Hi,
You dont need to perform a full upgrade of SBS.
The only difference between R1 and R2 SBS is 1 disc which has Service Pack 2 for Exchange,

Sharepoint Service Pack and R2 (which is basically just MMC3.0 and WSUS as well as a few other bits).

The only difference between standard and premium is the Premium Technologies CD which just had SQL and ISA on it.

All you woud need to buy is T75-01260 and you will have all you need.  You dont even need to use the R2 disc if you dont want to. You can just use the Premium Technologies CD to install SQL.  I have done this myself recently so I know it works.
0
 
LVL 1

Author Comment

by:natrat22
ID: 21789864
Wayne, thats great, thank for the info.  Does the DSQL Server 2005 install ask for a product key then?  And you just use the one that comeswith the R2 product?
0
 
LVL 1

Author Comment

by:natrat22
ID: 21790554
Oh and how does the licensing work for SQL 2005?  Will it use the SBS licenses from Standard SP1?  Or at some point do i need to enter the licernse for SBS R2 Premium?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 9

Expert Comment

by:waynewilliams
ID: 21791451
As far a i recall the SBS Version of SQL just needs the SBS Premium product key to install (you will get this with the upgrade pack).

Your SBS Cal's will cover the SQL server as well.
0
 
LVL 1

Author Comment

by:natrat22
ID: 21830243
Ok well i've installed SQL Server 2005 from the SBS2003 R2 Premium upgrade CD - it detected my existing trial install of the SQL 2005 STandard edition and even warned me that installing the Workgroup edition would mean i would lose some features.  It was a bit strange though - it automatically had pre-filled in a product key.  That key wasnt the same as the SBS premium R2 key and I don't think i had to enter a trial product key, so I'm presuming that the key is included within the SBS SQL install?   I'm hoping it's all going to be fine now when the trial would have run out, there doesn't seem to be any way of checking whether i am on a trial or not now, or how many licenses I have.
0
 
LVL 9

Expert Comment

by:waynewilliams
ID: 21832187
Yes I forgot that the product key is pre-filled.  You are now on full version.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Loops Section Overview
Suggested Courses
Course of the Month17 days, 15 hours left to enroll

831 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