How to install SQL Server 2008 (Katmai - CTP November 2007)

SQL Server 2008 Community Technology Preview, November 2007, cannot be downloaded from Microsoft Downloads anymore, but you can download the latest CTP from here.

The system requirements are as follow:

The following images show how to install SQL Server 2008 CTP from a self-extracting executable file downloaded for a 32-bit system. Once you download the file, execute it and you will be prompted to choose a location to extract the files to, which you can change as we did.

After the extraction finishes, go to the directory that you extracted the files to. Locate and double-click Setup.exe to begin the installation

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 activates the Next button. To continue, click Next. To end Setup, click Cancel.

On the Installation Prerequisites page, Setup installs software required for SQL Server 2008.

On the SQL Server Installation page, click on New Installation.

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

The following warning shows because we had another instance installed on the machine with SQL Server 2005 Developer Edition and the Business Intelligence feature.

On the Feature Selection page, select the features for your installation.

On the Instance Configuration page, select a default or named instance for your installation, and select de directory where you want to install de features you have chosen

On the Server Configuration page, specify the user name and password 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. The service accounts used for this configuration must have a strong password, otherwise you will get the error "Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service".  A strong password  is one that has a combination of letters in uppercase, lowercase, numbers and special characters.

On the Collation tab, specify the collation for your SQL Server instance

On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation.  If you select Windows Authentication, Setup creates an sa account. Enter and confirm the password for the (sa) login when you choose Mixed Mode Authentication
 

As you can see below, you need to specify at least one Windows Account as sysadmin.

On the Data Directories tab, specify the location for the data folders.

If you selected Reporting Services as a feature to install, the Report Services Configuration page is displayed.   Here we chose to install Reporting Services on Native mode.

On the Error and Usage Reporting page, optionally clear each check box to disable error reporting

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

On the Installation Progress page, you can monitor installation progress as Setup proceeds.

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 Close.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.