SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sql Server 2012 can't see 2nd drive


Sql Server 2012 can't see 2nd drive

Author
Message
Fozzie
Fozzie
Say Hey Kid
Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)

Group: General Forum Members
Points: 711 Visits: 1172
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. Cool
Jon.Morisi
Jon.Morisi
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2903 Visits: 1142
+1 for http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225
Thank You!
Jon.Morisi
Jon.Morisi
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2903 Visits: 1142
N/M
Carlosql
Carlosql
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 95
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
Fozzie
Fozzie
Say Hey Kid
Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)

Group: General Forum Members
Points: 711 Visits: 1172
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search