Error at object ‘DatabaseSelection’ in markup file I tried to install AdventureWorks OLAP and OLTP Sample by running AdventureWorks2008_SR4.exe on SQL.
-->Applies to: SharePoint Server 2010
In this article
Prerequisites
Setting Up the AdventureWorksDW Database
Completing the Walkthrough
By using the Federated Search SQL Server Connector sample, you can learn how to create a connector that can return federated search results from a Microsoft SQL Server database.
This sample shows how to do the following:
Implement a basic federated search connector.
Query an instance of a database that is running on the local server and return the results to SharePoint Enterprise Search in RSS format.
Provide search results HTML for a More Results link.
Create a location for the federated search connector by using the Search Administration site.
Test the sample by configuring an instance of the Federated Search Results Web Part to use the location for the federated search connector.
The complete code for this sample is available in the Federated Search SQL Server Connector Sample resource page.
Prerequisites
To use the Federated Search Connector sample, you must have the following installed in your development environment:
Microsoft SharePoint Server 2010
Microsoft SQL Server 2008 on the same server with SharePoint Server 2010.
Microsoft Visual Studio 2010 with Microsoft Visual C# or Microsoft Visual Basic enabled
Setting Up the AdventureWorksDW Database
Obtain the AdventureWorksDW database and install it on the server running SQL Server, as follows:
Go to SQL Server 2008 SR4.
Download AdventureWorks2008_SR4.exe.
Note
By default, the SQL Server sample databases are designed to use Microsoft SQL Server 2008. If you have Microsoft SQL Server 2005 installed, you must select SQL Server 2005 SP2a from the Releases list before downloading the sample databases, or the installation will fail. For more information about installing the sample databases, see Microsoft SQL Server Community Projects & Samples Home.
Completing the Walkthrough
The following topics walk you through how to create a federated search SQL Server connector and deploy it:
See Also
Concepts
I'd like to install AdventureWorks2008 (I just install SQL Server 2008 R2 Express).
Each time I download the recommended version from CodePlex, all I get is a AdventureWorks2008.mdf file. Not only I cannot attach the file from SQL Server Management Studio, but I cannot copy/paste the file directly into the the database.
I've read in several places that I need to use AdventureWorks2008.msi, but I cannot find where to download it.
I just cannot figure out how to install AdventureWorks2008
Thanks for helping
Adventureworks2008_sr4.exe Free Download
2 Answers
There isn't an .msi file for adventureworks, even though you'll find it mentioned in outdated documentation and books. You aren't alone in finding this confusing -- it seems the web site, files and steps Microsoft provides for installing these databases changes every time I need to install them.
You need to create the database and attach the .mdf file, which is the 'data file' referred to in the instructions. (.mdf = primary data file, .ldf = log file, .ndf = secondary data file)
In order to attach the file, you need to make sure you carefully follow the steps here: http://social.technet.microsoft.com/wiki/contents/articles/3735.sql-server-samples-readme-en-us.aspx#Readme_for_Adventure_Works_Sample_Databases
Instructions for 2008R2:
To install AdventureWorks2008R2 OLTP database
Download the AdventureWorks2008R2 Data File.
From File Download, click Save and browse to a location on your local server.
From SQL Server Management Studio, execute the following code:
Case-insensitive Database
As an alternative to step 3, you can attach the database using the SQL Server Management Studio user interface. For more detailed information, see Attach a Database (SQL Server Management Studio).
Note: You must remove the log file from the list of files to attach. This will cause the operation to rebuild the log.
Headache saving tip from Aaron Bertrand:
You should place the mdf file in your normal data folder - SQL Server will already have the proper permissions. You can get this path using
SELECT TOP (1) physical_name FROM master.sys.database_files;
You can directly paste that file into your database directory. For more information you can refer http://tryingmicrosoft.com/error-while-attaching-a-database-to-sql-server-2008-r2/.