locked
Sharepoints Services Limitations for MS SQL Server? RRS feed

  • Question

  • Microsoft has SharePoint product.  There are few types.  One is the server and the other one is the services.

    The difference are the pricing and the features.

    What I need to find out is that if I use the SharePoint services, will I be able to utilize SQL servers?

    The services has a limitation.  For small operations, it works okay as it is free.

    However, if the database requires a lot more, then this service might not work.

    Therefore, I don’t want to find out in the future that it won’t work.  I would like to find out what are the limitation (I believe that it is the database size) and if we can use SQL server for the SharePoint services.

     

    So the final answer would be.  If I use the SharePoint services will I run into the database problem.  Another word, will I be able to use a standard SQL server?  What is the difference between the SharePoint Servers and Services.

    • Edited by Mike Walsh FIN Friday, January 30, 2009 8:10 AM . Please Help. removed from Subject. Meaningless.
    Friday, January 30, 2009 6:26 AM

Answers

  • WSS 3.0 can use the same database systems to store its databases as MOSS 2007.

    The only difference is the Basic Installation where WSS 3.0 uses the size-unlimited Windows Internal Database version of SQL Server 2005 Express and MOSS 2007 uses the embedded but otherwise normal version of SQL Server 2005 Express with the 4GB size limit for databases.

    But Advanced installations of both WSS 3.0 and MOSS 2007 can use SQL Server 2K, 2005 or 2008.

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

    The are two many differences between WSS 3.0 and MOSS 2007 to be answered here. Look for the Microsoft paper comparing the two at www.microsoft.com/sharepoint

    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
    • Proposed as answer by Daniel Bugday Friday, January 30, 2009 9:12 AM
    • Marked as answer by Paul Galvin Friday, January 30, 2009 8:25 PM
    Friday, January 30, 2009 8:13 AM