C.2 Configuring the Existing Microsoft SQL Database Server

For information regarding which versions of the Microsoft SQL database Filr supports, see Section 1.2.1, Filr Server Requirements.

To configure an existing Microsoft SQL database to be used with your Filr system:

  1. Enable remote access to the Microsoft SQL database server.

  2. Open port 1433 on the Windows firewall where the database is running.

  3. Ensure that you have access to a user account with sufficient rights to manage the Filr database. This user must have the necessary rights to administer the database. (You might need to create a new user to administer the Filr database.)

  4. Using a tool such as Microsoft SQL Server Management Studio, create a new database to use as the Filr database.

    In Microsoft SQL Server Management Studio:

    1. Select the database where you want to create the new Filr database, then click Databases > New Database.

      The New Database dialog box is displayed.

    2. Select the Master database in the list of databases, then paste the following script into the New Query window:

      USE master;
      GO
      IF DB_ID (N'filr') IS NOT NULL
      DROP DATABASE filr;
      GO
      CREATE DATABASE filr
      COLLATE Latin1_General_CI_AS_KS_WS;
      GO
      --Verify the collation setting.
      SELECT name, collation_name FROM sys.databases WHERE name = N'filr';
      GO
      

      If your database name is something other than filr, replace filr with the name of your database in the script.

    3. Click OK to accept the defaults for the new database.

  5. After you create the database, specify the information for the Microsoft SQL database (host name, user name, and password) in the Filr installation wizard, as described in Section 5.5, Configuring a Large Deployment for the First Time.

    When connecting the Microsoft SQL server, you need to use a local Microsoft SQL account for the user name and password. This user must have all the required rights to administer the database. An Active Directory user is not sufficient when connecting to the database from Filr because Filr does not support Windows account authentication.

    After the wizard completes, there is now a Filr database populated with tables displayed in the Microsoft SQL Server Management Studio.

  6. Continue with Section C.3, Connecting to the MySQL Database Server.