Installation mistake : SQL Server on mount points:

The other day my colleague told that he is facing permission error while doing the installation. On checking found below error. It is a common mistake that we do make assuming the root of the mount point as a folder 🙂 .

Error_mounpoint

This issue occurs when you are trying to install SQL Server to the root of the mount point. Avoid that, instead create and install into a folder under the mount point to allow the correct propagation of permissions. The permissions that are applied to the root drive file system will not be propagating to the mount point file systems, they are controlled separately.

Another option is to add sql service account which we are using for installation as owner of the ‘ResumeKeyFilter.store’ (under system volume information/advanced security settings) of the mentioned mount point in the error. But, it’s a time consuming process and changing system configurations is bit risky at a later stage. It’s always better to create a folder under the mount point for smooth installation.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s