Can't access cluetr disk from sql2005

motioneye
motioneye used Ask the Experts™
on
I got following error when trying to access cluster disk from SSMS

H:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.  

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

------------------------------
BUTTONS:

OK
------------------------------

I also try with exec master..xp_cmdshell 'dir e:\ returned me access is denied.

But when I'm using windows cmd I have an access, in fact using windows I do have access to the disk



C:\>dir h:\
 Volume in drive H has no label.
 Volume Serial Number is 0A69-0B44

 Directory of h:\

06/03/2009  10:29 PM    <DIR>          BroBackups
12/04/2008  11:41 AM    <DIR>          BackupEventLog
02/18/2009  04:16 PM             5,536 Test.sql
07/14/2009  07:29 AM    <DIR>          DatabaseBackups
09/23/2008  06:55 PM    <DIR>          Excel
09/26/2007  03:51 PM    <DIR>          Microsoft SQL Server
09/26/2007  02:54 PM    <DIR>          MSDtc


I ran SELECT * FROM sys.dm_io_cluster_shared_drives in SSMS and it prompt me H:\ as drivename

Then I ran a backup as backup database to disk='Mydata.bak" which default backup directory as following, it worked fine to access the path, but why I can't access the disk ? E:\ or any other folder ?

H:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
That disk is probably only accessible from the other node.

Author

Commented:
If the disk will only available from the other node, what caused this ? how do we fix it ? I check from the cluadmin and it found all resources online on the same node
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist

Commented:
<<E:\ or any other folder ?>>
Can you describe how you installed the SQL cluster?
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Hi,
The installation done by the 3rd party, the server has not been rebooted since last 6 mth, we just realized this when we tried to configure local backup other than default directory, the same thing also happen when we tried to create new database where we not able to use other than default folder, E:\ is still accessible if we use default folder for backups and creating new database.
I also run xp_fixeddrives but the results return with no E:\ drive available. within the cluster I can see E:\ part of the SQL group
Commented:
Can you logon to the other node and see what drives are available
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist

Commented:
<<I also run xp_fixeddrives but the results return with no E:\ drive available. within the cluster I can see E:\ part of the SQL group>>
The fact of seeing the physical disk disk resource is not sufficient to guarantee the SQL service can actually see it or access it.  Clearly, it seems the engine does not see the ressource.  Check and see if the SQL service has appropriate credential/configuration to do so.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial