motioneye
asked on
Can't access cluetr disk from sql2005
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_d rives 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\Backu p
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_d
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\Backu
That disk is probably only accessible from the other node.
ASKER
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
<<E:\ or any other folder ?>>
Can you describe how you installed the SQL cluster?
Can you describe how you installed the SQL cluster?
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<<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.
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.