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"
No comments:
Post a Comment