WSS 3.0 - uninstall SQL Embedded, use SQL Workgroup Edition pros and cons

Discussion in 'Windows Small Business Server' started by tatat, Oct 3, 2007.

  1. tatat

    tatat Guest

    SBS 2003 Premium R2, WSS 3.0



    Are there any great advantages to using SQL Server Workgroup instead of the
    SQL Server Embedded Edition with WSS 3.0?



    I've run through the necessary steps on a test machine to make the switch
    including uninstalling WSS 3.0 and SQL Server Embedded Edition then
    installing SQL Server Workgroup Edition and reinstalling WSS 3.0,
    configuring full text search.



    I got the request to make the change because someone wants the ability to
    create reports using the SharePoint databases. I'm not sure that it's worth
    the trouble for the limited reporting capability alone. Any other pros or
    cons? Thanks
     
    tatat, Oct 3, 2007
    #1
    1. Advertisements

  2. tatat

    Costas Guest

    Costas, Oct 4, 2007
    #2
    1. Advertisements

  3. With Embedded Edition, you do not have those fancy tools to manage the
    database should you need to. Plus, you need to hack the registry in order
    to uninstall the Embedded Edition

    Uninstalling SQL Server 2005 Embedded Edition
    http://bassplayerdoc.spaces.live.com/blog/cns!CED2A18FB2A30E11!361.entry

    You won't see Embedded Edition in this site as this edition is not publicly
    available as a separate product
     
    bass_player [SBS-MVP], Oct 4, 2007
    #3
  4. tatat

    Costas Guest

    I should have clarified that the Embedded Edition is a named instance of SQL
    Express to avoid confusion

    --
    Costas


     
    Costas, Oct 4, 2007
    #4
  5. tatat

    tatat Guest

    Thanks for the link. From what I've determined from searching the Internet
    is the SQL Server Embedded Edition used with WSS 3.0 does not have a
    database size limit but I haven't seen any documentation from MS. In your
    own research have you found otherwise?
     
    tatat, Oct 4, 2007
    #5
  6. tatat

    Costas Guest

    I read about the no limit for the embedded version at a blog posting awhile
    back, but I haven't confirmed it. In my opinion, since the embedded edition
    is a named instance of SQL Server 2005 Express, the size limitation for the
    two versions is the same.
     
    Costas, Oct 4, 2007
    #6
  7. tatat

    tatat Guest

    I'll attempt to test it for myself by uploading 5 GB worth of data to a
    document library. Maximum file size for upload can be configured for up to
    2GB. I don't know if there will be other limitations like per document
    library or per site.
     
    tatat, Oct 4, 2007
    #7
  8. Embedded Edition is not a named instance of Express - these are two
    different things. As I've mentioned in my previous post, Embedded Edition is
    not "publicly" available as a stand-alone product that's why it's behavior
    is somehow different from the other versions. It is typically used by
    certain Microsoft products like WSS3.0 and future products, hence, the
    reason why the 4GB-database size limit does not apply.
     
    bass_player [SBS-MVP], Oct 5, 2007
    #8
  9. tatat

    Costas Guest

    Thanks for that information. I could swear I read that about EE being an
    instance of Express. I guess then it's different than the Compact Edition?
     
    Costas, Oct 5, 2007
    #9
  10. Compact Edition is also a different edition of the product. The difference
    between Embedded and Compact (as well as the other editions) is that
    Embedded is not available as a stand-alone product. With Compact, you can
    create LOB-applications on mobile/desktop/portable devices which can be
    configured to synchronize with a full-blown SQL Server 2005 instance.
    Embedded is simply used by MS products although you can still tweak it so
    that it behaves like a full blown-instance;-)
     
    bass_player [SBS-MVP], Oct 5, 2007
    #10
  11. tatat

    Costas Guest

    Thanks again for the info. I don't think you have any references towards
    'tweaking' the embedded, do you? :)

    With no limit on the max size, the possibilities are endless especially for
    small businesses who don't have the money for the Premium version of SBS
     
    Costas, Oct 5, 2007
    #11
  12. bass_player [SBS-MVP], Oct 6, 2007
    #12
  13. tatat

    Costas Guest

    Costas, Oct 6, 2007
    #13
    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.