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 Wednesday, October 17, 2012 6:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, November 12, 2012 7:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 6:37 AM
Points: 4, Visits: 394
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
Posted Thursday, November 22, 2012 5:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 6:21 AM
Points: 2, Visits: 11
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
Posted Monday, November 26, 2012 11:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 6:37 AM
Points: 4, Visits: 394
Ours is on a Windows Server 2012 VM also.
Post #1388765
Posted Monday, November 26, 2012 1:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 6:21 AM
Points: 2, Visits: 11
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
Posted Monday, December 3, 2012 2:10 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 2:47 PM
Points: 164, Visits: 432
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
Posted Monday, December 3, 2012 5:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, July 21, 2013 10:49 PM
Points: 15, Visits: 73
Thanks heaps Kudikai the vmware fix worked for me
Post #1392189
Posted Tuesday, December 11, 2012 9:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 6:37 AM
Points: 4, Visits: 394
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
Posted Tuesday, December 11, 2012 3:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 2, Visits: 18
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.

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.

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
Posted Friday, February 15, 2013 9:00 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
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 »

Add to briefcase ««123»»

Permissions Expand / Collapse