Wednesday, 23 April 2014

VDP Advanced SQL Agent Permissions

I've been playing around with the VDP Advanced appliance recently and can across this little gotcha when using the SQL agent to backup individual databases.  After downloading and installing the agent on my SQL server and creating a new application backup job when it came to selecting the databases I would only see the default three which were master, msdb and tempdb:


After searching for a while I was unable to find anything relating to this error and the VDP 5.5.5 Admin Guide doesn't mention the fix.  I assumed it would be a permission problem so I added the vCenter service account to the local administrators group to ensure it had full access to SQL.  This didn't resolve the issue, I then checked the Backup Agent service which was running as the Local System user and realised that it obviously didn't have permission to SQL.  I changed this account to run as the vCenter service account and then created the backup job again and hey presto:


I removed the vCenter service account from the local administrators group and added it to a global SQL administrators group just to tidy things up.  Remember this is my lab environment so I'm comfortable with the vCenter service account having those permissions.

Wednesday, 16 April 2014

VMware vForum 2014

Just a quick post to let you know that VMware's vForum UK dates have been announced and the agenda released.    The UK locations will be in Manchester and London and more information and dates can be found below:

London
11th June 2014

Wembley Stadium
Wembley
London
HA9 0WS


8th July 2014

Manchester Central
Windmill Street
Manchester
M2 3GX


Hopefully I'll be either a booth babe for the day or presenting so if you see me, come up and say hi.

Monday, 14 April 2014

RoyalTSX for vEXPERTS

If your a vEXPERT then code4ward.net are offering you a free NFR license to either the Windows or Mac version of Royal TS software.  More information is available at the links below and you can request your free license here:

Royal TSX
Royal TS

First of all, BIG THANKS to the guys for offering this to the community, it's very much appreciated.  I've been looking for a decent remote desktop solution for accessing my homelab on both my internal network and externally on public Wifi spots etc.  I normally use the Microsoft Remote Desktop application which has served it's purpose well as it offers full screen access but more especially access via Remote Desktop Gateway so I don't have to VPN back into my lab all the time.  The only issue I had with it was when working on multiple servers I had to swap spaces or have multiple connections on screen and keep swapping between them.  When I wanted to SSH into hosts then I'd have to open putty or terminal and access the console from another window.

Since installing Royal TSX it's now my default Remote Desktop application for accessing anything in my lab as well as on customer sites.  In the screen shot below you can see I have a connection to both my Windows 7 jumpbox PC as well as an SSH session into a host and it's interchangeable via the tabs:


It supports Remote Desktop Gateway and obviously all the usual functionality with regards to creating a credential store to automatically pass through your credentials.  It supports connections via RDP, VNC, Terminal and web pages all via installable plugins.  I've only been using it for a week but so far I'm very impressed.

David Owen (Blog | Twitter) has a great post of all other vendors who help out the community, not just VMware, with freebies and NFR licenses.  Thanks very much everyone, it's very much appreciated.

Monday, 7 April 2014

VDP Advanced Error - Failed to initiate a backup or restore for a virtual machine. Probable cause is the datastore for the virtual machine is not accessible

I've recently been upgrading all of my VM's from Windows 2012 to 2012 R2 and now it was time to deploy a new domain controller.  I build the new DC, promoted it and migrated DHCP etc and all was well.  It was then time to re-configure all my VM's to point to the new DC for DNS resolution.  I changed the VDP appliance to use the new DC for DNS and rebooted as requested.  When checking my backups the next day I realised that they have all failed with the following error:

Error: Failed to initiate a backup or restore for a virtual machine.  Probable cause is the datastore for the virtual machine is not accessible


In order to try and resolve the issue I change the DNS server back to the original DC and rebooted.  I really didn't think this caused the initial issue but it was the only thing that had changed.  As expected, this didn't resolve the issue.  When searching for the resolution I did come across this KB article which asks you to verify that all datastores are actually associated with hosts but this did not resolve my issue.  I finally tried rebooting the hosts to see if this resolved and also re-creating the backup job but no success.

After following Cormac Hogans (Blog | Twitter) excellent article I realised that there were no log files available from the date the issue started happening which was Thursday 3rd April (Last successful backup was on the 2nd April)


So, I guess what I'm really asking now is has anyone else seen this issue or can anyone point me in a direction to start investigation?

Update - 7/04/2014

After searching through various log files and google I did find this article which shows an error message that I was seeing in one of the log files.  The resolution was to stop and start the MCS service with the following commands via an SSH session:

dpnctl stop mcs
dpnctl start mcs

After doing this the backups still failed but I then gave the appliance another reboot and it looks like that might have resolved it.  A backup of an individual machine is currently running so I'll see what happens tomorrow morning

Update - 8/04/2014

All backups have completed successfully last night so looks like the fix above has worked.  


Wednesday, 2 April 2014

vEXPERT 2014

Well the results for the vEXPERT 2014 nominations have been released and I'm pleased to say that I made it for a 2nd year running.  There were 754 people who made the list so congratulations to everyone.  The full list can be found here

A special thanks goes out Corey Romero and John Troyer for all the hard work involved in vetting all the nominations and also arranging all the back end logistics, thanks guys.

Wednesday, 12 March 2014

VMUG Presentations

Just a quick post to say that I will be presenting at the following VMUG's this month:

Thursday 13th @North East VMUG

At the North East VMUG I'll be giving a presentation on Home Labs and what I currently use at home.
You can register for the VMUG here

Thursday 20th @ Scottish VMUG

At the Scottish VMUG in Glasgow I'll be giving a deep dive in whats new in vSphere 5.5 with demo's around the new Web Client, 62TB VMDK's, vSphere Flash Read Cache, Traffic Filtering and Packet capturing.

You can register for the VMUG here

Sunday, 23 February 2014

vSphere Top Blogs

Just a quick post to say that Eric Siebert (Blog | Twitter ) over at vSphere Land has opened the poll for the top blogs for 2014.  Last year I made it into the top 200 so I'm gonna see if I can do a little better this year.  So, if you've found anything useful on my blog at all then please vote for me via the VOTE link below.

Big thanks go out to Eric and all the sponsors.  I know he put a lot of effort into this all in his own time and it's very much appreciated.