Add a View Composer Database to SQL Server

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

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

• Verify that a supported version of SQL Server is installed on the computer on which you will install View Composer or in your network environment. For details, see Database Requirements for View Composer and the Events Database.
• Verify that you use SQL Server Management Studio to create and administer the database. Alternatively, you can use SQL Server Management Studio Express, which you can download and install from the following Web site.

  http://www.microsoft.com/en-us/download/details.aspx?id=7593

Procedure

1. On the View Composer computer, select Start > All Programs > Microsoft SQL Server 2014, 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.