Implementing the content search in MOSS 2007

Do a full crawl to get the search working after you have added your custom columns to a list or document library.
Also you can customize the advanced search so that it can even search custom site column .Download the word document which contains the instructions to customize the search in MOSS 2007 Customizing Advanced Search

MOSS 2007 Excel web access web parts giving error “Not Accessible

One of my team member has faced the problem while he is trying to access the files which are uploaded to a document library  using Excel web access web part and it is giving the error “Not Accessible”.

Below is the solution I have provided, add the file to a trusted location

To add a file to a trusted location,below is the procedures you need follow.

From Administrative Tools, open the SharePoint Central Administration Web application.

 On the Central Administration home page, click Application Management.
On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm’s Shared Services.
On the Manage this Farm’s Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.
On the Shared Services home page, in the Excel Services Settings section, click Trusted file locations.
On the Excel Services Trusted File Locations page, click Add Trusted File Location.

In the Address section, type the location and name of the SharePoint Office SharePoint Server 2007 document library that you want to add as a trusted file location in Excel Services. If the document library is stored in the Windows SharePoint Services 3.0 content database, ensure that Windows SharePoint Services 3.0 is selected as the Location Type.

In the External Data section, select the type of data connections that you will allow workbooks in this trusted file location to contain and click OK.

In the External Data section, you can determine whether workbooks stored in trusted file locations and opened in Excel Calculation Services sessions can access an external data source. You can designate whether Allow External Data is set to None, Trusted data connection libraries only, or Trusted data connection libraries and embedded.

If you select either Trusted data connection libraries only or Trusted data connection libraries and embedded, the workbooks stored in the trusted file locations are allowed to access external data sources. External data connections can be accessed only when they are embedded in or linked from a workbook. Excel Calculation Services checks the list of trusted file locations before opening a workbook. If you select None, Excel Calculation Services will block any attempt to access an external data source. If you manage data connections for a large number of workbook authors, you might want to select Trusted data connection libraries only.

SharePoint 2007 Backup and Restore Problems due to version conflict

Last week when one of my another project team decide to make one of our development server as production server and it gave error during the restore process. Actually they were trying to restore the site using command “stsadm –o restore –url http://testserver:2000 –filename testserver1.bak –overwrite” and it has thrown this following error – “Your backup is from a different version of Windows SharePoint Services and cannot be restored to a server running the current version. The backup file should be restored to a server with version ‘’ or later.”

The MOSS version on the test server is 12.0.4518.1016.

Below is the solution I have provided and it worked on very first time.

The quick solution for this problem is to upgrade the retailpower server Install the SP1 for the WSS 3.0
download location:
This will upgrade the WSS version to