Configure databases (SQL server): what you need to know

Prepare for installation of your databases.

Before You Begin

The supported SQL collation is SQL_Latin1_General_CP1_CI_AS. The Touchstone/Touchstone Re database installation creates two SQL accounts:

  • airadmin (sysadmin privileges)

  • airuser (database owner of Verisk-specific databases)

Procedure

  1. Determine the location where the Touchstone databases, SQL server data, and log files will be installed.
  2. Verify that the SQL Server Analysis Services are also installed along with SQL Server.
  3. Ensure Named Pipes and TCP/IP are enabled.