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 on the same system as vCenter Server, 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 vCenter Server computer 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.

http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

1

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

2

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

3

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

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 Express adds your database to the Databases entry in the Object Explorer panel.

6

Exit Microsoft SQL Server Management Studio Express.

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