A new function in View 4.5 is the event database which stores as the name already says events. The event database can be configured via View Administrator but must be created before. The following example shows how to create a database on a Mircosoft SQL Server Express. Open a command prompt on the server running the database and use this command to create a database:

C:\>osql -E -S vcenter.xxx.cd-k.de\SQLEXP_VIM
1> create database ViewEvents
2> go
1> exit

Then logon to the View Administrator and expand the View configuration option in the menu bar and select Event configuration. This page will allow you to configure a event database with the View Manager. It’s essential that you’ve created the database before, because there is now option to do it here.

Ensure that your SQL Server is configured correctly. Then check if SQL Server and Windows Authentication mode is enabled on the server. The easiest way for checking that is using the SQL Server Management Studio Express. Do right-click on server and choose Properties. Under Security select SQL Server and Windows Authentication mode. Then go to connections and allow Remote Connections to the SQL server by setting the checkbox.

If not already done please create a new database called ViewEvents for example. You can also do that through the Management Studio when clicking with the right mouse button on Databases then enter a database name.

After that you’ve to create a new login. Within SQL Server Management Studio Express select SQL Server Authentication and provide username and password. Then change the default database to ViewEvents. In the next step please set the user mapping. Set the default schema to dbo and set the role membership to db_owner & public. Then set status and grant permissions to connect, also enable the login.

As SQL Express is using dynamic Ports (not the standard port 1433) use the SQL Server Configuration Manager to find this TCP port. You’ll need it for the configuration as seen in the screenshot below.

When configured properly you’ll see the events when clicking on Monitoring, Events in the left menu pane. These information could also be obtained by using reporting tools which are accessing the database directly.

The event database gives you all information about the virtual desktop environment on one page. With the new role based administration modell you can give the monitoring team or helpdesk just access to teh events page if you want. For the database Microsoft SQL and Oracle is supported in this version.

Similar Posts:

• View database backup
• vCenter permissions for the View Manager user
• How to use Novell with VMware View
• VMware View with Novell OES and DSfW
• Role based administration