19.3 Creating a Microsoft SQL Database

Before you begin, you should be familiar with standard database maintenance procedures.

For more information about Microsoft SQL, see the following Microsoft Web Site.

The following database tool can be helpful:

To create a Microsoft SQL database:

  1. Review the Microsoft SQL requirements listed in Database Server Requirements.

  2. Ensure that the Microsoft SQL Server and Client have been installed and configured properly.

    IMPORTANT:Ensure that TCP/IP is enabled for the Microsoft SQL Server.

    For more information, see Microsoft SQL Server.

  3. Ensure that the Microsoft SQL database client is also installed on the Vibe server.

    The Vibe installation program needs the Microsoft SQL client in order to communicate with the Microsoft SQL database server.

  4. When you install Microsoft SQL Server, select SQL Server and Windows for authentication.

    The default is Windows Only, which is not appropriate for Vibe.

  5. Copy the teaming-4.0.n-db.zip file from the Vibe server where the Vibe installation program is located and copy it to the database server.

    or

    Download and unzip the Vibe software onto the database server.

  6. In the directory where the Vibe Installation program is located on the database server, or in the location where you copied the teaming-4.0.n-db.zip file, unzip the teaming-4.0.n-db.zip file.

  7. Change to the db subdirectory.

  8. Change to the db/scripts/sql subdirectory.

  9. Use Microsoft SQL Server Management Studio to create the empty database:

    1. Copy the sqlserver-create-empty-database.sql file from the db/scripts/sql subdirectory .

    2. Execute the query to create the empty database.

      When the database is created, you should see Command(s) completed successfully in the messages window.

  10. Change to the db directory.

  11. Edit the sqlserver-liquibase.properties file to use your administrator user name and password for the SQL database server.

  12. Populate the database that you just created (requires that Java is installed):

    run manage-database.bat sqlserver updateDatabase

  13. Verify that the database tables were created by using Microsoft SQL Server Management Studio.

  14. If desired, you can now uninstall Java.