May 9, 2011 at 7:25 am
I'm trying to upgrade our SQL 2005 std to 2008 r2 std. The install gets 3/4
the way done, then throws errors. OS is windows 2008 ddatacenter All sql
upgrade checks came back ok before I started.
- Error in log states it the following:
Sco.UserGroup.RemoveUser - Attempting to remove user xx\svcsqlserver from
user group SQLServer2005SQLBrowserUser$XXXXXXX
2011-05-07 01:22:11 Slp: Prompting user if they want to retry this action due to the following failure:
- I can go into the SQLServer2005SQLBrowserUser group and remove this user
from the gui.
- I do see the username along with the SID in the security group.
- Can I add manually add the user to the group and attempt upgrade again?
Not sure what I need to do. Please help.
x
Here is the section of the Details log that I think the error occurs.
2011-05-07 01:22:11 Slp: Sco.UserGroup.RemoveUser - Attempting to remove user
XX\svcsqlserver from user group SQLServer2005SQLBrowserUser$XXXXXXXX
2011-05-07 01:22:11 Slp: Prompting user if they want to retry this action due
to the following failure:
2011-05-07 01:22:11 Slp: ----------------------------------------
2011-05-07 01:22:11 Slp: The following is an exception stack listing the
exceptions in outermost to innermost order
2011-05-07 01:22:11 Slp: Inner exceptions are being indented
2011-05-07 01:22:11 Slp:
2011-05-07 01:22:11 Slp: Exception type: Microsoft.SqlServer.Configuration.
Sco.ScoException
2011-05-07 01:22:11 Slp: Message:
2011-05-07 01:22:11 Slp: Exception has been thrown by the target of
an invocation.
2011-05-07 01:22:11 Slp: Data:
2011-05-07 01:22:11 Slp: WatsonData = SQLServer2005SQLBrowserUser
$XXXXXX@XX\svcsqlserver
2011-05-07 01:22:11 Slp: DisableRetry = true
2011-05-07 01:22:11 Slp: Inner exception type: System.Reflection.
TargetInvocationException
2011-05-07 01:22:11 Slp: Message:
2011-05-07 01:22:11 Slp: Exception has been thrown by the
target of an invocation.
2011-05-07 01:22:11 Slp: Stack:
2011-05-07 01:22:11 Slp: at System.DirectoryServices.
DirectoryEntry.Invoke(String methodName, Object[] args)
2011-05-07 01:22:11 Slp: at Microsoft.SqlServer.Configuration.
Sco.UserGroup.RemoveUser(String userName)
2011-05-07 01:22:11 Slp: Inner exception type: System.Runtime.
InteropServices.COMException
2011-05-07 01:22:11 Slp: Message:
2011-05-07 01:22:11 Slp: The specified account name
is not a member of the group. (Exception from HRESULT: 0x80070561)
2011-05-07 01:22:11 Slp: ----------------------------------------
2011-05-07 01:22:11 Slp: User has chosen to retry this action
2011-05-07 01:22:11 Slp: Sco: Attempting to check if user group
SQLServer2005SQLBrowserUser$XXXXXXX exists
2011-05-07 01:22:11 Slp: Sco: Root DirectoryEntry object already open
2011-05-07 01:22:11 Slp: Sco: User group existence already verified -
returning true for SQLServer2005SQLBrowserUser$XXXXXXXX
2011-05-07 01:22:11 Slp: Sco: Attempting to get account sid for user account
XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get sid for user account XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco: GetSidForAccount normalized accountName XX\
svcsqlserver parameter to XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get account sid for user account
XX
2011-05-07 01:22:11 Slp: Sco: Attempting to get sid for user account XX
2011-05-07 01:22:11 Slp: Sco: GetSidForAccount normalized accountName XX
parameter to XX
2011-05-07 01:22:11 Slp: Sco: Attempting to see if user XX\svcsqlserver
exists
2011-05-07 01:22:11 Slp: Sco.User.OpenRoot - Attempting to get root
DirectoryEntry for domain/computer 'XX'
2011-05-07 01:22:11 Slp: Sco: Attempting to check if user account XX\
svcsqlserver exists
2011-05-07 01:22:11 Slp: Sco: Attempting to look up AD entry for user XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco.User.OpenRoot - root DirectoryEntry object
already opened for this computer for this object
2011-05-07 01:22:11 Slp: Sco.User.LookupADEntry - Attempting to find user
account XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to check if container 'WinNT://XX'
of user account exists
2011-05-07 01:22:11 Slp: Sco: User XX\svcsqlserver located
2011-05-07 01:22:11 Slp: Sco: Attempting to get account sid for user account
XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get sid for user account XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco: GetSidForAccount normalized accountName XX\
svcsqlserver parameter to XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get account from sid S-1-5-21-
4004271333-2192104475-1410482986-1245
2011-05-07 01:22:11 Slp: Sco: Check success - user XX\svcsqlserver exists
2011-05-07 01:22:11 Slp: Sco: Attempting to determine if user is a member of
user group SQLServer2005SQLBrowserUser$XXXXXX, user name XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to check if user group
SQLServer2005SQLBrowserUser$XXXXX exists
2011-05-07 01:22:11 Slp: Sco: Root DirectoryEntry object already open
2011-05-07 01:22:11 Slp: Sco: User group existence already verified -
returning true for SQLServer2005SQLBrowserUser$XXXXXXX
2011-05-07 01:22:11 Slp: Sco: Attempting to get account sid for user account
XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get sid for user account XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco: GetSidForAccount normalized accountName XX\
svcsqlserver parameter to XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get account sid for user account
XX
2011-05-07 01:22:11 Slp: Sco: Attempting to get sid for user account XX
2011-05-07 01:22:11 Slp: Sco: GetSidForAccount normalized accountName XX
parameter to XX
2011-05-07 01:22:11 Slp: Sco: Attempting to see if user XX\svcsqlserver
exists
2011-05-07 01:22:11 Slp: Sco.User.OpenRoot - Attempting to get root
DirectoryEntry for domain/computer 'XX'
2011-05-07 01:22:11 Slp: Sco: Attempting to check if user account XX\
svcsqlserver exists
2011-05-07 01:22:11 Slp: Sco: Attempting to look up AD entry for user XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco.User.OpenRoot - root DirectoryEntry object
already opened for this computer for this object
2011-05-07 01:22:11 Slp: Sco.User.LookupADEntry - Attempting to find user
account XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to check if container 'WinNT://XX of
user account exists
2011-05-07 01:22:11 Slp: Sco: User XX\svcsqlserver located
2011-05-07 01:22:11 Slp: Sco: Attempting to get account sid for user account
XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get sid for user account XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco: GetSidForAccount normalized accountName XX\
svcsqlserver parameter to XX\svcsqlserver
2011-05-07 01:22:11 Slp: Sco: Attempting to get account from sid S-1-5-21-
4004271333-2192104475-1410482986-1245
2011-05-07 01:22:11 Slp: Sco: Check success - user XX\svcsqlserver exists
2011-05-07 01:22:11 Slp: Sco: Attempting to look up AD entry for user XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco: User XX\svcsqlserver was already located
2011-05-07 01:22:11 Slp: Sco: User XX\svcsqlserver is already a member
2011-05-07 01:22:11 Slp: Sco: Attempting to look up AD entry for user XX\
svcsqlserver
2011-05-07 01:22:11 Slp: Sco: User XX\svcsqlserver was already located
2011-05-07 01:22:11 Slp: Sco.UserGroup.RemoveUser - Attempting to remove user
XX\svcsqlserver from user group SQLServer2005SQLBrowserUser$XXXXXXX
2011-05-07 01:22:11 Slp: Prompting user if they want to retry this action due
to the following failure:
2011-05-07 01:22:11 Slp: ----------------------------------------
2011-05-07 01:22:11 Slp: The following is an exception stack listing the
exceptions in outermost to innermost order
2011-05-07 01:22:11 Slp: Inner exceptions are being indented
2011-05-07 01:22:11 Slp:
2011-05-07 01:22:11 Slp: Exception type: Microsoft.SqlServer.Configuration.
Sco.ScoException
2011-05-07 01:22:11 Slp: Message:
2011-05-07 01:22:11 Slp: Exception has been thrown by the target of
an invocation.
2011-05-07 01:22:11 Slp: Data:
2011-05-07 01:22:11 Slp: WatsonData = SQLServer2005SQLBrowserUser
$XXXXXX@XX\svcsqlserver
2011-05-07 01:22:11 Slp: DisableRetry = true
2011-05-07 01:22:11 Slp: Inner exception type: System.Reflection.
TargetInvocationException
2011-05-07 01:22:11 Slp: Message:
2011-05-07 01:22:11 Slp: Exception has been thrown by the
target of an invocation.
2011-05-07 01:22:11 Slp: Stack:
2011-05-07 01:22:11 Slp: at System.DirectoryServices.
DirectoryEntry.Invoke(String methodName, Object[] args)
2011-05-07 01:22:11 Slp: at Microsoft.SqlServer.Configuration.
Sco.UserGroup.RemoveUser(String userName)
2011-05-07 01:22:11 Slp: Inner exception type: System.Runtime.
InteropServices.COMException
2011-05-07 01:22:11 Slp: Message:
2011-05-07 01:22:11 Slp: The specified account name
is not a member of the group. (Exception from HRESULT: 0x80070561)
2011-05-07 01:22:11 Slp: ----------------------------------------
2011-05-07 01:23:24 Slp: User has chosen to cancel this action
2011-05-07 01:23:24 Slp: Watson Bucket 9
Original Parameter Values
2011-05-07 01:23:24 Slp: Parameter 0 : SQL Server 2008 R2@RTM@
2011-05-07 01:23:24 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.Sco.
ScoException@1211@1
2011-05-07 01:23:24 Slp: Parameter 4 : System.Runtime.InteropServices.
COMException@-2147023519
2011-05-07 01:23:24 Slp: Parameter 5 :
SqlBrowserConfigAction_install_ConfigNonRC
2011-05-07 01:23:24 Slp: Parameter 7 : SQLServer2005SQLBrowserUser
$XXXXXXXX@XX\svcsqlserver
2011-05-07 01:23:24 Slp: Parameter 8 : SQLServer2005SQLBrowserUser
$XXXXXXXX@XX\svcsqlserver
2011-05-07 01:23:24 Slp:
Final Parameter Values
2011-05-07 01:23:24 Slp: Parameter 0 : SQL Server 2008 R2@RTM@
2011-05-07 01:23:24 Slp: Parameter 3 : 0xD3BEBD98@1211@1
2011-05-07 01:23:24 Slp: Parameter 4 : 0x02C5AE69
2011-05-07 01:23:24 Slp: Parameter 5 :
SqlBrowserConfigAction_install_ConfigNonRC
2011-05-07 01:23:24 Slp: Parameter 7 : 0x82A20C50
2011-05-07 01:23:24 Slp: Parameter 8 : 0x82A20C50
2011-05-07 01:23:28 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\20110507_001736\Registry_SOFTWARE_Microsoft_Microsoft
SQL Server.reg_
2011-05-07 01:23:28 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\20110507_001736\
Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2011-05-07 01:23:28 Slp: Sco: Attempting to write hklm registry key SOFTWARE\
Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup
Bootstrap\Log\20110507_001736\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2011-05-07 01:23:28 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\20110507_001736\
Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
2011-05-07 01:23:28 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\20110507_001736\
Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2011-05-07 01:23:29 Slp: Sco: Attempting to write hklm registry key SOFTWARE\
Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20110507_001736\
Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
2011-05-07 01:23:45 Slp: Exception has been thrown by the target of an
invocation.
2011-05-07 01:23:45 Slp: Watson bucket for exception based failure has been
created
2011-05-07 01:23:45 SQLBrowser: SQL Server Browser Install for feature
'SQL_Browser_Redist_SqlBrowser_Cpu32' failed with cancel exception: Microsoft.
SqlServer.Configuration.Sco.ScoException: Exception has been thrown by the
target of an invocation. ---> System.Reflection.TargetInvocationException:
Exception has been thrown by the target of an invocation. ---> System.Runtime.
InteropServices.COMException (0x80070561): The specified account name is not
a member of the group. (Exception from HRESULT: 0x80070561)
--- End of inner exception stack trace ---
at System.DirectoryServices.DirectoryEntry.Invoke(String methodName,
Object[] args)
at Microsoft.SqlServer.Configuration.Sco.UserGroup.RemoveUser(String
userName)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Configuration.Sco.UserGroup.RemoveUser(String
userName)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.
RemoveAccountFromGroup(String sAccountName)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.
ConfigStaticProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.
ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.
SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData,
PublicConfigurationBase spcbPublicConfig)
at Microsoft.SqlServer.Configuration.SqlBrowser.
SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing,
Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig).
2011-05-07 01:23:45 SQLBrowser: The last attempted operation: Removing
account 'XX\svcsqlserver' from SQL Server Browser service group
'SQLServer2005SQLBrowserUser$XXXXXXX'..
2011-05-07 01:23:45 Slp: Configuration action failed for feature
SQL_Browser_Redist during timing ConfigNonRC and scenario ConfigNonRC.
2011-05-07 01:23:45 Slp: Exception has been thrown by the target of an
invocation.
2011-05-07 01:23:45 Slp: The configuration failure category of current
exception is ConfigurationFailure
2011-05-07 01:23:45 Slp: Configuration action failed for feature
SQL_Browser_Redist during timing ConfigNonRC and scenario ConfigNonRC.
2011-05-07 01:23:45 Slp: Microsoft.SqlServer.Configuration.Sco.ScoException:
Exception has been thrown by the target of an invocation. ---> System.
Reflection.TargetInvocationException: Exception has been thrown by the target
of an invocation. ---> System.Runtime.InteropServices.COMException
(0x80070561): The specified account name is not a member of the group.
(Exception from HRESULT: 0x80070561)
2011-05-07 01:23:45 Slp: --- End of inner exception stack trace ---
2011-05-07 01:23:45 Slp: at System.DirectoryServices.DirectoryEntry.Invoke
(String methodName, Object[] args)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.Sco.
UserGroup.RemoveUser(String userName)
2011-05-07 01:23:45 Slp: --- End of inner exception stack trace ---
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.Sco.
UserGroup.RemoveUser(String userName)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.
SqlBrowserPrivateConfig.RemoveAccountFromGroup(String sAccountName)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.
SqlBrowserPrivateConfig.ConfigStaticProperties(SqlBrowserPublicConfig
publicConfigSqlBrowser)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.
SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig
publicConfigSqlBrowser)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.
SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing,
Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.
SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing,
Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.
SqlBrowserPrivateConfig.Install(ConfigActionTiming timing, Dictionary`2
actionData, PublicConfigurationBase spcbPublicConfig)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.
SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2011-05-07 01:23:45 Slp: at Microsoft.SqlServer.Configuration.
SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2011-05-07 01:23:45 Slp: Exception: Microsoft.SqlServer.Configuration.Sco.
ScoException.
2011-05-07 01:23:45 Slp: Source: Microsoft.SqlServer.Configuration.Sco.
2011-05-07 01:23:45 Slp: Message: Exception has been thrown by the target of
an invocation..
2011-05-07 01:23:45 Slp: Inner exception:
2011-05-07 01:23:45 Slp: Exception: System.Reflection.
TargetInvocationException.
2011-05-07 01:23:45 Slp: Source: System.DirectoryServices.
2011-05-07 01:23:45 Slp: Message: Exception has been thrown by the target of
an invocation..
2011-05-07 01:23:45 Slp: Inner exception:
2011-05-07 01:23:45 Slp: Exception: System.Runtime.InteropServices.
COMException.
2011-05-07 01:23:45 Slp: Message: The specified account name is not a
member of the group. (Exception from HRESULT: 0x80070561).
2011-05-07 01:23:45 Slp: Error: Action
"SqlBrowserConfigAction_install_ConfigNonRC_Cpu32" failed during execution.
2011-05-07 01:23:45 Slp: Completed Action:
SqlBrowserConfigAction_install_ConfigNonRC_Cpu32, returned False
2011-05-07 01:23:46 Slp: Sco: Attempting to get feature configuration state
for feature SQL_Browser_Redist, version
2011-05-07 01:23:46 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_Browser_Redist from machine name XXXXXXX
2011-05-07 01:23:46 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine XXXXXXXX
2011-05-07 01:23:46 Slp: Sco: Attempting to open registry subkey
2011-05-07 01:23:46 Slp: Sco: Attempting to open registry subkey SOFTWARE\
Microsoft\Microsoft SQL Server\100\ConfigurationState
2011-05-07 01:23:46 Slp: Sco: Attempting to get registry value
SQL_Browser_Redist
2011-05-07 01:23:46 Slp: Sco: Attempting to get feature configuration state
for feature SQL_Browser_Redist, version
2011-05-07 01:23:46 Slp: Sco: Attempting to get feature flag
ConfigurationState for feature SQL_Browser_Redist from machine name XXXXXXXX
2011-05-07 01:23:46 Slp: Sco: Attempting to create base registry key
HKEY_LOCAL_MACHINE, machine XXXXXXXX
2011-05-07 01:23:46 Slp: Sco: Attempting to open registry subkey
2011-05-07 01:23:46 Slp: Sco: Attempting to open registry subkey SOFTWARE\
Microsoft\Microsoft SQL Server\100\ConfigurationState
May 16, 2011 at 9:17 pm
I've been battling the same thing. It happens to me on a fresh install on a Win 7 32 bit machine.
I can't find anything that works. You'd think it be permissions but I have gone through all permissions.
May 16, 2011 at 9:54 pm
How are you upgrading? Could you please share the syntax? do u have all admin rights ?
Upgrading SQL Server will throws lots of issue, We followed the simple method of installing SQL Server 2008 R2 on a separate Machine and restored SQL 2005 backups.
"More Green More Oxygen !! Plant a tree today"
May 17, 2011 at 1:19 am
An inplace upgrade is never a good idea as it does not give you an easy rollback option. A new install or side by side install followed by db upgrades are much safer.
What is your Os details ?
The account you were running the upgrade under what permissions does it have ? Member of Dom admins ?
What permissions does the SQL server service account have ?
Do you have system and user db backups from prior to the upgrade started ?
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
May 17, 2011 at 8:34 pm
I found the problem to the issue. It was with the Domain SQL Account that was running the services. We migrated the user from a previous domain and didn't clear SID history afterwards. There was reference to the old SID in the Upgrade logs. We deleted SID history and everything ran fine this time. Yes, there is no roll back with a botched SQL Upgrade. Don't know what I would do without NetApp snapshots and FlexClones. Reset and Retry. Thanks for the Help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply