Access Denied error when installing SQL 2008 R2 SP2

Question

Trying to install SQL 2008 R2 SP2, getting error "Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC. System.ComponentModel.Win32Exception: Access is denied". The admin account does have all 3 permissions  "Backup files and directories", "Debug Programs" and "Backup files and directories" set. Not sure what else permission I can open up,  any help you could provide would be greatly appreciated.

Thank you!

Grace

Detail.txt

2012-12-12 16:15:21 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2012-12-12 16:15:21 Slp: System.ComponentModel.Win32Exception: Access is denied
2012-12-12 16:15:21 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.RsFxConfiguration.Install()
2012-12-12 16:15:21 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.FilestreamConfiguration.ChangeRsFxDriverVersion(String oldRsFxVersion, String newRsFxVersion)
2012-12-12 16:15:21 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.FilestreamConfiguration.Patch_ConfigRC()
2012-12-12 16:15:21 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.PatchFilestream_RC(EffectiveProperties properties)
2012-12-12 16:15:21 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Patch(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
2012-12-12 16:15:21 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2012-12-12 16:15:21 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2012-12-12 16:15:21 Slp: Exception: System.ComponentModel.Win32Exception.
2012-12-12 16:15:21 Slp: Source: Microsoft.SqlServer.Configuration.SqlServer_ConfigExtension.
2012-12-12 16:15:21 Slp: Message: Access is denied.
2012-12-12 16:15:21 Slp: Watson Bucket 1

Answer 1

Hello,

Please see the following resources:

http://blogs.msdn.com/b/joaol/archive/2008/12/02/sql-server-2008-installation-aborts-due-an-access-denied.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/ed4514fa-8d1d-4383-bbdf-fb06bfbad106/

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Thank you ALberto, I tried above suggestions, still getting the same error "Access is denied". However in "SQL_engine_core_inst_Cpu64_1.txt" file, I noticed something:

MSI (s) (A8:7C) [08:20:33:187]: SOURCEMGMT: Processing URL source list.
MSI (s) (A8:7C) [08:20:33:187]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (A8:7C) [08:20:33:187]: Note: 1: 1706 2: -2147483647 3: sql_engine_core_inst.msi
MSI (s) (A8:7C) [08:20:33:187]: Note: 1: 1706 2:  3: sql_engine_core_inst.msi
MSI (s) (A8:7C) [08:20:33:187]: SOURCEMGMT: Failed to resolve source
MSI (s) (A8:7C) [08:20:33:187]: Failed to generate patch cache opcodes for: {FBD367D1-642F-47CF-B79B-9BE48FB34007} product
MSI (s) (A8:7C) [08:20:33:187]: Resolving source.

Where do I get the missing file? is it supposed to be in the SP2 package?

thanks,

Grace

Answer 3

I finally solved my installation problem after reading a post that got the same error:

http://mvsellers.blogspot.com/2012/06/sql-server-2008-setup-access-is-denied.html

I download and ran MS Process Monitor tool (http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx) while the setup was running, figured out what files and registries being "denied" access, once the required permissions are opened, installation completed successfully.

Just thought to share this with everyone in case someone is having the same struggle as I did.