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
- Open PowerShell Right click Microsoft FAST Search Server 2010 for SharePoint shell and select Run
as administrator - At the Windows PowerShell command prompt, type the following command
- 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
- Stop the FAST Search Sever
- Update the database server and database name in <FASTSearchFolder>\etc\hostconfiguration.xml
- Now open PowerShell, Right click Microsoft FAST Search Server 2010 for SharePoint shell and select Run as administrator.
- Run the CMDLET Set-FASTSearchConfiguration
- 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