December 3, 2012 at 2:10 pm
We ran into a similar problem when installing SQL 2012 on a Server 2012 VMWare ESXi 5.x host. The audit policy was our first thought and with enterprise GPOs pushing that out we searched for other solutions. What ended up fixing it was a VMWare setting change.
Another symptom that pointed us at VMWare was that only the C$ admin share was accessible. None of the other drive admin shares worked. Turning off this hot swap setting fixed it for us.
I hope that saves someone the days we spent troubleshooting it.
December 3, 2012 at 5:03 pm
Thanks heaps Kudikai the vmware fix worked for me
December 11, 2012 at 9:45 am
Kudikai's VM config change worked for us, too.
Indeed Kudikai is a SQL god, and a chorus of angels descended to trumpet the miracle.
December 11, 2012 at 3:59 pm
Kudikai (12/3/2012)
We ran into a similar problem when installing SQL 2012 on a Server 2012 VMWare ESXi 5.x host. The audit policy was our first thought and with enterprise GPOs pushing that out we searched for other solutions. What ended up fixing it was a VMWare setting change.Another symptom that pointed us at VMWare was that only the C$ admin share was accessible. None of the other drive admin shares worked. Turning off this hot swap setting fixed it for us.
I hope that saves someone the days we spent troubleshooting it.
You are officially my hero right now, while unfortunately it didn't save me days of troubleshooting, it did save me. http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/a576aa0e-5a08-4c9c-a583-af1815cd8b8e I have been beating my head against a wall regarding my issue in that thread, and your solution fixed it. Slightly different issue but same scenario, thanks!
February 15, 2013 at 9:00 am
Applying the VMWare KB fix worked for us: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225
thank you..
March 22, 2013 at 11:27 am
Either the Group Policy change (though you can use Advanced Audit Policy Settings rather than "legacy" of Object Access and drill down further to not use "Audit Removable Storage" - there's changes involved that I don't know the details of between using the legacy and Advanced Auditing) or the VM hotplug disk fix should work. I got caught out with this as well. Microsoft said that there would be fix for the OS sometime out in April, apparently it's in test with some customers.
I had the VM hotplug fix put in place was the easiest without having to go through changing Group Policy - and change control :crazy:
BUT I don't think it matters either way, you will need to re-install from scratch as it messes up the master database if you try and carry on as it were. Fresh install post fix, no worries. 😎
April 12, 2013 at 9:25 am
April 12, 2013 at 6:58 pm
N/M
September 30, 2013 at 7:49 am
I'm having the same problem om 2 servers.
The servers has been running fine before for several months.
Win Server 2012 standard ( the other one is a Win Server 2008 R2 standard)
and SQL Server 2012 Standard
The VMWare Hotplug fix did not solve the problem.
Getting error messages about "access denied"
The local service accounts are in the sysadmin role.
Adding them to the local administrators Group solves the problem
but it is not best practices.
Regards C
September 30, 2013 at 2:18 pm
The VMWare hotfix is only applicable to Windows 2012 - this is now superseded by a MS patch http://support.microsoft.com/kb/2811670 - recently tested.
Sorry the access denied issue on Windows 2008 and Windows 2012 is not the same issue as this thread. Yours sounds like Group Policy maybe. Probably best to start a different thread to avoid confusion.
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply