Solved

Upgrading from SBS2003 Standard SP1 to SBS2003 R2 Premium

Posted on 2008-06-15
6
992 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 9

Accepted Solution

by:
waynewilliams earned 500 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
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 
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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

687 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