You can add a new View Composer database to an existing Microsoft SQL Server instance to store linked-clone data for View Composer.

About this task

If the database resides locally, on the system on which View Composer will be installed, you can use the Integrated Windows Authentication security model. If the database resides on a remote system, you cannot use this method of authentication.

Prerequisites

Procedure

  1. On the View Composer computer, select Start > All Programs > Microsoft SQL Server 2012 or Microsoft SQL Server 2008.
  2. Select SQL Server Management Studio and connect to the SQL Server instance.
  3. In the Object Explorer panel, right-click the Databases entry and select New Database.

    You can use the default values for the Initial size and Autogrowth parameters for the database and log files.

  4. In the New Database dialog box, type a name in the Database name text box.

    For example: ViewComposer

  5. Click OK.

    SQL Server Management Studio adds your database to the Databases entry in the Object Explorer panel.

  6. Exit Microsoft SQL Server Management Studio.

What to do next

Optionally, follow the instructions in Set SQL Server Database Permissions By Manually Creating Database Roles

Follow the instructions in Add an ODBC Data Source to SQL Server.