• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1003
  • Last Modified:

Upgrading from SBS2003 Standard SP1 to SBS2003 R2 Premium

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
natrat22
Asked:
natrat22
  • 3
  • 3
1 Solution
 
waynewilliamsCommented:
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
 
natrat22Author Commented:
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
 
natrat22Author Commented:
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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
waynewilliamsCommented:
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
 
natrat22Author Commented:
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
 
waynewilliamsCommented:
Yes I forgot that the product key is pre-filled.  You are now on full version.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now