SQL Server: Installation completed with warning "Setup has detected a non canonical DACL on directory"

The first of SQL Server installataion completed with success. However, when I installed SQL Server second instance, I encounter the SQL Server with two warnings on DACL:

1. Setup has detected a non canonical discretionary access control list (DACL) on directory 'C:\Program Files\Microsoft SQL Server\MSAS10_50.SS2008R2EE02\OLAP\bin\'. Please verify your security settings and make corrections if needed. 
2. Setup has detected a non canonical discretionary access control list (DACL) on directory 'C:\Program Files\Microsoft SQL Server\MSAS10_50.SS2008R2EE02\OLAP\bin\'. Please verify your security settings and make corrections if needed. 

Upon investigation, I found extra DACL entries that can be safely removed.

Fortunately, SQL Server warning does not affect SQL Server operation.

Have a great day

Admin Script: Increase Service time out to start SQL Server Reporting Services

During SQL Server Installation, SQL Server Reporting Services fails to start for setup default configuration. Fortunately, it can be bypass by press 'Cancel'.

However, SSRS still fails to start manually and it always complain of timeout (default is 30000 = 30 seconds) as shown in below Event viewer.

Hence, the only solution is to increase the Service Timeout.

Have a great day

[Move to blog.ylnotes.com] Upgrade SQL Server 2012 Edition

http://blog.ylnotes.com/sql-server-upgrade-sql-server-2012-edition/