Icon explained    
Articles marked with this logo are 'subscriber' only articles. Click here to become a subscriber
Small Business Server articles and howto's    

Current Articles | Search

SBS 2003 R2 - Upgrading the Sharepoint MSDE instance to SQL 2005
By Mariette Knap :: 7 Comments :: :: SBS 2003, Public articles, SBS 2003 R2, SQL 2005
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.
Create the SQL Server 2005 Workgroup Edition SHAREPOINT instance
  1. From the Autorun page of Premium Technologies Disc 1 (D:\Setup.exe, where D is the letter of your CD drive), click Install Microsoft SQL Server 2005 (Figure 1).


    Figure 1 - Install SQL Server 2005

  2. On the End User License Agreement page, review the licensing agreement (Figure 2). To continue, you must accept the agreement.


    Figure 2 - Accept the EULA

  3. On the Installing Prerequisites page click Install (Figure 3). SQL Server 2005 Setup installs the components that are required for SQL Server setup. When it finishes installing them, click Next (Figure 4).


    Figure 3 - Additional components will be installed.


    Figure 4 - Setup has installed the additional components, click next.

  4. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next (Figure 5).


    Figure 5 - click next.

  5. On the System Configuration Check page, verify that you have no potential installation problems, then click Next.


    Figure 6 - confirm that everything is OK and click next.

  6. If this is the first instance of SQL Server 2005 that you are installing or upgrading, the Registration Information page appears (Figure 7). By default, Setup automatically enters the product key for you. Enter your Name and Company information, and then click Next.


    Figure 7 - Fill in if something is missing.

  7. On the Feature Selection page, click SQL Server Database Services and then click Entire feature (Figure 8) will be installed on local hard drive. Expand SQL Server Database Services and ensure that all sub-features, including Full-Text Search, are set to install (Figure 9).


    Figure 8 - Select 'Entire feature..' will be installed.


    Figure 9 - make sure that full text search is installed.

  8. While still on the Feature Selection page, expand Client Components, click Management Tools, and then click Entire feature (Figure 10) will be installed on local hard drive. By default, Setup also selects Connectivity Components and SQLXML Client Features for installation. Click Next.


    Figure 10 - install Management Tools

  9. On the Instance Name page (Figure 11), click Named instance. In the Named instance box, type SHAREPOINT.


    Figure 11 - Create a new Sharepoint instance.

  10. On the Service Account page (Figure 12), click Use the built-in System account, and then click Local system for the account. Click Next.


    Figure 12 - Set the Service Account.

  11. On the Authentication Mode page (Figure 13), choose Windows Authentication Mode. Click Next.


    Figure 13 - Set Authentication Mode.

  12. On the Collation Settings page (Figure 14), accept the default of Dictionary order, case-insensitive, for use with 1252 Character Set for SQL collations (used for compatibility with previous versions of SQL Server). Click Next.


    Figure 14 - Set Collation Settings.

  13. When the Error and Usage Report Settings page appears (Figure 15), you can choose to automatically send error reports to Microsoft or to your corporate error-reporting server. You can also choose to send data about feature usage for SQL Server 2005 to Microsoft. Click Next.


    Figure 15 - Set Error and Usage Report settings.

  14. On the Ready to Install page (Figure 16), click Install.


    Figure 16 - Ready to install

  15. When SQL Server 2005 Setup prompts (Figure 17) you to "Please insert Disc 2," insert Premium Technologies Disc 2, and then click OK.


    Figure 17 - Insert Dics 2

  16. Click Next when that button becomes available on the Setup Progress page (Figure 18).


    Figure 18 - Click next.

  17. On the Completing Microsoft SQL Server 2005 Setup page (Figure 19), click Finish.


    Figure 19 - Click finish

Previous Page | Next Page
Comments
By Chester Hull @ Tuesday, September 26, 2006 4:01 PM
Hello, I tried to download the PDF from http://www.smallbizserver.net/tabid/228/Default.aspx, but the file doesn't have any extension, and Adobe doesn't recognize it when I rename it to a .pdf.

Also, I tried downloading several of the scripts a tools, and had similar issues. Obviously they aren't PDF's, but I have no idea WHAT type of file they are.

Am I missing something here? Thanks!

By Mariette Knap @ Tuesday, September 26, 2006 4:03 PM
All files are zipped and inside you will find the pdf.

By Doug Burrows @ Sunday, November 05, 2006 10:31 PM
I Installed SBS 2003 R2 as a new installation. Do I still do this or is this for upgrades to R2 from SBS 2003 SP1?

By Mariette Knap @ Sunday, November 05, 2006 10:45 PM
Yes, a default R2 installation does not upgrade a Sharepoint site with SQL. You need to follow this doc but only if your Sharepoint is based on MSDE. If your server is upgraded with SQL 2000 you need to read the readme. A detailed doc about this will follow later.

By Davin Biggs @ Wednesday, December 13, 2006 2:57 AM
Thanks Mariette, this is great for new R2 installs.

I've now got a 2003 SP1 Premium to R2 Premium upgrade where they have converted Sharepoint to SQL 2000. Was wondering exactly which Readme you are referring to, and if the detailed article is still on the cards.

Cheers, Davin

By Mariette Knap @ Wednesday, December 13, 2006 9:49 PM
Davin,

Yes, that article has still to be finished. The upgrade from already upgraded to SQL 2000 and then to SQL 2005 is a bit more work. The readme should be on the CD where SQL 2005 is. I find the readme not very clear though but seems to be the case with a lot of MS readme's

By Dale McCabe @ Friday, February 02, 2007 4:21 AM
That article was straight forward and effective however I am prompted for localhost/administrator credentials when trying to start the central administration tool to complete "timer" settings. This also occurs with trying to access "companyweb"?

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