Installing SQL Server 2005 Workgroup/Standard Edition

Previous Topic: Workgroup/Standard Edition Overview

To install the Workgroup or Standard version of Microsoft® SQL Server 2005, you will need to purchase it from Microsoft. Once purchased, follow these steps:

  1. Insert the SQL 2005 CD or run the downloaded installer. The splash screen appears:

  1. Click the Install – Server components, tools, Books Online and samples link. The End User License Agreement dialog box appears.

  1. Select the I accept the licensing terms and conditions check box.

  2. Click Next. If any of SQL Server's prerequisites need to be installed, you will be  prompted to install them.

Note!

Note:
Depending on your server's configuration, you may or may not be prompted to install any of SQL Server's prerequisites. If the protocol you are using is already enabled, you do not need to perform any actions in this dialog box.

  1. When the Welcome to the Microsoft SQL Server Installation Wizard screen appears, click Next. The System Configuration Check dialog box appears and will inspect your computer for any issues that may cause problems with the installation.

  1. If any tests fail, you should review the error messages and take the appropriate action. Note that some warnings may be for informational purposes only, and may not cause any problems with the installation of SQL Server. Whether or not a test is informational or not is difficult to tell. With that in mind, we recommend that you contact the appropriate vendor for more information about any warnings that occur before you continue installing SQL Server.  

  2. Optionally, you can save these errors and warnings to a report file by clicking Report and selecting Save Report to File from the pop-up menu.

  3. Click Next. The installation will begin. After a minute, the Registration Information dialog box appears.

  1. Type the name of the SQL Server administrator into the Name field.

  2. Type the name of your company into the Company field.

  3. Type your product key into the registration information fields.

  4. Click Next. The Components to Install dialog box appears:

  1. Select the SQL Server Database Services check box.

  2. Select the Integration Services check box. All other check boxes are optional but not required.

  3. Click Advanced. The Feature Selection dialog box appears.

  1. Expand the tree to see the Client Components/Management Tools section.

  2. Click Management Tools and select Entire Feature will be installed on local Hard Drive from the pop-up menu.

Note!

Note:
If you want to install SQL Server 2005 in a location other than the default path (C:\Program Files\Microsoft SQL Server), in the Feature Selection dialog box:

  • Click Database Services. The Feature Selection dialog box appears.

  • Click Browse.

  • Navigate to and select the folder where you want to install SQL Server

  1. Click Next.

  2. Click Next.

  1. Select the Named instance option button and type "ServiceCEO" into the field. While not required, we highly recommended you perform this step.

  2. Click Next. The Service Account dialog box appears.

  1. Select the Use the built-in System account option button.

  2. Select Local system from the drop-down list.

  3. Select the SQL Server check box in the Start services at the end of setup section.

  4. Click Next. The Authentication Mode dialog box appears.

  1. Select the Mixed Mode option button.

  2. Type your sa logon password into the Enter password and Confirm password fields. Note that a blank password will not work with ServiceCEO.

  3. Click Next. The Collation settings dialog box appears.

  1. Select the SQL Collations option button.

  2. Select Dictionary order, case-insensitive, for use with 1252 Character set from the list box. Note that this setting is very important for international users running ServiceCEO outside of the U.S.

  3. Click Next. The Ready to Install page appears.

  4. Click Install. SQL Server will start to install. The installation status will be displayed in the Setup Progress dialog box.

  5. When the installation has finished, click Next. The Completing Microsoft SQL Server 2005 Setup dialog box appears.

  6. Click Finish. SQL Server has been installed!

The next step is to install the Database Management Tools on the Server so that you can run the Database Setup Wizard. When prompted to select the SQL Server instance you want to use, select the instance you created in step 20.

Next Topic: Configuring Workgroup/Standard for 20+ Users

Did you find this topic useful? Yes
No
I don't know		 Why?