How to upgrade Sharepoint to SQL 2000

By Mariette Knap :: 18 Comments ::

:: Service Packs, Server issues, SBS 2003, Sharepoint, SQL 2000, Public articles

TERMS
This document and what comes with it are provided as-is with blunt warning: Use at your own risk, buyer beware. You break your system; you own the resolution as well. We have no liability for what you do, or can't do, or fail to do with this information. Your entire protection is to start over again with a protected backup, or from protected system. If you don't want to accept this idea, please don't use this document.
Install SP4 for SQL 2000 We still need to install Service Pack 4 for SQL 2000 on the server. We do this from the Premium Technology CD. Choose to install SQL Server 2000 Service Pack 4. Choose a folder where you want extract SP4. Note that if you install SP4 for SQL 2000 from Gold SBS 2003 Media (not SP1 integrated) you will not see the extraction window and SP4 installation will start immediately. Setup starts...click next. Click yes to accept the EULA. Select the Sharepoint instance and choose next. Select the 'Windows account' and click next. You may choose to send error reports to Microsoft, choose OK. Choose next. Setup runs the upgrade scripts. Setup warns you that the databases have been changed and that you should backup. Setup is finished, click Finish.

Paging - Page: 2 of 3
	Previous Page \| Next Page

Comments

By Paul Beckman @ Sunday, May 07, 2006 10:38 PM

I have SQL server with all latest services packs installed running several databases.
Do I still need to do the full installation of SQL as described to upgrade my sharepoint? I'm just concerned it might mess up my current installation.
Thanks for the great article.

By Mariette Knap @ Sunday, May 07, 2006 10:42 PM

Hi Paul,

If you want to upgrade Sharepoint you need to follow the steps in the document but only for the Sharepoint instance. Nothing to worry about, I have done this many times even with multiple other instances running.

By Paul Beckman @ Sunday, May 07, 2006 10:50 PM

Thankyou!

By Rene Leussink @ Monday, May 08, 2006 8:40 AM

Perfect description (as always).
But now I also want to make the .pdf files I've stored searchable. At SMB Nation there was a presentation (which by the way STILL aren't available for downloading)
where you'd have to add somthing to get this to work..
maybe you know how to do this mariette?
kind regards,
Rene Leussink

By Paul Beckman @ Monday, May 08, 2006 9:06 AM

I've been preparing to do this today and realised through reading that the screens in the article seem to indicate SBS 2003 without SP1.
I have SP1 installed and wondered if we should be working from the original install disks or the SP1 disks?
Hope this doesn't sound like a stupid question and clarifies the point for anyone else interested in doing this.
Many thanks in advance.

By Mariette Knap @ Monday, May 08, 2006 11:47 AM

Rene, I will make another article for that but I am currently working at a client for this week...you will have to wait till next weekend,

By Mariette Knap @ Monday, May 08, 2006 11:49 AM

Paul,

On the SP1 disks (not the integrated media) you do not have the full SQL 2000 installation files. You should use the Gold media for that. After you have upgraded your Sharepoint instance you will need to use the SP1 media to upgrade SQL 2000 to SP4.

By Don Tibbits @ Monday, May 08, 2006 2:36 PM

Is full text search capability the only advantage of upgrading SharePoint to full SQL? Would there be any point upgrading other instances eg SBS Monitoring?
Thanks, great site!

By Paul Beckman @ Tuesday, May 09, 2006 6:29 AM

Thankyou for clarifying that, makes sense now.

By George Simos @ Tuesday, May 09, 2006 11:23 PM

Hello,

I'm having a question, what is the SQL Server Switch under the program files group of SQL 2000?

Thank you in advance,

George

By Paul Beckman @ Wednesday, May 10, 2006 5:40 AM

Just thought I'd feedback that I performed this procedure today as per this article without any problems at all.
Very interested now in the PDF search?
Thanks again for a great article.

By Paul Beckman @ Wednesday, May 10, 2006 5:51 AM

Hi George,
If you are refering to the SQL Server Upgrade Wizard accessed from the All Programs menu "MS SQL Server - Switch" this is a wizard that transfers single 6.5 SQL Server databases to SQL 2000.

By George Simos @ Wednesday, May 10, 2006 12:09 PM

Thank you Paul, this was a good answer!

By Nick Pieters @ Monday, June 12, 2006 1:01 PM

Is it just me or is the link not correct?

I mean if follow the steps i'm on the site with port 6120, this is why i could not find the full text search function.

If i go to sbserver:8081 i get the "correct website" showed above...

By Suresh Fernandes @ Saturday, June 17, 2006 7:27 PM

Nice article, but you might want to update it with instructions for doing this upgrade on a localized SBS2003. I ran into trouble after upgrading the instance and then trying to apply SP4 due to language incompatibilities. (There actually is a seperate readme on this on the premium disc.)

By Tony LaRue @ Sunday, July 16, 2006 12:16 AM

Like butter!!! The only slowdown for me was finding the "Full Text Search" option, but I found it in maybe 10 seconds...well done ladies!

By Rick Stack @ Tuesday, August 22, 2006 7:40 PM

Hi, I did this process and seemed to go through without a hitch, but in the end I still seem to be running WMSDE not SQL Server 2000? Anyone with any ideas?

By Mariette Knap @ Tuesday, August 22, 2006 7:44 PM

Please, post your question in the forum

You must be logged in to post a comment. You can login here