Share via


Change the database that FAST Search Server 2010 for SharePoint uses (FAST Search Server 2010 for SharePoint)

This is more about changing the Database of FAST search for SharePoint; this can be done if you want to reinstall FAST admin Server

The post-setup configuration wizard creates a new database when you configure a single server or administration server. However, you can configure FAST Search Server 2010 for SharePoint to use another existing
database after the configuration wizard has finished.

You can find the FAST settings for the database in <FASTSearchFolder>\etc\hostconfiguration.xml, where <FASTSearchFolder> is the path of the folder where you have installed FAST Search Server 2010

Example: <Drive>\FASTSEARCH\

Below are the Steps to Configure or Create New Database

Make Sure you log into the Machine with Admin rights on FAST box as well as SQL server

            EX: Domain Account which can access FAST, SharePoint and SQL database

Create Empty Database on SQL server

  1. Open PowerShell Right click Microsoft FAST Search Server 2010 for SharePoint shell and select Run
    as administrator
  2. At the Windows PowerShell command prompt, type the following command
  1. Install-FASTSearchAdminDatabase -DbName <DatabaseName> -dbserver <ConnectionString>

Here <Database name> and <Database String> are replaced with Appropriate values

Example: Database string is in the format <ServerName>\<DBInstanceName>

                   Database name: Unique Name of the Database

On the FAST Search Server 2010 for SharePoint administration server, do the following

  1. Stop the FAST Search Sever
  2. Update the database server and database name in <FASTSearchFolder>\etc\hostconfiguration.xml
  3. Now open PowerShell, Right click Microsoft FAST Search Server 2010 for SharePoint shell and select Run as administrator.
  4. Run the CMDLET Set-FASTSearchConfiguration
  5. Start the FAST search for SharePoint

Note: If you are using any other connectors like Lotus connector update the Database name and Database server in the <FASTSearchFolder>\etc\dbconfig.xml