|Date Added:||19 November 2007|
|File Size:||23.10 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Now the AdventureWorksDW database is attached. Hunter and is protected under copyright laws of the United States.
Edited by Kushira Friday, November 11, 7: I also tried it, and the first time it didn't run. Edited by Kushira Friday, December 2, 6: I downloaded Adventure Works sample databases installation package for sql server r2 and installed it.
Post as a guest Name. Supply your SQL Server name and instance name if its a named instance.
DBA Tips Archive for SQL Server
Ensure all prerequisites are met. Supply log on credentials for the instance and then verify the correct AdventureWorks Data Warehouse sample database is selected.
A walkthrough that shows how to install the AdventureWorks database can be seen at the following Microsoft site:. Last modified on Friday, May Users are now required to download and manually install the sample databases after successfully setting up SQL Server. As mentioned at the beginning of this article, the sample databases for SQL Server and higher must be adventkreworks downloaded and installed. Where did adventurewworks download the package from?
The result is that the "Restore Database" screen is shown. Where to get AdventureWorksR2 database?
Note that this deployment must be done manually using Business Intelligence Development Studio after installation is complete. Sign up using Email and Password. I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it.
If the test succeeds, click OK and OK to save the changes. If necessary, change the: All articles, scripts and material located at the Internet address of http: The default path is C: Hopefully, this version is easier to attach and use.
The file may seem to be complete but it is not. See Database Prerequisites for detailed prerequisite instructions. Sign in to vote.
AdventureWorks Database - Download Microsoft SQL Server R2 Sample Databases
Did the download complete successfully? I am using Windows XP.
After clicking the Install button, all scripts and data files are copied to the directory specified in the previous dialog. As long as you copy the database to C: Next to Start Modeclick Disabledand then click Automatic in the list that appears. If you want to install the prerequisites at the same time that you install a new instance of SQL Server, note the following information:.
CodePlex is hosted by Microsoft.