AdventureWorks2008R2 Installation Failure

Question

When I install AdventureWorks2008R2, I have no options displayed on the Install page, and when I review the installed files, they are just *.csv files, no database files.  I have installed a number of times witht he same problem.  I have SQL Server 2008 R installed on my machine, and I can access other SQL Server 3005 databases with SQL Server Management Studio.

Answer 1

There was an issue with the 2008R2 SR1 samples database installer which should be fixed now.  Please download again and let me know if you are still having problems.

---

Bonnie Feinberg [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Hi Bonnie,

Just down loaded the latest 2008 R2 SR1 posted yesterday and installed. 

Wanted to let you know there still seems to be an issue.  It now extracts the files to the users 'temp' directory and does not move them to the C:\Microsoft SQL Server\100\tools\Samples folder.  The work around I used was to go in and manually move the files from the temp directory to the proper folder then everything works great!

 

Answer 3

It only extracts to the temp directory if it cannot find a valid instance to install on.  This can happen if you are not running under a windows identity which has been granted sysadmin on the SQL Server instance.  It can also happen if you are using the wrong installer for the version of SQL Server which is installed.  It can also happen if the installer cannot access the server via SMO.  Which version of SQL Server do you have installed? Are you logged onto an account with sysadmin privileges? Can you use SQL Server Configuration Manager successfully?

 

---

Bonnie Feinberg [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights