Share via

Will Windows SharePoint Services Work With SQL Server 2005?

  • Article

The short answer:  Heck, yeah!

The long answer: For the love of God, don’t try it in production yet.  SQL Server 2005 hasn’t shipped.  But as we’ve been testing our beta code for WSS Service Pack 2, due out later this year, we’ve been testing it against SQL Server 2005 betas, and it appears to work just fine.  Our plan is to support SQL Server 2005 as a data store for the current shipping version of WSS if Service Pack 2 is applied.  Circumstances could force us to change those plans, but those are the plans.

I don’t yet know for certain if we’ll be able to say the same for Microsoft Office SharePoint Portal Server 2003.  I’ll tell you as soon as I get a ruling on it.

The next releases of SPS and WSS will both work with either SQL Server 2005 or SQL Server 2000.  We’re not going to make you upgrade everything in your server room.  That’d be mean.  We’re not mean.  Well, maybe a little:  there may be a few features in SPS, I believe, that will only activate if you have access to a copy of SQL Server 2005.  But that’d be about it.  SQL Server 2005 is great, and you should upgrade to it, but we won’t force you to do it against your will.

Heck, for that matter, if you haven’t heard it yet, the next version of Windows SharePoint Services will sitll run on Windows Server 2003. Ditto SharePoint Portal Server.

Comments

  • Anonymous
    July 18, 2005
    Mike Fitz hat ein paar Infos zum Thema funktioniert WSS mit SQL Server 2005 zusammengestellt.

    Generelle Aussage : JA

  • Anonymous
    July 24, 2005
    Hey there, I setup sql server 2005 somedays before I forgot what is the version and it asks for .net framework 2.0. From this point I guess currently 2005 cannot live with SPS because once I update to .net framework 2.0, the SPS dies coz 2.0 is not competible with 1.1. Because 2.0 is in beta so there is no compitiblility with 1.1, when it is release I think yes.

  • Anonymous
    July 25, 2005
    Read Mike's previous posting on .Net 2.0 and WSS. The short answer is that running 1.1 and 2.0 on the same machine and choosing 1.1 for WSS and 2.0 for SQL 2005 should work, but won't be supported until SP2 either.

  • Anonymous
    July 25, 2005
    Read Mike's previous posting on .Net 2.0 and WSS. The short answer is that running 1.1 and 2.0 on the same machine and choosing 1.1 for WSS and 2.0 for SQL 2005 should work, but won't be supported until SP2 either.

  • Anonymous
    July 29, 2005
    Hi Mike,

    We have developed a prototype system for generating and managing derivatives instrument transactions(Credit Default Swaps, Interest Rate Swaps) in FpML (Financial Products Markup Language)using InfoPath and WSS. These transactions are unique,highly complex, and undergo ongoing lifecycle events (payments, amendments, assignments) over long periods of time. We love WSS for the form library functionality that allows us to maintain and manage the FpML instance documents in an accessible way and using InfoPath for its presentation. We will need to do queries on all the FpML instance document nodes (i.e. payments due on certain dates among all transactions)in the database to generate additional FpML transactions (payment reconciliations). It seems that we should use SQL 2005 for the database because it supports XML natively with schemas. The question is, does WSS store (or be configured to store)the XML documents natively in SQL 2005? Thanks, Ira Fuchs

  • Anonymous
    August 18, 2005
    The comment has been removed

  • Anonymous
    August 18, 2005
    The comment has been removed

  • Anonymous
    October 19, 2005
    I have been monitoring this post for a week or so now. Do you have any update on whether SharePoint Portal Services will integrate well with SQL server 2005?

  • Anonymous
    November 04, 2005
    Hello, I've been working with SPS and WSS since 2004.
    I dont know if you tryed allready to connect SQL Server 2000 with SP4 directly (not SP3), to SPS and WSS, I recently did that and does not work, I had to install SQL Server 2000 SP3 and after that SP4 and everything went ok.

    Hope, SQL Server 2005 for test it...

    Luis Du Solier G
    http://spaces.msn.com/members/lduso
    http://www.sharepointblogs.com/ldusolier

  • Anonymous
    November 24, 2005
    I Just did the upgrade to SQL 2005 on an SBS 2003 Server. It took but I have found a couple issues with SharePoint now.

    The first issue that I found was that when creating a list you can no longer reorder your default view. Also you can not change your title name, your first field is going to be called title no matter what you do.

    The next thing that I found for newbies is the fact that you can no longer change your theme. So you are stuck with the basic theme.

    If anyone else finds any issues please let me know.

    Thanks

    Andrew Gray

  • Anonymous
    December 08, 2005
    We moved our sharepoint 2003 from SQL 2000 to SQL 2005 (Gold), and now the bacukp fails. It is now impossible to backup via the sharepoint tool. The site database cannot be backed up due to a problem with the index. We have a call into microsoft, until then we are doing SQL backups per MS. IF anyone sees this and knows a fix let me know!

  • Anonymous
    January 31, 2006
    Looks like SP2 for SPS 2003 makes SPS 2003 compatible with SQL 2005, .NET Framework 2.0 and ASP .NET 2.0.

    http://office.microsoft.com/en-us/assistance/HA100806971033.aspx

    Has anyone done this combination yet?

  • Anonymous
    January 31, 2006
    To my knowlege, SPPS is not yet .NET 2.0 compatable.

    WSS is.

  • Anonymous
    January 31, 2006
    Clarification:
    WSS = Windows Sharepoint Services
    SPPS = Sharepoit Portal Server

  • Anonymous
    February 10, 2006
    I now have SQL 2k5 implemented with Sharepoint deployment and am not having any problems. Here is an excerpt from a blog I read some info on:

    http://wss.sharepointtips.com/Lists/FAQ/DispForm.aspx?ID=498

    "Microsoft SQL Server 2005 includes features such as extended XML support and integrated CLR support. Windows SharePoint Services version 2.0 and SharePoint Portal Server 2003 do not take advantage of that new functionality; however, there are general benefits to upgrading to SQL Server 2005, such as better performance.

    SharePoint Portal Server and Windows SharePoint Services work equally well with either SQL Server 2000 or SQL Server 2005. SQL Server 2005 does not enable any new SharePoint Products and Technologies development scenarios. However, SQL Server 2005 does provide an improvement in performance, and SP2 enables Windows SharePoint Services to run with SQL Server 2005. How much performance improvement you can expect depends on the usage patterns of your users."


  • Anonymous
    February 24, 2006
    Has anyone seen any published steps to move wss config and content dbs to a SQL 2005 server?  Or do we just copy them over and change them in the central admin...

  • Anonymous
    March 27, 2008
    PingBack from http://employmentwagesblog.info/fitzblog-will-windows-sharepoint-services-work-with-sql-server-2005/

  • Anonymous
    June 15, 2009
    PingBack from http://workfromhomecareer.info/story.php?id=31193

  • Anonymous
    June 16, 2009
    PingBack from http://fixmycrediteasily.info/story.php?id=236