When installing SharePoint Portal Server 2003 and SQL Server 2000 on the same server, SQL Server 2000 should ideally be installed prior to installing SharePoint Portal Server 2003 so that the database infrastructure is in place when SharePoint is ready to create the databases needed for SharePoint to function.
This configuration is well suited for organizations that have decided to use SharePoint Portal Server 2003 and have database needs that exceed MSDE's 2GB limit.
It is important to note that SP4 or the latest service pack also needs to be installed before SQL Server 2000 can be run on Windows Server 2003, so make sure to have that available as well prior to starting the installation. Or, make sure that this server has Internet connectivity so that it can be downloaded.
Following are the steps to install SQL Server 2000:
1. | Insert the CD with SQL Server 2000 on it, and run Setup.bat. |
2. | When the message “SQL Server SP2 and below is not supported by this version of Windows” appears, click Continue as SP4 (or the latest service pack) will be installed before running the software. |
3. | Click Next at the Welcome to the Microsoft SQL Server Installation Wizard screen. |
4. | In the Computer Name dialog box, choose whether to install SQL Server 2000 on the local computer or on a remote computer. For this configuration, we'll install it to the local computer; then click Next. |
5. | In the Installation Selection window, choose Create a New Instance of SQL Server or Install Client Tools. Then click Next. |
6. | Enter the appropriate Name and Company information in the next screen and click Next. |
7. | Agree to the Software License Agreement by clicking Yes. |
8. | In the Installation Definition window, select Server and Client Tools and click Next. |
9. | |
10. | The Setup Type window offers three choices for type of setup: Typical, Minimum, and Custom. In addition, the program files and data files can be placed on different drives on this server or another server or SAN device on the network. A best practice is to install the data files on a different physical set of drives so that, in the event of corruption of the server OS and/or the SQL Server software, the data is not affected, and the OS and SQL Server software can be reinstalled and reconnected to the database. Determine the proper placement of the program and data files, verify that there is enough space on the drives selected, and click Next. |
11. | In the Services Accounts window, select Use the Same Account for Each Service. Select Use a Domain User Account and enter the appropriate Username, Password, and Domain. Typically, these will all be selected, and only a password needs to be entered. Some organizations create a separate administrative account for SQL management. Click Next. |
12. | In the Authentication Mode window, verify that Windows Authentication Mode is selected and click Next. |
13. | In the Start Copying Files window, click Next. |
14. | In the Choose Licensing Mode window, select either the Per Seat or Processor License mode as appropriate, and enter either the number of devices or processors licensed; then click Continue. |
15. |
Once SQL Server 2000 has been installed, SP4 (or the latest service pack available that is supported by the organization) should be installed. This file can be found on Microsoft's website at the following url: http://www.microsoft.com/sql/downloads/2000/sp4.asp. Select the appropriate language in the Download area on the right-hand side and click Go. Then at the bottom of the page select SQL2000-KB884525-SP4-x86.EXE, and save to the appropriate location on the server.
Once it is downloaded, follow these steps to install SP4:
1. | Double-click the file SQL2000-KB884525-SP4-x86.EXE in the directory on the server, and then indicate where the files should be extracted to. Click Finish when the extraction process completes. |
2. | Navigate to the directory where the files were extracted, and double-click on setup.bat. |
3. | At the Welcome window click on Next. |
4. | At the Software License Agreement window click Yes. |
5. | At the Instance Name window click Next. |
6. | At the Connect to Server window choose either SQL Server authentication or Windows Authentication (depends on the decision made during SQL server installation, usually Windows Authentication is chosen) and click Next. |
7. | The user entered will be validated. If a blank SA password is detected, you are prompted to enter an SA password, even if Windows authentication is being used. It is recommended to enter an SA password and not to select Ignore the Security Threat Warning. Decide which is appropriate then click OK. |
8. | In the next screen, determine whether SQL Server's error-reporting feature should automatically send fatal error reports to Microsoft; then click OK. |
9. | |
10. | After the installation is complete, a message suggests that the databases be backed up because changes have been made. Click OK. |
11. | When the Setup Complete window appears, click Finish. |
12. |
Once the service pack has been installed, SharePoint Portal Server 2003 can be installed by following these steps:
3.128.170.27