Re: SPS 2003 with SQL 2005

Would this mean that the initial installation would need to be SQL 2000 and
then upgraded to 2005? through the use of SP2 for SPS and WSS?

"Geoffrey [MSFT]" wrote:

> SQL 2005 is a supported database. To apply Sharepoint Portals Server SP2,
> you must first apply Windows Sharepoint Services SP2. Applying Windows
> Sharepoint Services SP2 enables support for SQL 2005.
>
> (Excerpted from the WSS SP2 Download page:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=B922B28D-806A-427B-A4C5-AB0F1AA0F7F9&displaylang=en)
>
> Server databases
> One of the following versions of Microsoft SQLT Server:
> a.. Microsoft SQL Server 2000, with the latest service pack
> b.. Microsoft SQL Server 2000 Enterprise Edition, with the latest service
> pack
> c.. Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
> d.. Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE)
> e.. Microsoft SQL Server 2005 Standard Edition
> f.. Microsoft SQL Server 2005 Enterprise Edition
> g.. Microsoft SQL Server 2005 Workgroup Edition
>
> --
> ----------------------------------------
> Geoffrey Edge, Portals Technology Specialist
> Microsoft Communications Sector North America
>
> "Bil Simser [SPS MVP]" <bsimser@xxxxxxx> wrote in message
> news:%23Bx5G5i3FHA.3592@xxxxxxxxxxxxxxxxxxxxxxx
> >I think Fitz had a later post about it being supported and now that it's
> >RTM (released to manufacturing) it should be supported.
> >
> > As for working, all my development setups for WSS and SPS are now running
> > on SQL 2005 without a problem.
> >
> > --
> > Bil Simser
> > SharePoint MVP, BSc., MCSD
> > Calgary, Alberta
> > http://weblogs.asp.net/bsimser
> >
> >
> >
> > "Shane Young [SPS MVP]" <Shane @ SharePoint911 dot com> wrote in message
> > news:e8USkcL3FHA.3276@xxxxxxxxxxxxxxxxxxxx:
> >
> >> Maybe? I heard rumors that if you had SharePoint SP2 then it would
> >> support
> >> SQL 2005 but I haven't seen anything official yet. Of course since SQL
> >> 2005
> >> isn't officially released yet I would say not to run anything but test
> >> portals on it.
> >>
> >> Here is what Fitz said about it.
> >> http://blogs.msdn.com/mikefitz/archive/2005/07/15/439489.aspx
> >>
> >> And you will notice the SP2 documentation does NOT make any mention of
> >> SQL
> >> 2005.
> >>
> >>
> >> --
> >> Shane Young - Now with MVP power
> >> SharePoint911 - "SharePoint Help...Now!"
> >> http://www.SharePoint911.com
> >>
> >>
> >> "<<JP>>" <jp@xxxxxxx> wrote in message
> >> news:OHniEAK3FHA.3052@xxxxxxxxxxxxxxxxxxxxxxx
> >>
> >> > Can SPS 2003 use SQL 2005 as the database, nd is it supported or when
> >> will
> >> > it be supported?
> >> >
> >> > Thank you.
> >> >
> >
>
>
>
.

Relevant Pages

  • Re: SPS 2003 with SQL 2005
    ... Sharepoint Services SP2 enables support for SQL 2005. ... Microsoft SQL Server 2000 Enterprise Edition, ...
    (microsoft.public.sharepoint.portalserver)
  • Ent MS Svr 2003, Ent MS SQL Svr 2005, SQL SP2 failed at end
    ... I have a Enterprise edition Server 2003 running the Enterprise Edition of SQL ... I recently upgraded the MS Server 2003 to SP2, we also have the SQL Express ...
    (microsoft.public.sqlserver.setup)
  • Re: cannot see SQL Jobs on remote server
    ... Now I installed SP2 for SQL Server and the problem ... Try applying SQL ... Server 2005 SP2 on your PC. ...
    (microsoft.public.sqlserver.connect)
  • Re: Ent MS Svr 2003, Ent MS SQL Svr 2005, SQL SP2 failed at end
    ... I never, ever, EVER try to install anything from a file server. ... I recently upgraded the MS Server 2003 to SP2, we also have the SQL Express ...
    (microsoft.public.sqlserver.setup)
  • Re: Management Studio & Summary Reports
    ... (SP2) running against SQL Standard Edition SP2 and the ... call it MS2, has a tab named Object Explorer Details ... Was the Reports function moved in SP2? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)