Share via

Step 2: Deploy and Test the Federated Search SQL Server Connector

  • Article

Note

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.

After you have created the ASPX page for the Federated Search SQL Server Connector, you need to do the following:

  1. Deploy the ASPX page.

  2. Create the federated location for the connector.

  3. Configure the Federated Results Web Part.

  4. Test how results from the AdventureWorksDW database appear in a Federated Results Web Part.

To deploy the ASPX page and verify that data connectivity is working

  1. Copy the FederatedConnectorSample folder and contents from the path Local_Drive:\\2008 Search Server Developer Resources\ to the _layouts virtual directory, located in the path Local_Drive:\\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS.

  2. Browse to the path http:// YourServerName/_layouts/FederatedConnectorSample/SearchResellers.aspx.

    You should see a page with an RSS feed that shows several results from the DimResellers table in the AdventureWorksDW database.

    Note

    You need to change the server name that is specified in this URL to match the Web server you are using.

To create the federated location

  1. On the Search Administration page, click Federated Locations, and then click New Location.

  2. In the Location Name and Display Name fields, type AdvWorksResellers.

  3. In the Description field, type text to describe the location, such as Search DimResellers table in the AdventureWorksDW database.

  4. In the Version field, type 1.0.

  5. For the Location type field, click OpenSearch 1.0/1.1.

  6. In the Query Template field, type https://localhost/_layouts/searchresellers.aspx?q={searchTerms}.

  7. In the "More Results" Link Template field, type https://localhost/_layouts/searchresellers.aspx?q={searchTerms}&f=htm.

  8. In Specify Credentials, select the appropriate authentication protocol. For example, you could select Corporate: NTLM - Specify a username and password, and then type the credentials for an account that has access to the AdventureWorksDW database.

  9. Click OK.

To configure the Federated Results Web Part

  1. From the main Search Center site, go to the Search Results page in the path http://YourServerName/results.aspx.

  2. Click Site Actions, and then click Edit Page.

  3. Click Edit for the Federated Results[2] Web Part, and then click Modify Shared Web Part.

  4. In Location Properties, click AdvWorksResellers on the Location list, and then click OK.

  5. Click Site Actions, and then click Exit Edit Mode to close the Edit page.

To test the Federated Search SQL Server connector

  1. Go to the Search Center Home page in the path http://YourServerName/default.aspx.

  2. Type a search term in the search box that will return results from the DimResellers table, for example, type bike.

    If the Federated Search SQL Server Connector is working, you should see search results from the AdventureWorksDW database on the search results page.

See Also

Concepts

Step 1: Create the Project for the Federated Search SQL Server Connector
Federated Search SQL Server Connector Sample
Architecture Guidance for Building Federated Search Connectors