Cannot Set NTFS Permissions on Files Located on Clustered File Share Resource

View products that this article applies to.

This article was previously published under Q267833

Expand all | Collapse all

SYMPTOMS

When you attempt to modify the NTFS permissions on a file that you have copied to a network share that is located on a cluster server as a File Share resource, the following error messages may be displayed:

Object Picker cannot open because it cannot determine whether
Network Name Resource is joined to a domain.

Unable to display the user selection dialog.
Access is denied.

Back to the top

CAUSE

This behavior can occur if all of the following conditions exist:

SQL 7.0 is installed on the cluster server and was configured as a Cluster resource in an active/passive configuration by using the SQL Failover Wizard.
The file share you are connecting to is hosted by a cluster server as a File Share resource.
The file share source is located on the same hard disk as SQL 7.0 on the cluster server, and is located in the same resource group as SQL 7.0.
You are attempting to modify NTFS permissions on a file that is located on the cluster server by using a user account that does not have administrator privileges on the cluster server.

Back to the top

RESOLUTION

To prevent this behavior from occurring, create the File Share resource in a different cluster resource group, and on a different hard disk than the hard disk on which SQL 7.0 is installed.

Back to the top

MORE INFORMATION

For additional information about file shares on a cluster server, click the article numbers below to view the articles in the Microsoft Knowledge Base:

256926 (http://support.microsoft.com/kb/256926/EN-US/ ) Implementing Home Folders on a Server Cluster

224967 (http://support.microsoft.com/kb/224967/EN-US/ ) How to Create File Shares on a Cluster

254219 (http://support.microsoft.com/kb/254219/EN-US/ ) Security Considerations When Implementing Clustered File Shares

Back to the top