Vmware virtual disk not available to View
Dear, I have recently installed SQL 2012 standard Ed. on Virtual Windows server 2012 Standard Ed VM Hosting platform is VMWARE EXSi 5.1 and made the Vmware virtual disk, but SQL can not see that Drive, if I go to my computer it is available there.
Any hints?
Even I have tried attaching Raw Device Mapping through SAN but SQL is unable to view that Drive aslo and same drive is available in windoes explorer.
January 8th, 2013 10:10am

Could you please explain the statement "SQL is unable to view that Drive"?.  Is it from SSMS that you could not see those drives?

Also can you run the following T-SQL to check if the new drive is visible for SQL Server?

EXECUTE master.dbo.xp_fixeddrives 

Free Windows Admin Tool Kit Click here and download it now
January 8th, 2013 7:06pm


Dear ,

Iam trying to attach a database .mdf file from MY 'F:' Drive but while i open the attach databases option from SSMS it does not view that drive.

Further more i give you some more details of my Drive its is a LUN drive from SAN storage and directly attached as a Raw Device Mapping  from ESXI 5.1

Iam attaching a screen shot it might clear you.


January 15th, 2013 12:37pm

Have you tried ruing the attach command through code and not using the GUI, In the code you will be able to pass the full file path to it.
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2013 11:59pm

Dear 

I have tried through commad also and it is giving me following error: 



Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "F:\Microsoft SQL Server\MSSQL\DATA\XYZ.mdf" failed with the operating system error 5(Access is denied.).
January 16th, 2013 11:02am

Can you ensure that your SQL Server service account has permissions to access the F drive?

Please also run:

Exec master..xp_fixeddrives

and post the results.

Free Windows Admin Tool Kit Click here and download it now
January 17th, 2013 6:08am

Dear , 

Yes the SQL Server service account has full permissions to access the F drive its in Administrator group

Further more  iam also running the SSMS as admin. 

If i run Exec master..xp_fixeddrives

There is no F Drive 

drive MB free
C xxxxx
E xxxx
January 17th, 2013 10:01am

Saqib,

Any progress on this?

Thanks!

Free Windows Admin Tool Kit Click here and download it now
February 18th, 2013 9:44am

Hi Saqib Ahmad,

 You need disable the HotPlug capability on removable devices in the VM.

To disable HotPlug capability using the vSphere Client:

  1. Connect to the ESXi/ESX host or vCenter Server using the vSphere Client.
  2. Power off the virtual machine.
  3. Right-click the virtual machine and click Edit Settings.
  4. Click the Options tab.
  5. Click General > Configuration Parameters > Add Row.
  6. Insert a new row with the name devices.hotplug and a value of false.
  7. Power on the virtual machine.

Refer Links - http://www.sqlservercentral.com/Forums/Topic1376072-2799-2.aspx#bm1419458

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

__________

LakshmiKanthan

July 20th, 2013 2:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics