Sql Server 2012 can't see 2nd drive

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Sql Server 2012 can't see 2nd drive

23 posts, Page 2 of 3

««1 2 3 »»

Sql Server 2012 can't see 2nd drive

Rate Topic

Display Mode

Topic Options

Author

Message

knightdragon89

Posted Wednesday, October 17, 2012 6:25 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 18, 2012 7:12 AM
Points: 1, Visits: 1

I'm having the same problem.
Server 2012 standard edition
SQL Server 2012 enterprise edition
a domain service account, which is also in the server's local administrator group
the domain service account is a sysadmin in MSSQL
SQL Server is in mixed mode

when I run the MSSQLSERVER service as the domain service account, I can only see the C drive from within MSSQL
when I run the service as Local System account, I can see all of my drives

It 'seems' that things run as local system account, but I "need" it to run as a domain service account so I can use ALWAYSON.
Any thoughts or ideas? I'm at a loss.

Post #1374092

machine2473

Posted Monday, November 12, 2012 7:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:31 PM
Points: 4, Visits: 363

Same issue here.

SQL 2012 Enterprise w/ SP1, installed and running on Windows Server 2012 Standard.
The per-service SIDs were added with full control to the drives/folders set aside for user databases but the instance is still unable to "see" the non-C: drives.

Post #1383711

dmccosh

Posted Thursday, November 22, 2012 5:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 1:31 AM
Points: 2, Visits: 6

I'm Having the exact same problem too!!

As a test I installed SQL 2012 on 2008R2 without issue (using the same "vanilla install" & service accounts (domain))

Both machines are VM's (running on ESX5)

Trying to figure out where the source of the problem is - looks more like a Windows Server 2012 or Hypervisor issue....

Anyone experiencing anything similar?

Post #1387856

machine2473

Posted Monday, November 26, 2012 11:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:31 PM
Points: 4, Visits: 363

Ours is on a Windows Server 2012 VM also.

Post #1388765

dmccosh

Posted Monday, November 26, 2012 1:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 1:31 AM
Points: 2, Visits: 6

Group policy was the problem in our case, try putting your win server in an Ou that inherits no group policy, we were having problems with "audit object access"

Post #1388819

Kudikai

Posted Monday, December 03, 2012 2:10 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:24 AM
Points: 162, Visits: 360

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.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

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.

Post #1392141

Paul Kalinski

Posted Monday, December 03, 2012 5:03 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 3:07 PM
Points: 14, Visits: 67

Thanks heaps Kudikai the vmware fix worked for me

Post #1392189

machine2473

Posted Tuesday, December 11, 2012 9:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:31 PM
Points: 4, Visits: 363

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.

Post #1395204

james 93738

Posted Tuesday, December 11, 2012 3:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 02, 2013 12:15 PM
Points: 2, Visits: 18

Kudikai (12/3/2012)

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!

Post #1395349

Express12

Posted Friday, February 15, 2013 9:00 AM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:31 AM
Points: 618, Visits: 835

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..

BT

Post #1420603

« Prev Topic | Next Topic »

23 posts, Page 2 of 3

««1 2 3 »»

Permissions