Alan Lawhon
lawhonac at hiwaay.net
Thu Oct 20 12:36:36 CDT 2011
The book I am using for training and study, (i.e. "Murach's SQL Server 2008
for Developers"), recommended that I download and install the "SQL Server
Express with Tools" edition of SQL Server (which I did) along with a sample
database (downloaded from the Murach web site) which accompanies the
examples in their book. I have been working and training with the Murach
sample database (primarily through the SQL Server Management Studio) with
few (if any) problems. (So far, so good.) The Murach book occasionally
directs me to SQL Server Books Online (BOL) for additional information on
various topics.
In reviewing and accessing Books Online, I notice frequent references (and
code samples) taken from a Microsoft "codeplex" web page that references an
"AdventureWorks2008R2" sample database.
http://msftdbprodsamples.codeplex.com/releases/view/55926
Since BOL tends to go into greater detail on some of the topics I am
studying, I thought it might be a good idea to download this
"AdventureWorks2008R2" sample database on my x86 (Windows XP SP3) box. The
Microsoft codeplex web site indicates that, for users running the SQL Server
Express edition, the AdventureWorks2008R2 sample database needs to run under
the Express (with "Advanced Services") edition of SQL Server.
According to the "Installation Prerequisites for the SQL Server 2008 and
2008R2 Sample Databases" web page:
http://tinyurl.com/452bydb
In order to be able to successfully install the AdventureWorks2008 or
AdventureWorks2008R2 (OLTP) database the following additional requirements
must be met:
* At least SQL Server Express with Advanced Services must be installed.
Ordinary SQL Server Express will not work. You can download SQL Server 2008
Express with Advanced Services from the Microsoft Download Center
<http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b5d
1b8c3-fda5-4508-b0d0-1311d670e336> .
* FILESTREAM must be enabled and the SQL Full-text Filter Daemon Launcher
service must be running. See below for how to configure these features.
* This is the download page for downloading the "Advanced Services" edition
of SQL Server Express.
http://www.microsoft.com/download/en/details.aspx?displaylang=en
<http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=1842>
&id=1842
Can I install (and run) two different versions (instances?) of SQL Server
Express on the same physical machine without causing all kinds of conflicts
and problems between the two different versions? (Will the two different
versions "play good" together?)
TIA.
Alan C. Lawhon