Share Intelligence

Where SharePoint meets Business Intelligence

SQL Server 2008 Feb CTP - DVD ISO Details

With the release of the full feature SQL Server 2008 CTP recently, I've decided to install the CTP to become familiar with the new Business Intelligence features.  Since I'm going to go install it for the first time, I am going to post a series of entries about my installation.

This post will focus on the folders and files contained on the 32-bit Developer Edition DVD of the SQL Server 2008 Feb CTP.   The first thing I did was download the ISO and burn it to DVD.  The DVD size is around 1.25 GB.

Root Folder

CD_ROM

The root folder of the DVD is pretty simple.  There are only 2 folders and the autorun file.

Servers folder containing the setup files for installing the server
Tools folder containing the setup files for just the tools installation for clients.
Autorun.inf the file which launches the CTP setup when the DVD is inserted

 Server Folder

Servers

The Server folder contains the bits for the server install along with any of the prerequisites that need to be installed. The folder main components are the setup executable and the SQL chainer / configuration files.

1033 folder folder containing one small rtf file describing the features of this CTP and the setup of Reporting Services
help folder folder containing a compiled help file detailing the installation of the CTP from hardware / software requirements to known issues with the installation
redist folder folder containing installs for any prerequisites
Setup folder containing installs for the SQL components
autorun.* files files to make the make the CD autoplay;  these files launch the splash.hta file.
ComponentUpdate.xml XML file
configuration.uicfg XML file used for the SQL Server Installation Center;  it contains the actions for the links on the center along with the wizards to launch
DbgHelp.dll Library file that contains debugging functions used by the symbols engine and for symbol and module enumeration
default.* files html splash screen file for launching the readme file, requirements, and the setup itself
license.txt Text file containing the SQL licensing terms
MediaInfo.xml XML file describing the language type of the media
Microsoft.* files These libraries are used by the setup program perform the installation from chaining together the install packages, configuration, and the install wizard itself.
MSClusterLib.dll Microsoft Failover Windows Clustering Automation classes
msvcp80.dll / msvcr80.dll / Microsoft.VC80.CRT.manifest Microsoft C / C++ runtime libraries
Package.xsd

XML schema for the chainer package XML.  This XML is generated  at build time and added to a package containing an installer.  There are several types of installers (RTM, Service Pack, QFE) that all use this XML.

ReadmeSQL2008.htm html file containing the release notes for SQL Server 2008
RequirementsSQLKatmai.htm html file containing the hardware and software requirements for SQL Server 2008
setup* files Main executable files;  This is the core of the setup which installs the setup files, installs the prerequisites, and then launches the SQL Server Installation Center.
splash.hta html splash screen file displaying that this is the Feb CTP which in turn launches the default.hta file
sqlsccn.dll SQL Server System Configuration Checks Native library
sqlspkglist.dll CD Install package list helper library

 Servers\redist Folder

Servers-Redist

This folder contains the redistributable software packages that are prerequisites for SQL Server to be installed.  The folder contains no files just folders of each package.

DotNetFrameworks folder folder containing the install packages for the .net frameworks required
Powershell folder folder containing the install package for Powershell; Powershell is required for SQL Server 2008
Upgrade Advisor folder Folder containing the the Upgrade Advisor; this is not required; it can be installed from the default.hta screen
Windows Installers folder Folder containing updates and newer versions of the Windows Installer

 Servers\redist\DotNetFrameworks Folder

serversredist.dotnetframeworks

This folder contains the install packages for the .Net frameworks required. Note, that SQL Server needs the new 3.5 framework to run.

dotNetFX20 folder folder containing the .net 2.0 framework redistributable install
dotNetFX30 folder folder containing the .net 3.0 framework redistributable install
dotNetFX35 folder folder containing the .net 3.5 framework redistributable install
dotNetMSP folder folder containing .net 2.0 SP1 and .net 3.0 SP1
dotNetFX35setup.exe Executable used to launch the setup of the .net 3.5 framework

 Servers\redist\Powershell\x86 Folder

serres.redist.Powershell.x86

The powershell folder contains folders for each of the chip architectures.  We will focus on the x86 folder.

