How to Reinstalling MSSQL Server 2008 with SP1? (Windows 7)
- by user23884
I am using Windows 7 Ultimate x64. I had earlier installed SQL server 2008 with SP1 with Visual Studio 2008 Team System with sp1. Now that VS2010 is out I wanted to install it so I uninstalled visual studio then MSSLQ Server 2008 SP1 and then SQL Server 2008 as suggested here: h**p://mark.michaelis.net/Blog/SQLServer2008InstallNightmare.aspx
But now when I try to reinstall it I am unable to get it right
I am getting the ERROR: “Attempted to perform an unauthorized operation.” (Following is part of the log file):
  2010-04-16 04:54:57 Slp: Sco:
  Attempting to replace account with sid
  in security descriptor
  D:(A;CI;KR;;;S-1-5-21-2213424280-2581054173-1939225444-1027)
  2010-04-16 04:54:57 Slp:
  ReplaceAccountWithSidInSddl -- SDDL to
  be processed: 
  D:(A;CI;KR;;;S-1-5-21-2213424280-2581054173-1939225444-1027)
  2010-04-16 04:54:57 Slp:
  ReplaceAccountWithSidInSddl -- SDDL to
  be returned: 
  D:(A;CI;KR;;;S-1-5-21-2213424280-2581054173-1939225444-1027)
  2010-04-16 04:54:57 Slp: Prompting
  user if they want to retry this action
  due to the following failure:
  2010-04-16 04:54:57 Slp:
  ---------------------------------------- 2010-04-16 04:54:57 Slp: The following
  is an exception stack listing the
  exceptions in outermost to innermost
  order 2010-04-16 04:54:57 Slp: Inner
  exceptions are being indented
  2010-04-16 04:54:57 Slp:  2010-04-16
  04:54:57 Slp: Exception type:
  Microsoft.SqlServer.Configuration.Sco.ScoException
  2010-04-16 04:54:57 Slp:     Message: 
  2010-04-16 04:54:57 Slp:
  Attempted to perform an unauthorized
  operation. 2010-04-16 04:54:57 Slp:
  Data:  2010-04-16 04:54:57 Slp:
  WatsonData = Microsoft SQL Server
  2010-04-16 04:54:57 Slp:
  DisableRetry = true 2010-04-16
  04:54:57 Slp:     Inner exception
  type:
  System.UnauthorizedAccessException
  2010-04-16 04:54:57 Slp:
  Message:  2010-04-16 04:54:57 Slp:
  Attempted to perform an unauthorized
  operation. 2010-04-16 04:54:57 Slp:
  Stack:  2010-04-16 04:54:57 Slp:
  at
  System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType
  resourceType, String name, SafeHandle
  handle, AccessControlSections
  accessControlSections,
  RawSecurityDescriptor& resultSd)
  2010-04-16 04:54:57 Slp:
  at
  System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType
  resourceType, Boolean isContainer,
  String name, SafeHandle handle,
  AccessControlSections includeSections,
  Boolean createByName,
  ExceptionFromErrorCode
  exceptionFromErrorCode, Object
  exceptionContext) 2010-04-16 04:54:57
  Slp:                 at
  Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType
  resourceType, SafeRegistryHandle
  handle, AccessControlSections
  includeSections) 2010-04-16 04:54:57
  Slp:                 at
  Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey
  key) 2010-04-16 04:54:57 Slp:
  at
  Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String
  sddl, Boolean overwrite) 2010-04-16
  04:54:57 Slp:
  ---------------------------------------- 2010-04-16 10:37:19 Slp: User has
  chosen to cancel this action
  2010-04-16 10:37:19 Slp: Watson Bucket
  2   Original Parameter Values 
  2010-04-16 10:37:19 Slp: Parameter 0 :
  SQL2008@RTM@  2010-04-16 10:37:19 Slp:
  Parameter 2 :
  System.Security.AccessControl.Win32.GetSecurityInfo
  2010-04-16 10:37:19 Slp: Parameter 3 :
  Microsoft.SqlServer.Configuration.Sco.ScoException@1211@1
  2010-04-16 10:37:19 Slp: Parameter 4 :
  System.UnauthorizedAccessException@-2147024891
  2010-04-16 10:37:19 Slp: Parameter 5 :
  SqlBrowserConfigAction_install_ConfigNonRC
  2010-04-16 10:37:19 Slp: Parameter 7 :
  Microsoft SQL Server  2010-04-16
  10:37:19 Slp: Parameter 8 : Microsoft
  SQL Server  2010-04-16 10:37:19 Slp:
  Final Parameter Values
I have googled around for the error given error but all I could find is to regedit and reset permissions on certain reg keys but I don’t see any reg keys with access problem in the log file the log file can be download here: http://www.mediafire.com/?dznizytjznn. Please guys help me out here I am a developer and I cannot afford an OS reinstallation!
Thanks in advance…