Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Sql Server 2012 can't see 2nd drive Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 11:27 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:58 AM
Points: 365, Visits: 947
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

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.
Post #1434437
Posted Friday, April 12, 2013 9:25 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 10, 2014 4:15 AM
Points: 293, Visits: 816
+1 for http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225
Thank You!
Post #1441768
Posted Friday, April 12, 2013 6:58 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 10, 2014 4:15 AM
Points: 293, Visits: 816
N/M
Post #1441984
Posted Monday, September 30, 2013 7:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 14, 2014 8:02 AM
Points: 4, Visits: 73
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
Post #1500012
Posted Monday, September 30, 2013 2:18 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:58 AM
Points: 365, Visits: 947
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.
Post #1500191
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse