How to Reinstalling MSSQL Server 2008 with SP1? (Windows 7)
- by n10i
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…