Tuesday, July 31

Don't: Using vC SQL Express as View's Event database

Now this shall be used as demo/lab only. Express is a toy anyway.
I used vC 5.0 and View 5.1 - versions apply.
To use vCenter's stock installed SQL Express as the Events database of View, do the following steps:

  • Setup mixed mode authentication and a user/DB in the SQL Express:
    • Download & install SQL Server 2008 Management Studio Express on the VC. This blog post may help.
    • Login using Windows authentication.The server name can be "." or localhost...
    • Right-click on the top of the tree (SQL server), choose properties. Choose "SQL Server and Windows Authentication mode" on the Security tab. OK.
    • Open Securty/Logins in the tree. Right click on Logins, New Login.
    • Setup a new user. Make sure it's using SQL Server authentication.
    • Right-click on Databases. Create a New Database. It's owner should be the newly created user from above. You can now exit the whole thing.
  • Open SQL server configuration manager. Choose SQL Server Network Configuration. Click on Protocols for VIM_SQLEXP. Right-click on TCP/IP. Properties.
  • Make sure General is enabled on the Protocol tab (should be). Set enabled and active to yes on the IP (IP Addresses tab) that View will use to communicate. Clear out TCP dynamic ports setting everywhere - no 0 or anything in them. Set IPAll TCP Port to 1433. Apply & close.
  • Open TCP port 1433 on the firewall for connections, just in case ;)
  • Reboot or restart SQL and VC services by hand.
  • You can check the SQL is listening on TCP 1433 by issuing the command "netstat -an -p TCP" in a command prompt, and looking for the line "TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING"
After this, you can connect the Events database from the View administrator to this SQLe. You can check "%programdata%\VMware\VDM\logs" on the view server for any errors.

No comments:

Post a Comment