11.2 Configuring the Existing Microsoft SQL Database Server

For information regarding which versions of the Microsoft SQL database Filr supports, seeSQL Database Server in the Filr 3.4: Installation, Deployment, and Upgrade Guide.

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. Identify a user account configured with SQL Server Authentication and that this user has sufficient rights to manage the Filr database.

    Filr supports only SQL Server Authentication. Filr does not support Windows Authentication or Windows Domain User Authentication to Microsoft SQL.

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

    Select the Master database in the list of databases, then paste the following script into the New Query window and execute it to create the new Filr database:

    USE master;
    GO
    IF DB_ID (N'filr') IS NOT NULL
    DROP DATABASE filr;
    GO
    CREATE DATABASE filr
    COLLATE Latin1_General_100_BIN;
    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.

  5. Continue with Connecting to the MySQL Database Server.