This is something I’ve been wanting to do a while. As you recall, I’ve been reinstalling everything in my VMware vSphere 5 home lab I’ve decided that I really need/want/”glutton for punishment” to install SQL Server 2008 R2 and start moving away from the default SQL Express stuff that most of the VMware tools let you get away with. That doesn’t mean I did it for everything, but I wanted to start working on VMware View 5 and thought it might be a great idea to use it as my first reason to install SQL. Shoot me now 🙂 The great news is I learned a ton, and that’s all that matters in my book. Hopefully you will as well.
This install doesn’t get any easier than really doing “next, next next next” and just taking the defaults. If you do that, it keeps things easier down the road. Now, that doesn’t mean it stays easy because I already know what’s going to happen in 3 blogs and I get to fix some of my “next next next” stuff but so will you. Any, why ruin a good opportunity to teach right ?!?
First things first, deploy a Windows 2008 R2 Server from the template you created back in this blog post: Next, make sure it’s all connected into Active Directory and everything is setup the way it needs to be. Then move onto launching the Microsoft SQL 2008 Installation:
1. Click on Run Setup.EXE
2. Click next
3. Since this is a brand new install, choose “New Installation or add features to an existing installation” across the top of the page.
4. it’s going to make sure everything is squared away and it should come back with PASS and no fails. Click Ok
5. Next it asks you to enter in the product key – click next
6. accept the licenses (or not 🙂 and click next
7. it’s going to install the setup files needed for the rest of the installation – click next
8 – you will see the process take off – shouldn’t take very long.
9. Support files looks good – notice the firewall warning – it comes back to haunt me later !!
10. I chose to do the whole thing – I didn’t want to take a chance of needing something down the road.
11. This shows you everything that will be installed – click next
12. Should go in easy peasy – with no errors.
13. Specify any names you want – I just took the defaults and clicked next
14. Review the disk space requirements – my guess is I’ll regret not making this SQL Server bigger then I did – probably a future blog post 🙂
15. Click on Use the “Use the same account for all SQL server Services”
16. I just chose my normal domain admin account – this is my home lab, so security isn’t really something I’m worried to much about – probably another thing I’ll regret down the road 🙂 – onwards and upwards – click next to get all this squared away and on to the next step !!
17. Specify the database engine authentication – In this screen shot I selected Windows Authentication – but I would recommend going to Mixed Mode – trust me in View 5 you will need this.
18. Click on Add current user
19. You should then see your user name show up
20. Just take the default on this and click next
21. Choose whatever makes you sleep better at night !!
22. Setup runs the rules to make sure everything is okay – and then click next.
23. Double check everything – and then click next and go grab a coffee.
24. If everything goes well, you should see the bottom screen shot. Congrats, you just installed Microsoft SQL 2008 R2
See, told you next, next next blah blah – easy peasy…for now.