Windows6.0-KB928439-x86.msu Microsoft update for KB928439 - Windows Powershell for Vista
WindowsServer2003-KB926139* files Language specific executables to install KB926139 - Windows Powershell for Windows Server 2003
WindowsServer2003-KB926140* files Language specific executables to install KB926140 - Localized Windows Powershell for Windows Server 2003
WindowsXP-KB26139* files Language specific executables to install KB926139 - Windows Powershell for Windows XP
WindowsXP-KB26140* files Language specific executables to install KB926140 - Localized Windows Powershell for Windows XP

Servers\redist\Windows Installer Folder

servers.redist.Windows lnstaller

This folder contains the folders for each of the chip architecture updates. It also has one update file.

ia64 folder folder containing the IA64 chipset windows installer updates
x64 folder folder containing the x64 chipset windows installer updates
x86 folder folder containing the x86 chipset windows installer updates
WindowsInstaller-KB893803-v2-x86.exe Executable to install KB893803 - Windows Installer 3.1 v2

 Servers\redist\Windows\x86 Installer Folder

servers.redint.windows lnstaller.X86

This folder contains the x86 version of the Windows Installer updates.

KB935695.MSU Microsoft Update for KB935695 - Installing Windows Installer 4.5 beta
WindowsInstaller-KB935695-x86.exe Executable to install KB935695 - Windows Installer 4.5 beta

Servers\Setup Folder

Servers.Setup

Where the Servers root folder holds the overall chainer and setup program, this folder holds the installs for each of the SQL server components.

Catalog folder folder containing a security catalog file that groups files into a logical group to avoid multiple trust dialog boxes.
Images folder folder containing images used for the splash screens.
config.xml XML configuration file used by the OWC11.msi
libertysql.msp Microsoft Patch for Microsoft SQL 2000 (old codename was Liberty)
MSDE2000.msp Microsoft Patch for Microsoft SQL Desktop Edition 2000
msxml6*.msi files 32-bit / 64-bit Microsoft Installers for the Microsoft Core XML Services 6.0
OWC11.MSI Microsoft Installer for Office 2003 Web Components
rs2000.msp Microsoft Patch for Reporting Services 2000
rsfx.msi Microsoft Installer for the SQL Server 2008 RsFx driver, a file-system filter driver to aid access to the data through the NTFS Streaming APIs for the Filestream data type
setupex.dll Library file for SQL Server edition settings data
sqlbrowser.msi Microsoft Install for the SQL Browser, a service that listens for incoming requests for SQL Server resources and provides information about SQL Server instances that are installed on the computer.
sqlncli*.msi files 32-bit / 64-bit Microsoft Installers for the Microsoft SQL Server Native Client and SDK, the client contains the SQL OLE DB provider and SQL ODBC driver in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server
SqlRun_AS.* files Microsoft Installer for Analysis Services and tools used to support online analytical processing (OLAP) and data mining; it also installs Integration Services
SqlRun_DTS.* files Microsoft Installer for Integration Services, a set of tools and programmable objects for creating and managing packages that extract, transform, and load data, as well as perform tasks.
SqlRun_RS.*files Microsoft Installer for the Report Server, which manages, executes, renders, and distributes reports. Also installs Report Builder, for ad hoc reporting. Also installs a Web-based tool for managing a report server.
SqlRun_SQL.* files Microsoft Installer for SQL Server database engine and tools for managing relational and XML data, Replication, and Full-Text Search. Also tools for PowerShell
SQLServer2005_BC*.msi files 32-bit / 64-bit Microsoft Installers for the Data Transformation Services 2000 runtime, SQL Distributed Management Objects (SQL-DMO), Replication component (Repldts), SQL Virtual Device Interface (SQLVDI), and Decision Support Objects (DSO)
SqlSupport.msi Microsoft Installer for the Microsoft SQL Server Setup Support Files component
SqlWriter*.msi 32-bit / 64-bit Microsoft Installers for the Microsoft SQL Server VSS Writer, a Volume Shadow Copy Service (VSS) so that a third-party backup application can use the VSS framework to back up database files.
sqlxml4*.msi 32-bit / 64-bit Microsoft Installers for Microsoft SQLXML 4.0 and its SDK
SSCERuntime.msi Microsoft Installer for SQL Server Compact Core WIN32 Binaries, the mobile edition of SQL Server
SSCESqlWbTools.msi Microsoft Installer for SQL CE Binaries for SQL Management Studio
Synchronization.msi Microsoft Installer for the Microsoft Sync Framework Runtime v1.0 CTP Refresh
SyncServicesADO.msi Microsoft Installer for Sync Services for ADO.NET enables synchronization between ADO.NET enabled databases. Since Sync Services for ADO.NET is part of the MSF, any database that uses Sync Services for ADO.NET can then also exchange information with other data sources that are supported by MSF, such as web services, file systems or custom data stores.
trin_aide.* files Microsoft Installer for Microsoft Visual Studio Tools for Applications 2.0

