Re: SPS 2003 with SQL 2005

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: SQL difference - mySQL and MS SQL
    ... What is the difference between query language for mySQL and MS SQL? ... version 4 is nowhere near Microsoft SQL Server (in any version I've ... Lacking support for referential integrity ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL difference - mySQL and MS SQL
    ... What is the difference between query language for mySQL and MS SQL? ... version 4 is nowhere near Microsoft SQL Server (in any version I've ... Lacking support for referential integrity ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL difference - mySQL and MS SQL
    ... They just added support for things such as stored ... why Ole mentioned the version of MySQL making a difference. ... What is the difference between query language for mySQL and MS SQL? ... version 4 is nowhere near Microsoft SQL Server (in any version I've ...
    (microsoft.public.sqlserver.connect)
  • Re: SPS 2003 with SQL 2005
    ... To apply Sharepoint Portals Server SP2, ... > you must first apply Windows Sharepoint Services SP2. ... > Sharepoint Services SP2 enables support for SQL 2005. ... Microsoft SQL Server 2000 Enterprise Edition, ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Install Sql2005 Instance on Cluster
    ... Principal SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... 1>i cannot use the same group iwill have to request new ip /n/w name and disk. ... what the client wants to do is install another instance of SQL 2005 on the same virtual server. ...
    (microsoft.public.sqlserver.clustering)