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.

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.

Verify that you use SQL Server Management Studio or SQL Server Management Studio Express to create and administer the data source. You can download and install SQL Server Management Studio Express from the following Web site.


On the View Composer computer, select Start > All Programs > Microsoft SQL Server 2008 or Microsoft SQL Server 2005.


Select SQL Server Management Studio Express and connect to the existing SQL Server instance for vSphere Management.


In the Object Explorer panel, right-click the Databases entry and select New Database.


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

For example: viewComposer


Click OK.

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


Exit Microsoft SQL Server Management Studio Express.

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