One moment please...
 
Exact Globe+   
 

Microsoft SQL Server 2005 Installation using SQL Server 2005 Installation Wizard

Introduction

Introduction

The step by step installation of Microsoft SQL Server 2005 is being describe in this document.

Description

Prerequisite

 

Before beginning the installation process, check the following prerequisites:

  • Ensure the computer meets the system requirements outlined in this document.

  • Make sure you have administrator permissions on the computer where Microsoft SQL Server 2005 (SQL Server 2005) will be installed.

  • Back up the Exact Globe database on the SQL Server.

  • Verify that the disk where SQL Server 2005 to be installed is uncompressed. If you attempt to install SQL Server 2005 to a compressed drive, Setup will fail.

  • Exit antivirus software while installing SQL Server 2005.

  • Stop all services that depend on SQL Server, including any service using Open Database Connectivity (ODBC), such as Internet Information Services (IIS). Exit Event Viewer and registry editors (Regedit.exe or Regedt32.exe).

 

Once these prerequisites are met, proceed to install the SQL Server 2005.

Installation

To begin the installation process, insert the SQL Server 2005 DVD into your DVD drive. If the autorun feature on your DVD drive does not launch the installation program, navigate to the root of the DVD and launch splash.hta. If installing from a network share, navigate to the network folder and launch splash.hta.

From the autorun dialog, click Server components, tools, Books Online, and samples.

On the End User License Agreement page, read the license agreement, and then select the check box to accept the licensing terms and conditions. Accepting the license agreement will activates the Next button. To continue, click Next. To end Setup, click Cancel.

On the Installation Prerequisite page, Setup installs software required for SQL Server 2005. For more information about component requirements, click the Help button at the bottom of the page. To begin the component update process, click Install. To continue after the update completes, click Finish.

On the Welcome page of the SQL Server Installation Wizard, click Next to continue.

On the System Configuration Check (SCC) page, the installation computer is scanned for conditions that may block Setup.

  • For information about configuration check items, click Help at the bottom of the page.
  • To interrupt the scan, click Stop.
  • To display a list of check items grouped by result, click the Filter button and then select a category from the drop-down list.
  • To view a report of SCC results, click the Report button and then select an option from the drop-down list. Options include viewing the report, saving the report to a file, copying the report to the Clipboard, and sending the report as e-mail.
  • To proceed with Setup after the SCC scan completes, click Continue.

Note: A warning message will be shown if the SCC detect incompatibility on the installation.


On the Registration Information page, enter information in the Name and Company text boxes. To continue, click Next.


On the Components to Install page, select the components for your installation. A description for each component group appears in the Components to be Installed pane when you select it. You can select any combination of check boxes. To install individual components, click Advanced. Otherwise, click Next to continue.

For Exact Globe and Exact Synergy, check the following two components:

  • SQL Server Database Services
  • Workstation components, Books Online and development tools checkbox only.

If you clicked Advanced on the previous page, the Feature Selection page is displayed. On the Feature Selection page, select the program features to install using the drop-down boxes. To install components to a custom directory, select the feature and then click Browse. For more information about the functionality of this page, click Help. To continue when your feature selections are complete, click Next.

On the Instance Name page, select a default or named instance for your installation. If a default or named instance is already installed, and you select the existing instance for your installation, Setup upgrades it and provides you the option to install additional components.

  • To install a new default instance, there must not be a default instance on the computer.
  • To install a new named instance, click Named Instance and then type a unique instance name in the space provided.
  • For more information about instance naming rules, click Help at the bottom of the page, or see the Instance Name topic in SQL Server 2005 Books Online.

Caution 1: When you upgrade to SQL Server 2005, the previous SQL Server instance will be overwritten and will no longer exist on your computer. Before upgrading, back up SQL Server databases and other objects associated with the previous SQL Server instance.

Caution 2: If your computer has SQL Server 2000 Management Tools and a default instance of SQL Server 2005 installed, SQL Server Setup will permit you to install a SQL Server 2000 default instance. However, doing so will disable the installed instance of SQL Server 2005. Therefore, do not install a default instance of SQL Server 2000 when SQL Server 2000 Management Tools and a default instance of SQL Server 2005 already exist on the computer.



OR (to install a new instances)

On the Service Account page, specify the user name, password, and domain name for SQL Server service accounts. You can use one account for all of the services. Optionally, you can specify an individual account for each service. To specify an individual account for each service, select Customize for each service account, select a service name from the drop-down box, and then provide login credentials for the service. To proceed, click Next.

Note: The domain name cannot be a full Domain Name System (DNS) name. For example, if your DNS name is my-domain-name.com, use my-domain-name in the Domain field. SQL Server does not accept my-domain-name.com in the Domain field.


On the Authentication Mode page, choose the authentication mode to use for your SQL Server installation. You must also enter and confirm a strong password for the sa login. Choose Mixed Mode (Windows Authentication and SQL Server Authentication) for Exact Globe and Exact e-Synergy. To proceed, click Next.

On the Collation Settings page, specify the collation for your SQL Server instance. You can use one account for SQL Server and Analysis Services, or you can specify collations for individual components. To set separate collation settings for SQL Server and Analysis Services, select the Customize for each service account check box. After you select the check box, a drop-down selection box appears. Select a service from the drop-down selection box and then assign its collation. Repeat for each service. To proceed, click Next. In this example,the default Collation which follows the regional setting is chosen.

If you selected Reporting Services as a feature to install, the Report Server Virtual Directories page is displayed. Accept the default directory names, or specify a location for the directories. For more information about this page, click Help at the bottom of the page. To proceed, click Next.

On the Error Reporting page, optionally clear the check box to disable error reporting. For more information about error reporting functionality, click Help at the bottom of the page. To proceed, click Next.

On the Ready to Install page, review the summary of features and components for your SQL Server installation. To proceed, click Install.

On the Setup Progress page, you can monitor installation progress as Setup proceeds. To view the log file for a component during installation, click the product or status name on the Setup Progress page.

On the Completing the Microsoft SQL Server Installation Wizard page, you can view the Setup summary log by clicking the link provided on this page. To exit the SQL Server Installation Wizard, click Finish.

If you are instructed to restart the computer, do so now. It is important to read the message from the Setup program when you are done with installation. Failure to restart the computer may cause failures when you run the Setup program in the future.

Note: After completion of the installation, proceed to perform post upgrade checking as per Post Upgrade of Microsoft SQL Server 2005

Related documents

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 15.388.958
 Assortment:  Date: 26-09-2022
 Release:  Attachment:
 Disclaimer