That wraps it up from the Servers folder.  This constitutes the first CD or the server install.  My next post a will go into the Tools folder.  The Tools folder has similar items, so I will bring to attention the differences.

Comments

Mansi said:

Good morning. Your world is made of your memories, and your memories are given to you by your world. The whispering voice of happenstance is always in our ears. 'This is the world. This is the way things are. Look. Pay attention. Remember.' Help me! It has to find sites on the: Learn stock trade. I found only this - <a href="www.justiceplanbook.com/.../mm-and-stock-market-trading">mm and stock market trading</a>. A last trading is a strategy set by a liquidity to its markets that is easy from the good according stock transmission, if any, for the brawl, stock trading. Stock trading, in night to get itself against stock, the stock falls for various web. Best regards :eek:, Mansi from Maldives.

# March 25, 2010 2:20 AM

BETTY BOYCE said:

to whom it well concern, an all way   except, the full an close enough for you to use an by the way if your the one that has trading these things an hurt are solar armosphere you well be hunted down an death well come an as far as i an you an any other women concerns you have to put climate change in check i gave it to jeff bush then al gore came out with you know what an solar seeing in energy an cameras an water to lands an space ligh an all other astronuts are an have lied for money an now are systems an resource an n temps an arctic north pole an airs an waters has enought an all the blasting an robatic an all through every secters are making people sick an doctors an virus from riches an communist an all asia making there people sick an put metric with no time an no number an 2464xxs 50 an europe an flashback in are colors less white an lets put these mits to rest an resolve this while we have the chance an all pearl harber an roach of russia an all others traders an american an the enerhy to do silently change an on base let down tracking an no rainbows of beauty an all  flash back sattle lights over each an every state at a distance withtony blair ready get set go 1-2203948576 no picture of all areas are righy they have had this plain an still now have cause a total failure an with the gas an oil reserves none in oceans an all traffic of want to bes failures an no russia oil nor gas in russia none in asia no riches so the total takes is saudi oilan gas an trys to anin with the french an all take bys the final with africas an blacks panters an the rest an the last of all riches an all moons image an sun spots are the energy an robatic control an russia an asia an all movements an all evils to make an sistorys are lande anhealths an to take over all jobs an lands the total end to inslaving an start an the end of the start an the killings of are troops an to over come this to stop thre ends of are chemicals airs we have to move fast an al tv an radios an hollywoods an by the way that dame thing has been following me sence 2004an 5 an moves around because i started picking up that it was stupid an retarted an its scared me to no ends an it abnormal but it was doig that to mr bush they have taken comntrol over whole systems an i started useing all my iqan whole brains waves an picking  up tracking an jaming raders an nasa an all computers now you see it now you dont an message of bad langage on cartoons in 2003 with writting saying bad thing then it disapper, inot joking now ther alot that meets the eye an i am the watcher of the solar systems do you want to see what i see in my brain its called the ending bomb its a netron light an it inlodge sence birtha nit  connects me to the start of the world it dont hurt so bad now because i am dieing wel;come bavk to the start an i want give anymore time to teach  you all an my iq has gotten to38 trillen millen percent its for the kids an troops an the sladder of the wosr war in world history by the worst repress race ever he made me start using my whole brain go figure an thats taht now how you like me now an even if you dont i dont care an i can see every thing thats evil incoming an out comings an solar space an whats in it how cool betty boyce.

# July 17, 2010 4:46 PM

Sattle lights | Yourkenoinfo said:

Pingback from  Sattle lights | Yourkenoinfo

# June 27, 2011 1:36 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)