The last couple of weekends have afforded me some SERIOUS VMware Home Lab time and out of that is a few blog posts around what I’ve been up to. In one of my prior blog posts I spoke about my new home lab (still working on that blog) and my endeavor to install everything from scratch. It also motivated me to get outside of my comfort zone and install SQL 2008 R2 for all the stuff that VMware requires its use of. The first thing on my list to add into my new SQL Database was VMware View 5. This blog post will take you through the first part of creating the database that view 5 needs. Let’s get started !!
So the install of Microsoft SQL 2008 R2 should have been easy!! Now the next step is to create the VMware View 5 database that View 5 will use. This step by step guide will help you get this setup in your VMware vSphere 5 home lab.
1. RDP into your SQL Server and click on Start, Programs, SQL Server Management Studio
2. Next just click connect – keep defaults in my case.
3. Once that opens, expand the database folder, then right click on it and choose “New database”
4. Name your database, in this case I wanted to keep it easy so I named it VMwareView5
5. Based on some reading around, I then clicked on Options and chose to change the recovery model to Simple – my understanding is it will cut down on disk space etc. Fingers crossed I don’t regret this down the road !!
6. Next thing I did was create a new role under Security. You will need a local SQL Account and not your Domain ID so this is where we would create a new local account. In this case, expand Security, expand Logins and right click to create a new Login.
7. I created a new local user and setup the password for it (it looks greyed out – that’s a screen shot issue you won’t see)– UPDATE: PLEASE uncheck enforce password expiration – Click OK
8. Now right click on that new user and go to properties
9. Then give them rights to the View 5 DB as well as make them the DB owner.
10. And we are done. You can see the DB we created (VMwareView5) as well as the new local user we created.
That’s it !! Everything should be good to go. The next step is to go and “Setup ODBC connection for View 5 inside vCenter 5” for VMware View to use.
If you have any questions, feel free to leave a comment.