| Author |
Message |
Guest
|
Posted:
Sat Oct 29, 2005 4:50 pm Post subject:
SPS 2003 with SQL 2005 |
|
|
Can SPS 2003 use SQL 2005 as the database, nd is it supported or when will
it be supported?
Thank you. |
|
| Back to top |
|
 |
Shane Young [SPS MVP]
Guest
|
Posted:
Sat Oct 29, 2005 8:50 pm Post subject:
Re: SPS 2003 with SQL 2005 |
|
|
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@msn.com> wrote in message
news:OHniEAK3FHA.3052@TK2MSFTNGP10.phx.gbl...
| Quote: | Can SPS 2003 use SQL 2005 as the database, nd is it supported or when will
it be supported?
Thank you.
|
|
|
| Back to top |
|
 |
bsimser
Joined: 22 Jul 2005
Posts: 175
|
Posted:
Mon Oct 31, 2005 5:51 pm Post subject:
Re: SPS 2003 with SQL 2005 |
|
|
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@TK2MSFTNGP10.phx.gbl:
| Quote: | 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@msn.com> wrote in message
news:OHniEAK3FHA.3052@TK2MSFTNGP10.phx.gbl...
Can SPS 2003 use SQL 2005 as the database, nd is it supported or when
will
it be supported?
Thank you.
|
|
|
| Back to top |
|
 |
Geoffrey [MSFT]
Guest
|
Posted:
Tue Nov 01, 2005 5:51 pm Post subject:
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@shaw.ca> wrote in message
news:%23Bx5G5i3FHA.3592@TK2MSFTNGP12.phx.gbl...
| Quote: | 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@TK2MSFTNGP10.phx.gbl:
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@msn.com> wrote in message
news:OHniEAK3FHA.3052@TK2MSFTNGP10.phx.gbl...
Can SPS 2003 use SQL 2005 as the database, nd is it supported or when
will
it be supported?
Thank you.
|
|
|
| Back to top |
|
 |
Wolfeitz
Guest
|
Posted:
Tue Nov 08, 2005 9:51 pm Post subject:
Re: SPS 2003 with SQL 2005 |
|
|
According to a SQL 2005 High-Availability Demo
(http://www.microsoft.com/sql/prodinfo/demo/high-availability-demo.mspx),
the high availability aspect of SQL 2005 requires that you add about 10
lines of code to the application. Does anyone know if SPS 2003
supports SQL 2005 high-availability? Any idea what/where those 10
mythical lines of code go? |
|
| Back to top |
|
 |
|
|
|
|