How to Configure VMware View 4.5’s Event Database with SQLExpress

For many small environments, labs, demo centers, et cetera, the vCenter database lives on the vCenter server using the default SQLExpress installation from the View installation.

To proceed with the configuration below, you will need to install SQL S erver Management Studio Express (SSMSE).  This will give us a GUI interface for the SQL Express installation. I'm by no means a SQL expert, so if there's a better way to do this, I'm all open. I mostly pulled information from this thread.

  • Open SSMSE, right click the top item, SQLEXP_VIM and go to .
  • Set the server to use SQL Server and Windows Authentication mode.
  • Right click Databases and create a new database (e.g. ViewEvents).
  • Under Security –> Logins, right-click and select New Login.
  • Create a login (e.g. viewdb), use SQL Authentication and set the default database to ViewEvents.
  • Under User Mapping, click ViewEvents (viewdb should automatically be populated in the User column).
  • In the Database role membership for: msdb sub-pane, check db_owner.
  • Ensure Remote Connections are allowed.
  • Determine the port in use by SQL Express by opening SQL Server Configuration Manager.
  • Expand SQL Server 2005 Network Configuration and select Protocols for SQLEXP_VIM.
  • Right-click TCP/IP and select Properties.
  • Click the IP Addresses tab.
  • In IP1 should be the IP address in use by the vCenter server (e.g. 98.172.175.86).
  • Set Enabled to Yes.
  • If TCP Dynamics Ports is set to 0 (which it likely is), take note of the TCP Dynamic Ports field towards the bottom (e.g. 1160).
  • Open services.msc and restart the SQL Express Server service.
  • Go to the View Admin page (https://viewserver/admin).
  • Expand View Configuration and select Event Configuration.
  • Click Edit.
  • Enter the FQDN of the vCenter server and ONLY the FQDN of the vCenter server (not SQLEXP_VIM or anything else).
  • Set Database Type to Microsoft SQL Server.
  • Set the Port to the static or dynamic port as determined above (e.g. 1160).
  • Set the Database name to the database name (e.g. ViewEvents).
  • Enter the username create for SQL authentication (e.g. viewdb).  Enter the password associated with this account.
  • Enter a table prefix (e.g. VDI).