Part I : How to build MOSS BDC Search for your Line Of Business Application [From Start to End]

  I just successfully implemented MOSS  BDC Search for CSTAR application. I will share my learnings about MOSS BDC search here. My design implements centralized MOSS Search for all LOB application in my group. MOSS BDC Search solution in a nut shell...

 

This article walks you through MOSS BDC Search installations steps. At very high level, installation involves four steps

1. Verify prerequisites (software and hardware)

2. Install SharePoint Server 2007

3. Import BDC meta data, Create Managed properties and configure crawl

4. Smoke test installation

 

You will see detailed instructions for each of the steps listed above in following section

Install Microsoft® Office SharePoint® Server 2007

 

Prerequisites

Refer following readme.htm documents for SharePoint Server 2007

.Net Framework 3.0 RTM (Windows Workflow Foundation)

Microsoft Office SharePoint Server 2007 product.

Read my previous post about MOSS Search  

https://blogs.msdn.com/pdesai/archive/2007/06/17/moss-2007-bdc-search-full-text-out-of-the-box-solution-for-your-lob-application.aspx

 

Install location

To install Microsoft Office SharePoint Server (MOSS) 2007, follow instructions listed below.

1.

SharePoint Serer 2007 depends on Windows Work Flow Foundation (WCF) which is part of .NET Framework 3.0.4203.2 (RTM Version). Make sure you have it on server where SharePoint is to be installed.

 

2.

Kick off SharePoint Server 2007 installation using setup exe. This takes few seconds to bring up Moss Setup dialog box

3.

Enter product key when prompted (product web SharePoint installation page  lists product key) and click continue

4.

Read license agreement and Check the box “Accept the terms of this agreement”. Click continue

5.

Choose the installation based on your environment. My recommendations are

· Dev and Test environment click  Basic  (standalone server)

· PPE and Production click Advanced (separate servers for query, index and database). This will perform better.

Selected SharePoint Server 2007 installation begins. This will take a while to finish.

6.

Click close button to complete SharePoint Server installation and continue with  Microsoft Office SharePoint Server 2007 Configuration wizard

7.

 

 

Click Next button, it will immediately popup with following dialog

8.

Click Yes to proceed with MOSS 2007 configuration. This will take couple of minutes to complete.

9.

Click Finish to complete MOSS 2007 installation and configuration.

 

Configure MOSS Search Index and Query Service Account

 

You need to configure Search Inded and Query Service account, once MOSS (Microsoft Office Sharepoint Server) installation is complete. The account you specify here will be used by sharepoint to connect to Line of Business Application Database or web service. Use the account which has access to your database objects (or web service) for which you would like to enable MOSS Search 

1.

Open Central Administration Site and click Application Management

2.

And then click Manage Search Service in search section

3.

Click Office SharePoint Server Search Indexing and Query link in Query and Index Servers section

4.

On “Configure Office SharePoint Server Search Service Settings on server” page, configure E-Mail account (use production support alias responsible for supporting CSTAR MOSS BDC Search)

5.

Configure Farm Search Service Account to use a Service Account (security Account like REDMOND\XYZ. Avoid using personal account). The account you use here should be preconfigured to access underlying application database.

6.

Scroll down and select other options as shown below. Click OK to complete

Congratulations! you just learnt how to install and configure SharePoint Server 2007 Search components. Keep tuned, in my next blog post I will show you how to create MOSS BDC application,  Create managed property, Map Crawled properties, Create content catalog. I will also show how to create content crawl schedule.