the following blog is more to remind my self on a mistake I do very often. 😉
When I install a SQL Failover Cluster and a High Available Instance on a cluster shared volume, I get the error “Updating permission setting for folder ‘ ‘ failed”.
There are different posts to solve the issue more or less complex.
SQL Installation Error updating permisson setting for folder
SQL Server 2008 installation will fail if the setup account does not have certain user rights
Permission error installing Failover Cluster instance
In my case the solution was pretty easy. I mostly forget to create a sub directory for SQL Databases and Files on the cluster shared volume. So as example:
C.\ClusterStorage\SQL-Backup\ <- will give you the error
C:\ClusterStorage\SQL-Backup\Files\ <- will work fine
So easy solution for the error, create a subfolder and install use that path during installation.
Microsoft Press released a new free eBook about Data Access for Highly-Scalable Solutions: Using SQL, NoSQL, and Polyglot Persistence. You can download it here.
Note: There are multiple files available for this download. Once you click on the “Download” button, you will be prompted to select the files you need.
This is a PDF version of the on-line guidance available on MSDN
Data Access for Highly-Scalable Solutions: Using SQL, NoSQL, and Polyglot Persistence
This guide describes how to design and build applications and services that can take best advantage of SQL and NoSQL databases by combining them into a polyglot solution. It provides an end to end walkthrough of a business application that uses SQL Server in conjunction with a variety of NoSQL databases, showing how the designers selected the databases to closely match the various business requirements. This guide has an accompanying reference implementation of an online ordering system. The sample code illustrates how to implement a polyglot solution that stores data in a variety of SQL and NoSQL databases, and how to decouple the data access logic from the business logic of the application.
Like with reference architectures before, Dell gives you on his global Dell TechCenter now a reference architecture for Microsoft SQL Server 2012 OLTP Applications.
You can find the whitepaper here.
Microsoft SQL Server 2012 Solutions for OLTP Applications on Dell PowerEdge VRTX
Dell PowerEdge VRTX Tower Version Source: www.dell.com