October 6, 2008 at 12:58 pm
Greetings,
I'm currently 0-11 with a SQL 2008 installation .. receive "Access is Denied" error messages. I've reviewed most of the postings on this forum and tried several resolution steps--all leading back to the same error message again and again.
Any help would be greatly appreciated. Not sure what the issue is...
Thanks,
Jay
==================
Server specs:
- Windows Server 2003 SP2
- X86 32 bit
- IIS with .NET 1.1, 2.0, 3.0 and 3.5 (3.5 installed via SQL setup)
Steps tried:
- Installed using local admin account
- Installed using network account with local admin rights
- Enabled WinHTTPAutoProxy service and checked registry permissions; added permission to include full control for local administrators to several Legacy_WinHTTPAutoProxy hives under HKLM
- Tried to install just basic SQL engine component (without Reporting Services, full text search)
- Disabled IE Security
================
Via setup.exe, setup fails at step SQLEngineDBStartConfigAction_install_Configrc_Cpu32
From the logs:
2008-10-06 09:03:29 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2008-10-06 09:03:29 Slp: Access is denied
2008-10-06 09:03:29 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2008-10-06 09:03:30 Slp: System.ComponentModel.Win32Exception: Access is denied
2008-10-06 09:03:30 Slp: at System.Diagnostics.ProcessManager.OpenProcess(Int32 processId, Int32 access, Boolean throwIfExited)
2008-10-06 09:03:30 Slp: at System.Diagnostics.Process.GetProcessHandle(Int32 access, Boolean throwIfExited)
2008-10-06 09:03:30 Slp: at System.Diagnostics.Process.OpenProcessHandle()
2008-10-06 09:03:30 Slp: at System.Diagnostics.Process.get_Handle()
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart(Process processSql)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(String[] parameters)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerStartup.StartSQLServerForInstall(String sqlCollation, String masterFullPath, Boolean isConfiguringTemplateDBs)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.ConfigSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean useInstallInputs)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.DoCommonDBStartConfig(ConfigActionTiming timing)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2008-10-06 09:03:30 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2008-10-06 09:03:30 Slp: Exception: System.ComponentModel.Win32Exception.
2008-10-06 09:03:30 Slp: Source: System.
2008-10-06 09:03:30 Slp: Message: Access is denied.
2008-10-06 09:03:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081006_085054\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2008-10-06 09:03:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081006_085054\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2008-10-06 09:03:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081006_085054\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2008-10-06 09:03:44 Slp: Access is denied
2008-10-06 09:03:44 Slp: Watson bucket for exception based failure has been created
November 13, 2008 at 12:15 pm
I've got the exact same problem....no matter what user rights I've tried.
I get the exact same results on (2) servers with dual CPU 3 ghz 32bit running Windows 2003.
Two weeks earlier, I had a SQL Server 2000 install working with no problems. Used the exact same NT Authority\System users and my Admin Domain users....all installs have died.
tripathdev,
Any luck on your install....I'm getting pretty close to 0-11 as well. I'm using version:
Database Engine Tuning Advisor10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework2.0.50727.3053
Operating System
November 21, 2008 at 1:18 pm
I posted a message about this too. I am now 1-2 in installs. A 64-bit Vista system couldn't install, A 32-bit Vista system installed fine and a 32-bit XP system failed. The XP system got hung on a completely different file than the Vista system. All installs were done as the administrator of the PC, in fact on the Vista-64 system I was logged in as THE domain administrator.
I can't believe that this is not a more wide spread problem (with some resolution).
December 29, 2008 at 2:50 pm
buddy__a (11/21/2008)
I can't believe that this is not a more wide spread problem (with some resolution).
Oh it is a problem....just nobody with an answer. I posted this in the N00b section, but should have posted it here...so heregoes:
I am a SQL n00b, mostly using some hand-jammed ASP to access/update data. Now I have been tasked to develop a web map of our campus so I need the geospatial functionality of SQL 2008. I have a server (Windows 2003) that is limited by domain policy. I tried to install SQL 2008, but when it gets to the part where it is starting the service it craps out and says “Access Denied.” So I installed SQL 2005 without a glitch (using the exact service account) and it works flawlessly. So I tried to upgrade the SQL 2005 install to SQL 2008 and it again made it to the part where it tried to restart the service and it craps out saying something about poor server health and that the service could not be restarted. I can restart the service no problem with SQL 2005. I have looked everywhere trying to find an answer to this. The one “tidbit” I found was that you must use an account that has “Logon as a Service” permissions; however, that is disabled by group policy. Again, SQL 2005 works great using the same account…does SQL 2008 require more out of the service account than 2005? Any help, insight, or even general comments are appreciated. Thanks!
December 31, 2009 at 9:45 am
I know this a year late, but I found this as I was trouble shooting the same problem.
A windows 2008 server requires the local admin group(provided the person running the install is an administrator), or the persons domain account that is running the installation from the SQL 2008 cd to be added to the Local Group Policy rights on Debug Programs & Manage Auditing and security log.
to get to this Click Start | Run | type gpedit.msc
Click Computer Configuration | Windows Settings | Local Policies | User Rights Assignment
check to make sure the proper rights have been granted to those 2 groups.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
June 3, 2010 at 7:30 pm
Bradley B,
That was it, thanks!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply