서버환경 : 윈도우 2008 R2 Standard
서비스팩 : 서비스팩1
비트 : 64비트
설치 sql : ms-sql 2008 enterprise
★★★ 예외 : php iis 로 윈도우서버에서 php, mysql 설치되어있음 ★★★
지난번문제점 해결책은 serup.exe > 속성 > 호환성탭 > 자기에 맞는 환경 체크후 확인누루고 해보니 잘되네요..
이번에문제점
[권한이 없는 작업을 수행하려고 했습니다.]
좀더 자세한 내용은...
2014-10-20 15:03:07 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2014-10-20 15:03:07 Slp: Inner exceptions are being indented
2014-10-20 15:03:07 Slp:
2014-10-20 15:03:07 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2014-10-20 15:03:07 Slp: Message:
2014-10-20 15:03:07 Slp: 권한이 없는 작업을 수행하려고 했습니다.
2014-10-20 15:03:07 Slp: Data:
2014-10-20 15:03:07 Slp: WatsonData = Microsoft SQL Server
2014-10-20 15:03:07 Slp: DisableRetry = true
2014-10-20 15:03:07 Slp: Inner exception type: System.UnauthorizedAccessException
2014-10-20 15:03:07 Slp: Message:
2014-10-20 15:03:07 Slp: 권한이 없는 작업을 수행하려고 했습니다.
2014-10-20 15:03:07 Slp: Stack:
2014-10-20 15:03:07 Slp: 위치: System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
2014-10-20 15:03:07 Slp: 위치: System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
2014-10-20 15:03:07 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
2014-10-20 15:03:07 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
2014-10-20 15:03:07 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
2014-10-20 15:03:07 Slp: ----------------------------------------
2014-10-20 15:04:52 Slp: User has chosen to cancel this action
2014-10-20 15:04:52 Slp: Watson Bucket 2
Original Parameter Values
2014-10-20 15:04:52 Slp: Parameter 0 : SQL2008@RTM@
2014-10-20 15:04:52 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.Sco.ScoException@1211@1
2014-10-20 15:04:52 Slp: Parameter 4 : System.UnauthorizedAccessException@-2147024891
2014-10-20 15:04:52 Slp: Parameter 5 : SqlBrowserConfigAction_install_ConfigNonRC
2014-10-20 15:04:52 Slp: Parameter 7 : Microsoft SQL Server
2014-10-20 15:04:52 Slp: Parameter 8 : Microsoft SQL Server
2014-10-20 15:04:52 Slp:
Final Parameter Values
2014-10-20 15:04:52 Slp: Parameter 0 : SQL2008@RTM@
2014-10-20 15:04:52 Slp: Parameter 3 : 0xD3BEBD98@1211@1
2014-10-20 15:04:52 Slp: Parameter 4 : 0xBB814387
2014-10-20 15:04:52 Slp: Parameter 5 : SqlBrowserConfigAction_install_ConfigNonRC
2014-10-20 15:04:52 Slp: Parameter 7 : 0xA08E07CB
2014-10-20 15:04:52 Slp: Parameter 8 : 0xA08E07CB
2014-10-20 15:04:53 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\20141020_143931\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2014-10-20 15:04:53 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\20141020_143931\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2014-10-20 15:04:53 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141020_143931\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2014-10-20 15:04:53 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141020_143931\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
2014-10-20 15:04:53 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141020_143931\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2014-10-20 15:04:54 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141020_143931\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
2014-10-20 15:05:02 Slp: 권한이 없는 작업을 수행하려고 했습니다.
2014-10-20 15:05:02 Slp: Watson bucket for exception based failure has been created
2014-10-20 15:05:02 SQLBrowser: SQL Server Browser Install for feature 'SQL_Browser_Redist_SqlBrowser_Cpu32' failed with cancel exception: Microsoft.SqlServer.Configuration.Sco.ScoException: 권한이 없는 작업을 수행하려고 했습니다. ---> System.UnauthorizedAccessException: 권한이 없는 작업을 수행하려고 했습니다.
위치: System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
위치: System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
위치: Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
--- 내부 예외 스택 추적의 끝 ---
위치: Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.SetSecurityDescriptorByLocation(String sRegLocation, RegistryView regView, String sSddl, Boolean bOptional)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ApplyRegPermissions(XmlNodeList xmlNodeListRegPermissions, Dictionary`2 dictionaryGroups, Dictionary`2 dicLocationFragments)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ApplyRegCommonPermissions(XmlElement xmlRootPermissions, Dictionary`2 dictionaryGroups, Dictionary`2 dicLocationFragments)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ApplyPermissions(String sXmlPermissionsFile, String sBrowserPrincipal)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigStaticProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig).
2014-10-20 15:05:02 SQLBrowser: The last attempted operation: SQL Server Browser 서비스를 구성하기 위해 뷰 'Wow6432'의 레지스트리 키 'SOFTWARE\Microsoft\Microsoft SQL Server'에 액세스 제어 항목 '(A;CI;KR;;;[SQLServer2005SQLBrowserUser$EOM])'을(를) 추가합니다..
2014-10-20 15:05:02 Slp: 타이밍 ConfigNonRC 및 시나리오 ConfigNonRC 중에 기능 SQL_Browser_Redist에 대한 구성 동작이 실패했습니다.
2014-10-20 15:05:02 Slp: 권한이 없는 작업을 수행하려고 했습니다.
2014-10-20 15:05:02 Slp: 타이밍 ConfigNonRC 및 시나리오 ConfigNonRC 중에 기능 SQL_Browser_Redist에 대한 구성 동작이 실패했습니다.
2014-10-20 15:05:02 Slp: Microsoft.SqlServer.Configuration.Sco.ScoException: 권한이 없는 작업을 수행하려고 했습니다. ---> System.UnauthorizedAccessException: 권한이 없는 작업을 수행하려고 했습니다.
2014-10-20 15:05:02 Slp: 위치: System.Security.AccessControl.Win32.GetSecurityInfo(ResourceType resourceType, String name, SafeHandle handle, AccessControlSections accessControlSections, RawSecurityDescriptor& resultSd)
2014-10-20 15:05:02 Slp: 위치: System.Security.AccessControl.NativeObjectSecurity.CreateInternal(ResourceType resourceType, Boolean isContainer, String name, SafeHandle handle, AccessControlSections includeSections, Boolean createByName, ExceptionFromErrorCode exceptionFromErrorCode, Object exceptionContext)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity..ctor(ResourceType resourceType, SafeRegistryHandle handle, AccessControlSections includeSections)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistrySecurity.Create(InternalRegistryKey key)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
2014-10-20 15:05:02 Slp: --- 내부 예외 스택 추적의 끝 ---
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.Sco.SqlRegistryKey.SetSecurityDescriptor(String sddl, Boolean overwrite)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.SetSecurityDescriptorByLocation(String sRegLocation, RegistryView regView, String sSddl, Boolean bOptional)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ApplyRegPermissions(XmlNodeList xmlNodeListRegPermissions, Dictionary`2 dictionaryGroups, Dictionary`2 dicLocationFragments)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ApplyRegCommonPermissions(XmlElement xmlRootPermissions, Dictionary`2 dictionaryGroups, Dictionary`2 dicLocationFragments)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ApplyPermissions(String sXmlPermissionsFile, String sBrowserPrincipal)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigStaticProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2014-10-20 15:05:02 Slp: 위치: Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2014-10-20 15:05:02 Slp: 예외: Microsoft.SqlServer.Configuration.Sco.ScoException.
2014-10-20 15:05:02 Slp: 원본: Microsoft.SqlServer.Configuration.Sco.
2014-10-20 15:05:02 Slp: 메시지: 권한이 없는 작업을 수행하려고 했습니다..
2014-10-20 15:05:02 Slp: 내부 예외:
2014-10-20 15:05:02 Slp: 예외: System.UnauthorizedAccessException.
2014-10-20 15:05:02 Slp: 원본: mscorlib.
2014-10-20 15:05:02 Slp: 메시지: 권한이 없는 작업을 수행하려고 했습니다..
대략 이정도 되는거 같습니다..
설치도중 서비스계정은 SYSTEM으로 하였습니다.
