Search results matching tags 'SQL Server 2008 R2' and 'sample databases'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQL+Server+2008+R2,sample+databases&orTags=0Search results matching tags 'SQL Server 2008 R2' and 'sample databases'en-USCommunityServer 2.1 SP2 (Build: 61129.1)SQL Server v.Next (Denali) : Installing AdventureWorks2008R2http://sqlblog.com/blogs/aaron_bertrand/archive/2010/11/09/sql-server-11-denali-installing-adventureworks.aspxTue, 09 Nov 2010 23:45:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:30127AaronBertrand<p>After five tries, I've given up trying to install AdventureWorks on machines where Denali exists - even in cases where 2008 or 2008 R2 instances also exist, and when my goal is to install AdventureWorks on earlier releases.&nbsp; The installer crashes before I can even select which instance to use.<br></p>
<p>First, I downloaded AdventureWorks2008R2_RTM.exe from CodePlex (which is where <a href="http://msdn.microsoft.com/en-us/library/ms130214%28v=SQL.110%29.aspx" title="http://msdn.microsoft.com/en-us/library/ms130214(v=SQL.110).aspx" target="_blank">Denali's Books Online</a> <a href="http://msdn.microsoft.com/en-us/library/bb510407%28v=SQL.110%29.aspx" title="http://msdn.microsoft.com/en-us/library/bb510407(v=SQL.110).aspx" target="_blank">currently points you</a>):</p>
<p style="margin-left:40px;"><a href="http://msftdbprodsamples.codeplex.com/releases/view/45907" title="http://msftdbprodsamples.codeplex.com/releases/view/45907" target="_blank">http://msftdbprodsamples.codeplex.com/releases/view/45907</a></p>
<p>Ran the EXE, agreed to the license terms, and the next screen was:</p>
<p style="margin-left:40px;"><img src="http://sqlblog.com/files/folders/30126/download.aspx" height="391" width="622">&nbsp;</p>
<blockquote>
<p>(For searchability, here is the error message in plain text):</p>
<table bgcolor="#eeeeee" cellpadding="0" cellspacing="0">
<tr>
<td>
<div style="padding:10px 20px;font-size:12px;font-family:consolas,lucida console,courier new,courier;-moz-background-inline-policy:continuous;">---------------------<br>Fatal Error<br>---------------------<br>A fatal error occurred during installation. Details:<br><br>Failed object initialization (ISupportInitialize.EndInit). An exception occurred in SMO while trying to manage a service. Error at object 'DatabaseSelection' in markup file 'DatabaseInstaller;component/databaseselection.xaml' <br>Line 78 Position 3.</div>
</td></tr></table>
</blockquote>
<p>On five different VMs.&nbsp; My only success with this installer thus far has been on a machine where Denali was not already present.&nbsp; So in my limited sample size, it would seem that something installed with Denali is blocking the sample database installer from succeeding.</p>
<p>Initially I thought that there would be an easy fix to this scenario: install 2008 R2, then AdventureWorks2008R2, then perform an in-place upgrade to Denali.&nbsp; Unfortunately this won't be possible until much later in the public beta cycle (and maybe not even until the final release), since you can't use the upgrade path in setup when installing Enterprise Evaluation edition (which is the only edition available at this time that is capable of running AdventureWorks functionality - Express won't cut it, though it might be okay for AdventureWorks LT ("Light")). <br></p>
<p>So the solution seems pretty straightforward, for now: if you want to play with AdventureWorks, don't install Denali.&nbsp; But what if you want to play with AdventureWorks in Denali?&nbsp; You may be tempted to find and download the script-only install from CodePlex, and it may work, but I am guessing you will have issues when it tries to set up FileStream.&nbsp; So, if you want to install the 2008 R2 version of AdventureWorks (so far I've only tried this for the OLTP database, not other versions such as DW or Lite), you can try the following procedure, which worked for me:</p>
<ol>
<li>either install AdventureWorks2008R2 on another server, or wait to install Denali until after you've installed a 2008 R2 instance and installed AdventureWorks2008R2 there;<br><br></li>
<li>take a backup of the AdventureWorks2008R2 database, as follows, replacing &lt;path&gt; with your favorite backup location:
<blockquote>
<table bgcolor="#eeeeee" cellpadding="0" cellspacing="0">
<tr>
<td>
<pre style="padding:10px 20px;font-size:12px;font-family:consolas,lucida console,courier new,courier;-moz-background-inline-policy:continuous;"><font color="#3300cc">BACKUP DATABASE</font> AdventureWorks2008R2 <br>&nbsp;&nbsp;&nbsp; <font color="#3300cc">TO DISK</font> = <font color="#ff0000">'&lt;path&gt;\AW2008R2.BAK'</font><br>&nbsp;&nbsp;&nbsp; <font color="#3300cc">WITH INIT</font>, <font color="#3300cc">COMPRESSION</font>;<br></pre></td>
</tr>
</table>
</blockquote>
(If you need a copy of this backup file, for example if you don't have another server where you can install 2008 R2 without Denali already present, let me know, and I will try to find out the legality of providing it for you.)<br><br></li>
<li>install Denali, if you haven't already, and make sure your Denali instance <a href="http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2" title="http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2" target="_blank">meets all of the AdventureWorks prerequisites</a>; and,<br><br></li>
<li>on the Denali instance, restore the backup with the following command, replacing &lt;path&gt; with your favorite backup location and &lt;DenaliDataFolder&gt; with Denali's data folder:
<blockquote>
<table bgcolor="#eeeeee" cellpadding="0" cellspacing="0">
<tr>
<td>
<pre style="padding:10px 20px;font-size:12px;font-family:consolas,lucida console,courier new,courier;-moz-background-inline-policy:continuous;"><font color="#3300cc">RESTORE DATABASE</font> AdventureWorks2008R2<br>&nbsp;&nbsp;&nbsp; <font color="#3300cc">FROM DISK</font> = <font color="#ff0000">'&lt;path&gt;\AW2008R2.BAK'</font> <br>&nbsp;&nbsp;&nbsp; <font color="#3300cc">WITH<br> MOVE</font> <font color="#ff0000">'AdventureWorks2008R2_Data'</font> <font color="#3300cc">TO</font> <font color="#ff0000">'&lt;DenaliDataFolder&gt;\AW2008R2.mdf'</font>,<br> <font color="#3300cc">MOVE</font> <font color="#ff0000">'AdventureWorks2008R2_Log'</font> <font color="#3300cc">TO</font> <font color="#ff0000">'&lt;DenaliDataFolder&gt;\AW2008R2.ldf'</font>,<br> <font color="#3300cc">MOVE <font color="#ff0000">'FileStreamDocuments2008R2'</font> TO</font> <font color="#ff0000">'&lt;DenaliDataFolder&gt;\FStreamData\'</font>;</pre>
</td>
</tr>
</table>
</blockquote>
(Note that the FileStreamDocuments2008R2 "file" is actually a non-empty folder, and does not show up in either sp_helpfile or sys.files.)</li>
</ol>
<p>
Now, whether or not this leaves you in a supported state, I'm not sure, and I don't want to be held accountable for the state of your system at this point (or your ability to use every single piece of functionality in AdventureWorks).&nbsp; Not that you should have Denali installed anywhere other than a throwaway VM anyway. <br></p>
<p>&nbsp; <br></p>