Can I install SQL 2005 on SBS 2003 Premium

Discussion in 'Windows Small Business Server' started by David, Aug 1, 2006.

  1. David

    David Guest

    Can I install SQL 2005 on my Small Business Server 2003 Premium? If so what
    version(s) of SQL will work, Express, Workgroups or Standard?

    Are there other issues I might encounter since SQL 2000 is installed with
    SBS 2003?

    Thanks,

    David
     
    David, Aug 1, 2006
    #1
    1. Advertisements

  2. As Cris suggests, SBS2003 R2 will come with SQL 2005 Workgroup, which gives
    you proper SBS CAL rights for use. Otherwise, if you want SQL 2005 Std, you
    have to deal with CALS separately.
     
    Kevin Weilbacher [SBS-MVP], Aug 1, 2006
    #2
    1. Advertisements

  3. As Chris and Kevin point out, R2 will come with the Workgroup version of SQL
    2005. If you need to still maintain existing SQL 2000 databases, you can add
    SQL 2005 without upgrading to R2. You'll have to add the CALs for it,
    however. If you go the R2 route, you get the CALs, but you have to remove
    SQL 2000 (or get new CALs for it.)
     
    Charlie Russel - MVP, Aug 1, 2006
    #3
  4. David

    thejamie Guest

    David,

    SBS gives you a network. SQL strains SBS so why not forget about SQL
    altogether on your SBS domain computer.

    FYI, my configuration is the SBS Premium, but I never install the SQL just
    the ISA and run SQL from another server in the network. It actually runs SQL
    2008 at this time.
     
    thejamie, May 9, 2009
    #4
  5. That's not necessarily good advice. If it's a hefty machine and the expected
    SQL usage is small, there should be no problem.
    Unless you have a separate license for SQL, you can't do this.
     
    Lanwench [MVP - Exchange], May 9, 2009
    #5
  6. Agreeing with LW. You can add RAM to a SBS for very little cost, and use
    the procedures found below to control the amount of RAM SQL uses. If you
    watch the CPU use in Task Manager, you should see that the CPU(s) are
    coasting most of the time.

    http://blogs.technet.com/asksbs/arc...ing-high-memory-usage-by-a-msde-instance.aspx

    http://msmvps.com/blogs/bradley/archive/2007/12/25/adjusting-sql-embedded-instances.aspx

    http://msmvps.com/blogs/bradley/archive/tags/Allocated+Memory/default.aspx

    --
    Larry
    Please post the resolution to your
    issue so that others may benefit.


    "Lanwench [MVP - Exchange]"
     
    Larry Struckmeyer [SBS MVP], May 10, 2009
    #6
  7. David

    dubey Guest

    I hope you have room for backward compatibiltiy. Am just crawling my way
    behind you guys although am 3 years backward...but at least am still moving.

    Please, can I still get an upgrade from SBS 2003 to SBS 2003 R2

    Thanks
     
    dubey, Sep 1, 2009
    #7
  8. Doubtful. Check ebay, maybe.
     
    Lanwench [MVP - Exchange], Sep 1, 2009
    #8
  9. Pricing for Windows Small Business Server 2003 R2
    http://www.microsoft.com/windowsserver2003/sbs/howtobuy/pricing.mspx
    ------------------------------
    Version Upgrade* (from SBS versions 4.0, 4.5, 2000, or 2003 Premium to
    Windows Small Business Server 2003 R2 Premium Edition)
    $699 T75-01256


    ------------------------------

    Upgrade Version Windows 2003 SBS Premium 5-Client Access License
    http://www.provantage.com/microsoft-t75-01256~4MCSB0HC.htm

    --
    Merv Porter [SBS-MVP]
    ============================

     
    Merv Porter [SBS-MVP], Sep 2, 2009
    #9
  10. David

    dubey Guest

    Thanks fr the information.
    Please, does SQL server 2005 workgroup edition come in the package of
    Version Upgrade T75-01256. Or do I have to purchase SQL Server 2005
    seperately?

     
    dubey, Sep 14, 2009
    #10
  11. Yes, it includes SQL server 2005 Workgroup Edition.

    SBS 2003 R2: Features at a Glance
    http://www.microsoft.com/windowsserver2003/sbs/evaluation/features/default.mspx

    --
    Merv Porter [SBS-MVP]
    ============================

     
    Merv Porter [SBS-MVP], Sep 14, 2009
    #11
  12. David

    dubey Guest

    Thank you sir.

     
    dubey, Sep 15, 2009
    #12
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.