Federated Search SQL Server Connector Sample


This topic describes functionality that is part of the Infrastructure Update for Microsoft Office Servers. To download the update, see Description of the SharePoint Server 2007 infrastructure update: July 15, 2008.

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:

  1. Implement a basic federated search connector.

  2. Query an instance of a SQL Server database that is running on the local server and return the results to Search Server 2008 in RSS format.

  3. Provide search results HTML for a More Results link.

  4. Create a location for the federated search connector by using the Search Administration site.

  5. Test the sample by configuring an instance of the Federated Search Results Web Part to use the location for the federated search connector.

You can download the complete code for this sample in the Federated Search SQL Server Connector Sample release. The release is located on the Microsoft Office SharePoint Server 2007 SDK Search Samples resource page of the MSDN Code Gallery.


To use the Federated Search Connector sample, you must have the following installed in your development environment:

  • Microsoft Office SharePoint Server 2007

  • SQL Server 2005 on the same server with Office SharePoint Server 2007

  • Microsoft Visual Studio 2008 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. You can find the AdventureWorksDW database in the following location:

Download the AdventureWorksBI MSI installer.


The SQL Server sample databases are designed to use SQL Server 2008 by default. If you have 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 the Microsoft SQL Server Community & Samples FAQ.

Completing the Walkthrough

The following topics walk you through creating and deploying a federated search SQL Server connector:

See Also


Federated Search Connector Sample Code


Architecture Guidance for Building Federated Search Connectors
Federated Search Overview