Upgrading SharePoint to Use SQL Server

---

Use the following steps to upgrade the SharePoint Microsoft SQL Server Desktop Engine (MSDE) to a full-fledged SQL Server instance and install SQL Server 2000 Service Pack 3a.

1. Open Services from the Administrative Tools folder on the Start menu and verify that the MSSQL$SHAREPOINT service is stopped. If the service isn’t stopped, select it and click the Stop Service toolbar button.

2. Insert the Windows Small Business Server 2003 Premium Technologies CD. The Microsoft Windows Small Business Server 2003 Premium Technologies Setup window appears.

3. Click Install Microsoft SQL Server 2000. A dialog box appears warning that SQL Server 2000 SP2 and earlier are unsupported. Click Continue and then click Next on the first page of the Microsoft SQL Server Installation Wizard.

4. On the Computer Name page, click Next to install SQL Server on the local computer (the only supported configuration in Windows Small Business Server 2003).

   Tip 

   If you have trouble getting past the Computer Name page because Setup insists that a previous installation didn’t complete, reboot the server and log on locally (not using Remote Desktop).

5. On the Installation Selection page, choose Upgrade, Remove Or Add Components To An Existing Instance Of SQL Server and then click Next.

   Note 

   You can only install or upgrade a single instance at a time. To install or upgrade another instance, you need to rerun the Microsoft SQL Server Installation Wizard.

6. If the Product Key page appears, type the CD key from the Windows Small Business Server 2003 packaging and then click Next. (This page appears only when installing or upgrading the first instance.)

7. On the Instance Name page (Figure B-7), clear the Default check box, select SHAREPOINT from the Instance Name box (don’t upgrade the SBSMONITORING instance), and then click Next.

   
   Figure B-7: The Instance Name page.

8. On the Existing Installation page, select Upgrade Your Existing Installation and then click Next.

9. On the Upgrade page, select the Yes Upgrade My Programs check box and then click Next. If a dialog box appears asking whether you want to install additional components, click Yes.

10. On the Select Components page, make sure that Full-Text Search, Management Tools, and Books Online are selected, and then click Next.

11. On the Start Copying Files page, click Next to upgrade SharePoint to use SQL Server.

    Note 

    If the installation appears to hang and displays the message “Setup is preparing to copy files” for an extended length of time, it might be because the MSSQL$SHAREPOINT service is running. Stop the service, and the installation should continue.

12. After installation completes, click Finish.

13. Double-click Setup.exe on the Windows Small Business Server 2003 Premium Technologies CD. The Microsoft Windows Small Business Server 2003 Premium Technologies Setup window appears again.

14. Click Install SQL Server 2000 Service Pack 3a. When the Welcome page of the Microsoft SQL Server 2000 Service Pack 3a Wizard appears, click Next.

    Note 

    You must install Service Pack 3a on every SQL Server instance that you install or upgrade. For example, if you install a default instance of SQL Server to store business data and you upgrade the SharePoint database to SQL Server, install Service Pack 3a twice: once to the default instance and once to the SharePoint instance.

15. Read the standard Microsoft license agreement, and then click Yes to continue.

16. On the Instance Name page, clear the Default check box and then select SHAREPOINT from the Instance Name box. Click Next to continue.

17. On the Connect To Server page, select The Windows Account Information I Use To Log On To My Computer With (Windows Authentication) option and then click Next.

18. If the SA Password Warning page appears, type a secure password for the System Administrator (SA), and then click OK.

    Security Alert 

    The System Administrator login is present for backwards compatibility with earlier versions of SQL Server and is disabled while Windows authentication mode is used. However, if an administrator reconfigures SQL Server for mixed mode authentication, SQL Server enables the SA login, which has a blank password by default (essentially rolling out the red carpet for hackers). Because of this potential vulnerability, always set a strong SA password, even if you never plan on switching authentication modes.

19. On the Backward Compatibility Checklist page, make sure the check box is cleared to disable cross-database ownership chaining, thereby improving security. Click Continue.

20. On the Error Reporting page, optionally select the Automatically Send Fatal Error Reports To Microsoft check box to send error information to Microsoft, and then click OK.

21. On the Start Copying Files page, click Next to install SQL Server 2000 Service Pack 3a.

22. After installation completes, a dialog box appears telling you to back up the SQL databases. Click OK, and then click Finish on the Setup Complete page.

23. Open Services from the Administrative Tools folder on the Start menu and verify that the MSSQL$SHAREPOINT services is started. If the service isn’t started, select it and click the Start Service toolbar button.

24. Click Start, and then choose All Programs, Microsoft SQL Server, and Enterprise Manager. The SQL Server Enterprise Manager console appears.

25. Expand the Microsoft SQL Servers container, right-click SQL Server Group, and then choose New SQL Server Registration from the shortcut menu. When the Register SQL Server Wizard appears, click Next.

26. On the Select A SQL Server page shown in Figure B-8, type SBSSRV\SHAREPOINT in the Available Servers box and then click Add (assuming the name of the Windows Small Business Server computer is SBSSRV). Click Next to continue.

    
    Figure B-8: The Select A SQL Server page of the Register SQL Server Wizard.

27. On the Select An Authentication Mode page, choose The Windows Account Information I Use To Log On To My Computer With (Windows Authentication) option and then click Next.

28. On the Select SQL Server Group page, choose the Add The SQL Server(s) To An Existing SQL Group option and then click Next. Click Finish when you’re done.

29. Click Close in the Register SQL Server Messages dialog box. If registration is successful, SHAREPOINT will appear in the SQL Server Group as shown in Figure B-9.

Figure B-9: SHAREPOINT added to the SQL Server Enterprise Manager console.

---