Thursday, September 11, 2008

SQL Server 2008 Overview, data platform, store data | Microsoft

My step-by-step screen shot installation of SQL 2008.  Not a best-practice installation by any means.

Mount the ISO using Microsoft Virtual CDROM.

Run Setup

  • Installs .net 3.5 sp1
  • Installs patch for windows xp
  • Reboots

Run System Checker

Install Upgrade Advisor

Install single instance.


Next screen is product key (not shown here)






Rule Check Result


Rule "Windows Firewall" generated a warning.

The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at for information about ports to open for each feature.











Next screen you select Windows or Mixed mode and add admins to SQL (Removed from here)



Next screen you add admins to Analysis Services (removed from here)





Rule Check Result


Rule "Previous releases of Microsoft Visual Studio 2008" failed.

A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008.






And wait.  And wait.  And wait. And wait.  About 1 hour later.



And wait


The following notes apply to this release of SQL Server only.

Microsoft Update

For information about how to use Microsoft Update to identify updates for SQL Server 2008, see the Microsoft Update Web site <> at

Reporting Services

The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed the program files only, you must run the Reporting Services Configuration tool to deploy the report server.

To install the Reporting Services Add-in for SharePoint Technologies, start the rsSharePoint.msi in the Setup folder on the SQL Server 2008 installation media after SQL Server Setup is complete.

Documentation and Samples

To install the .NET Framework SDK, see “Installing the .NET Framework SDK” in SQL Server 2008 Books Online <> at

By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code for non-Express editions of SQL Server 2008, see the CodePlex Web site <> at To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview <> on the CodePlex Web site at

For more information about late-breaking changes in this release of SQL Server, see the latest readme file <> at

For information about SQL Server 2008 Surface Area Configuration, see the following SQL Server 2008 documentation topics:

In SQL Server 2008 Books Online: “Understanding Surface Area Configuration.”

In SQL Server 2008 Setup Help: “Minimize SQL Server 2008 Surface Area.”

In SQL Server 2008 Books Online on MSDN: Understanding Surface Area Configuration <>         at

SQL Server 2008 Overview, data platform, store data | Microsoft

No comments: