Create a Database and DSN for Linked Clone Desktops

In this example where going to create a database instance and DSN for VMware View Composer on the standard database who is created during the installation of vCenter.

Add a linked clone desktop database instance to SQL Server 2005

Download and install SQL Server Management Studio Expres from Microsoft.

  1. On the vCenter host: Start | All Programs | Mircosoft SQL Server 2005 | SQL Server Management Studio Express and connect to the existing SQL Server instance.
  2. In the Object explorer pane, right-click the Database entry and select New Database.. The New Database dialog appears.
  3. Enter a name (Example: VMwareView) in the Database name field and click Ok.
  4. Exit

Add an ODBC datasource

  1. Select Start | Administrative Tools | Data Source (ODBC).
  2. Select the System DSN tab
  3. Click Add and select SQL Native Client from the list.
  4. Enter a name (Example: Vmware View Link Clones) and a brief description of the database. In the server field select your server (hostnamedatabasename) and click Next.
  5. Make sure the Connect to SQL Server to obtain default settings for the additional configuration options is selected.
  6. Select the authentication method:
    • With intergrated Windows authentication: Works only if the database is on the vCenter host)
    • With SQL Server authentication usering a login ID and password entered by the user: Use this option if you dabase is on a seperate server
  7. Enable the Change the default database to checkbox and select the database your earlier created and click Next.
  8. Click Finish and Ok.
  9. Close the ODBC Data Source Administrator.

About Michael
Michael Wilmsen is a VMware training/consultant (no specific order) with more than 15 years in the IT industry. Main focus is VMware vSphere, Horizon View and Site Recovery Manager with a deepdive to performance. Michael is VCDX 210, VCAP 4/5 certified, has been rewarded with the vExpert title from 2011, is a PernixPro, Nutanix Tech Champion and a Nutanix Platform Professional.

4 Comments to “Create a Database and DSN for Linked Clone Desktops”

  1. By SQL Tutorials, May 1, 2009 @ 03:14

    Does anyone know if there is another language or set of commands beside SQL for talking with databases?

    I’m working on a project and am doing some research thanks

    • By Mike, May 5, 2009 @ 15:07

      Hi, As far as I know, SQL is the only query language that is supported. If you find another, please
      let me know!

  2. By SQL Tutorials, May 1, 2009 @ 03:14

    Does anyone know if there is another language or set of commands beside SQL for talking with databases?

    I’m working on a project and am doing some research thanks

    • By Mike, May 5, 2009 @ 15:07

      Hi, As far as I know, SQL is the only query language that is supported. If you find another, please
      let me know!

RSS feed for comments on this post. TrackBack URI

Leave a Reply

You must be logged in to post a comment.