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.
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
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.
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.).
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.
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 freeC xxxxx
E xxxx
Saqib,
Any progress on this?
Thanks!
Hi Saqib Ahmad,
You need disable the HotPlug capability on removable devices in the VM.
To disable HotPlug capability using the vSphere Client:- Connect to the ESXi/ESX host or vCenter Server using the vSphere Client.
- Power off the virtual machine.
- Right-click the virtual machine and click Edit Settings.
- Click the Options tab.
- Click General > Configuration Parameters > Add Row.
- Insert a new row with the name
devices.hotplug
and a value offalse
. - Power on the virtual machine.
Refer Links - http://www.sqlservercentral.com/Forums/Topic1376072-2799-2.aspx#bm1419458
__________
LakshmiKanthan