I've been rebuilding my VMware lab and decided to do it all right this time by having a centralized database server, and I choose SQL Server 2008 R2. I have configured vCenter, VUM, and View Composer to all use SQL 2008 R2 with windows authentication, then it came time to get the View Events database up and running. Jason Langone has a great article on setting up the events DB using SQL Express, but there isn't a good walkthru for regular SQL server setup. So here we go.
Before we begin, make sure that SQL Server ports are allowed through the firewall. do some googleing and there are plenty of batch files out there that will open them up for you.
VMware View Events Database cannot use Windows Authentication for the SQL backend, so we have to use local authentication. Open up SQL Server Management Studio and go to the properties of the database server Add a comment