Updating SQL Server Database Manually

Although it is recommended that the installation process create the Master database for Sql Server, users can create the Sql Server database manually. If you are installing the Unix Master from the command-line, then you must first create the Sql Server database manually. Have your Sql Server DBA perform these procedures.

To update the SQL server Database manually:

  1. Locate the adminit.sql script within the sql directory.

  1. Edit these parameters in this script:

    For debugging purpose, you can run a spool file as you run the installation script.

    • CREATE LOGIN tidal WITH PASSWORD = '<CALL TECH SUPPORT FOR PASSWORD>', CHECK_POLICY = OFF

    • CREATE LOGIN tidalrd WITH PASSWORD = '<CALL TECH SUPPORT FOR PASSWORD>', CHECK_POLICY = OFF, DEFAULT_DATABASE = [Admiral];

      (Contact Tidal Support Center for the password to enter in the brackets < >.)

  1. Save the script.

  1. Login as the SYSTEM user (or equivalent).

  1. Run the adminit.sql script to create tidal user and to create the database.

  1. Locate the createtidalrduser-mssql.sql script within the sql directory.

  1. Find the statement and change DB_READ_ONLY_USERNAME and DB_READ_ONLY_PASSWORD to be the login ID and password.

    IF SUSER_ID('DB_READ_ONLY_USERNAME') IS NULL
    CREATE LOGIN DB_READ_ONLY_USERNAME WITH PASSWORD = 'DB_READ_ONLY_PASSWORD', CHECK_POLICY = OFF, DEFAULT_DATABASE = [Admiral];
    GO
    USE [Admiral] GO
    IF USER_ID('DB_READ_ONLY_USERNAME') IS NULL
    CREATE USER DB_READ_ONLY_USERNAME FOR LOGIN DB_READ_ONLY_USERNAME WITH DEFAULT_SCHEMA =
    [Admiral]; GO
    EXEC sp_addrolemember 'db_datareader', 'DB_READ_ONLY_USERNAME' GO

  1. Save the script.

  1. Run the createtidalrduser-oracle.sql script to create read-only user.

  1. Run these scripts in the SQL Server Master Database created above.

    • Run the admssql.sql script.

    • Run the createviews-mssql.sql script.

    • Run the grant.sql script.

    • Run the mspopulate.sql script.

    • Run the nodmst.sql script.

The Sql Server TA database should now be installed. If any error occurs while running those scripts, DO NOT continue. Collect as much information on the errors as possible and contact either the consultant assisting your installation or the Tidal Support Center.