Archive for August, 2011

vCenter Server 5.0 and MS SQL Database Permissions

August 20th, 2011

It’s that time again (to bring up the age old topic of Microsoft SQL database permission requirements in order to install VMware vCenter Server).  This brief article focuses on vCenter 5.0.  Permissions on the SQL side haven’t changed at all based on what was required in vSphere 4.  However, the error displayed for lacking required permissions to the MSDB System database has.  In fact, in my opinion it’s a tad misleading.

To review, the vCenter database account being used to make the ODBC connection requires the db_owner role on the MSDB System database during the installation of vCenter Server.  This facilitates the installation of SQL Agent jobs for vCenter statistic rollups.

In the example below, I’m using SQL authentication with an account named vcenter.  I purposely left out its required role on MSDB and you can see below the resulting error:

The DB user entered does not have the required permissions needed to install and configure vCenter Server with the selected DB.  Please correct the following error(s):  The database user ‘vcenter’ does not have the following privileges on the ‘vc50′ database:

EXECUTE sp_add_category

EXECUTE sp_add_job

EXECUTE sp_add_jobschedule

EXECUTE sp_add_jobserver

EXECUTE sp_add_jobstep

EXECUTE sp_delete_job

EXECUTE sp_update_job

SELECT syscategories

SELECT sysjobs

SELECT sysjobsteps

Snagit Capture

Now what I think is misleading about the error thrown is that it’s pointing the finger at missing permissions on the vc50 database.  This is incorrect.  My vcenter SQL account has db_owner permissions on the vc50 vCenter database.  The problem is actually lacking the temporary db_owner permissions on the MSDB System database at vCenter installation time as described earlier.

The steps to rectify this situation are the same as before.  Grant the vcenter account the db_owner role for the MSDB System database, install vCenter, then revoke that role when vCenter installation is complete. While we’re on the subject, the installation of vCenter Update Manager 5.0 with a Microsoft SQL back end database also requires the ODBC connection account to temporarily have db_owner permissions on the MSDB System database.  I do believe this is a new requirement in vSphere 5.0.  If you’re going to install VUM, you might as well do that first before going through the process of revoking the db_owner role.

An example of where that role is added in SQL Server 2008 R2 Management Studio is shown below:

Snagit Capture

VMware Social Media Guy Leaks VMworld 2011 Backpack Details

August 17th, 2011

In a surprise move, VMware employee John Troyer flipped on his internet web camera and proceeded to lose his mind.  Troyer is normally a cool cat who knows how to play by the rules of social media and embargoed information.  He lives by these standard sets of commandments on a daily basis – and commonly conveys them to others.

We’re not sure what happened here. An isolated incident for sure.  He sent out a tweet asking followers to help him test a new webcam site.  That was the hook.  Shortly after gaining live viewers he reached down to the floor with his right hand and grabbed the prototype backpack which he claims will be distributed at VMworld 2011.  Patrons of a Lakeville, MN Caribou Coffee shop happened to be logged on to the internet when they witnessed the streaming video.  A Dutch guy on the internet responded “This guy is a vIdiot. He puts his name and company in the video & leaks intellectual property.”

A TMZ correspondent was anonymously logged into the Vokle.com chat room and captured these exclusive photos of the VMworld 2011 backpack – the holy grail of VMworld swag:

This is the first photo. We can see that the prototype is black and red with white emblem stitching.

8-17-2011 6-09-58 PM

Clearly this backpack says “VMworld 2011″

8-17-2011 6-10-01 PM

Inside the backpack will be a pocket designed to hold an iPad.  Not shown is a drink container on the side.

8-17-2011 6-10-28 PM

VMware is aware of the quality feedback on last year’s backpack stitching.  This year’s will be better and should hold up for the long haul.

8-17-2011 6-10-44 PM

The straps are padded for maximum comfort needed during a 4 day conference.  There was also some mention of headphones but those details are unclear.

8-17-2011 6-11-03 PM

This is the color red but we’re unsure of the final color until Mr. Troyer leaks more info.

8-17-2011 6-11-10 PM

** Of course I’m just having fun here.  John is a swell guy and I know he didn’t break any rules – I’m really looking forward to VMworld.  Thank you John for the impromptu preview of the VMworld 2011 backpack :) **

Pulse Check and New Sponsor – Tintri

August 15th, 2011

Hello VMware virtualization enthusiasts!  The month of August has been intense as VMworld 2011 approaches.  I’ve been working on a few projects which need to get out the door before the the big event.  Unfortunately I’ve had no time to polish vCalendar 3.0 such that it’s ready by show time.  As usual, I’ve been collecting the new content throughout the past year but it’s nowhere near ready for presentation.  The good news is that it’s coming but it may not be until mid September or October.  AND… I’ll still plan on releasing the 2.0 PDF version at no cost.  If you’ve been counting on the new vCalendar, thank you in advance for your patience.

I’ve still got a lot of content in the queue to write about here on the blog.  A lot of it vSphere 5 related.  I’ve also been picking up a lot on SRM 5.  I’ll probably get back into the regular writing schedule after VMworld.  It’s a busy time for VMware and their partners.  I’ve always been busy around VMworld but now that I work for a partner, it’s a new level of busy.

Before I get back to it, I wanted to take this opportunity to introduce a new blog sponsor: Tintri.  They are in the business of providing VM-aware storage without complexity and performance bottlenecks.  Tintri offers 8.5TB of usable storage in a 4u single-datastore footprint.  You’ll find their banner on the right edge of this blog.  Check them out online or stop by their booth at VMworld 2011 in Las Vegas.  Last but not least, you can follow them on Twitter – @TintriInc.

Win a VMworld Pass from StarWind Software

August 7th, 2011

Snagit Capture

Win a Free VMworld Expo Only Pass* from StarWind Software!!!

Would you like to attend VMworld 2011 Expo in Las Vegas? It’s easy and free! Snagit Capture

Follow these simple steps:

1. Click “Like” on the StarWind Software Facebook Fan Page http://www.facebook.com/StarWind.Software

2. Post five benefits of the StarWind product on your Wall starting with the following words: “I like StarWind because…” and put a link to this posting in a comment on the StarWind Fan Page

3. Retweet the following message: I want to win #VMworld Expo Only Pass from #StarWind! http://ow.ly/5PvFD

That’s it! As soon as the number of our fans reaches 200, two Expo Only Passes, valued at $300 each, will be drawn between StarWind fans, and two people with the most interesting lists of benefits will attend VMworld Expo 2011 for free!

The Rules:

• You must be able to attend VMworld 2011 in Las Vegas, Nevada (29 August – 1 September)

• Only one valid entry per person

Note: Here you can view examples of StarWind benefits but don’t use them because we found them first! :) http://www.starwindsoftware.com/benefits 

Read more about VMworld 2011 http://www.vmworld.com/index.jspa

*Expo Only (description):

Solutions Exchange floor access during OPEN hours only, including the Welcome Reception on Monday August 29 5:00-7:30pm. Expo Only passes are NOT admitted to General Sessions, Keynotes, Conference Sessions, Conference Meals or the VMworld Party. Additional Expo Only passes cannot be purchased and will NOT be allowed early access to the Solutions Exchange floor.

VMware Workstation & Fusion Christmas In August Sale!

August 2nd, 2011

30% off through August 4th! All boxed and shrink wrapped copies of VMware Workstation (for Windows & Linux) and VMware Fusion (for Mac) must go!  Hurry while supplies last!  Use promo code PREHOLSALE at checkout for your 30% discount.  Mention boche.net and it is likely that nothing additional will happen.

8-2-2011 11-12-56 PM