Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS 2003 and SQL Server 2005

  Asked By: Keaton    Date: Nov 27    Category: Sharepoint    Views: 1113

I know SQL Server 2000 is the recommended DBMS to use
with SPS 2003. Are there any issues or side-effects
with using SQL Server 2005 instead?



6 Answers Found

Answer #1    Answered By: Alison West     Answered On: Nov 27

Its a bugger to install

You need to be on sps  2003 sp2 for it to work

Answer #2    Answered By: Freddy Heath     Answered On: Nov 27

Like the others have said, it's difficult to install, but after the installation it works fine. You do need to have SPS2003 SP2 installed in order to use SQL2005. The way that i did this was install SPS2003, and when the browser opens for the configuration step close the browser. Install SP2, and then run the SPS System Administration from the Admin Tools menu. Then perform the configuration as you normally would with SQL2000. Install SQL 2005 before you get started with the SP install.

Answer #3    Answered By: Joanna Dixon     Answered On: Nov 27

The only other issue you get is with the backup and restore client for SharePoint. If it is single box then it should be OK, if your SQL 2005 server  is another server then you will need to remove the SQL 2000 Client Tools and install the SQL 2005 ones in order for the backup and restore functionality of SPS2003 to work. Apart from that works like a treat.

Answer #4    Answered By: Justine Barrera     Answered On: Nov 27

Are there any good intructions/steps to change an existing SPS2003
SP2 installation to use upgraded (SQL2005) databases? We won't re-
install but were told upgrading to SQL 2005 first would be a good
step towards a MOSS upgrade next year.

Answer #5    Answered By: Sharonda Mcfarland     Answered On: Nov 27

I have not come across any in-depth instructions on how to upgrade from SQL 2000 to SQL 2005 for SharePoint 2003 SP2. For myself I just did it as a test on a VPC when it first came out and never looked back since. So far in the past installs I have done since it has worked fine with no problems. As far as upgrading before going to MOSS good idea but remember you can still run MOSS on SQL 2000 if you want to. Could be an idea to upgrade to MOSS, install a new DB server  and backup and restore the DB’s to the new SQL 2005 server and then re-point MOS to the new server. Just an idea really. It is much safer however to do the DB upgrade than the MOSS upgrade, this is only due to the fact that MOSS isn’t fully released yet and of course not many people will have actually done an upgrade. I can tell you it does work really well though.

Answer #6    Answered By: Cory Brooks     Answered On: Nov 27

I believe we have a white paper on the SQL upgrade part in our premium content area, www.mindsharp.com.

Didn't find what you were looking for? Find more on SPS 2003 and SQL Server 2005 Or get search suggestion and latest updates.