SQL Server 20058 R2 Upgrade

  • Hi,

    I am having trouble performing an in place upgrade from SQL 2005 Enterprise (SP4) to 2008 R2 Enterprise. All goes well at first, it passes all the rule checks but during the upgrade the following error pops up during SqlBrowserConfigEngAction_upgrade_ConfigNonRC

    The specified user 'user@domain.net' does not exist

    Retry or Cancel

    Retry pops the same message, cancel leaves me with a working 2005 instance but a half installed 2008 R2 install with a lot of reg entries to clear before I can even start again. The following is from error point in Detail.txt. Oh and the user already exists in the group.

    2011-07-14 15:51:20 Slp: Sco: User user@domain.net wasn't located

    2011-07-14 15:51:20 Slp: Sco: User user@domain.net doesn't exist

    2011-07-14 15:51:20 SQLBrowser: SQL Server Browser Install for feature 'SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64' generated exception, and will invoke retry option. The exception: Microsoft.SqlServer.Configuration.Sco.ScoException: The specified user 'user@domain.net' does not exist.

    at Microsoft.SqlServer.Configuration.Sco.UserGroup.AddUser(String userName)

    at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.AddAccountToGroup(SqlBrowserPublicConfig publicConfigSqlBrowser)

    at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.UpdateAccountIfNeeded(SqlBrowserPublicConfig publicConfigSqlBrowser)

    at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigUserProperties(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-07-14 15:51:20 SQLBrowser: The last attempted operation: Adding account 'user@domain.net' to the SQL Server Browser service group 'SQLServer2005SQLBrowserUser$GBLWSQL02D'..

    2011-07-14 15:51:20 Slp: Prompting user if they want to retry this action due to the following failure:

    2011-07-14 15:51:20 Slp: ----------------------------------------

    2011-07-14 15:51:20 Slp: The following is an exception stack listing the exceptions in outermost to innermost order

    2011-07-14 15:51:20 Slp: Inner exceptions are being indented

    2011-07-14 15:51:20 Slp:

    2011-07-14 15:51:20 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException

    2011-07-14 15:51:20 Slp: Message:

    2011-07-14 15:51:20 Slp: The specified user 'user@domain.net' does not exist.

    2011-07-14 15:51:20 Slp: Data:

    2011-07-14 15:51:20 Slp: Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64

    2011-07-14 15:51:20 Slp: Timing = ConfigNonRC

    2011-07-14 15:51:20 Slp: DisableRetry = true

    2011-07-14 15:51:20 Slp: Stack:

    2011-07-14 15:51:20 Slp: at Microsoft.SqlServer.Configuration.Sco.UserGroup.AddUser(String userName)

    2011-07-14 15:51:20 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.AddAccountToGroup(SqlBrowserPublicConfig publicConfigSqlBrowser)

    2011-07-14 15:51:20 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.UpdateAccountIfNeeded(SqlBrowserPublicConfig publicConfigSqlBrowser)

    2011-07-14 15:51:20 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigUserProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)

    2011-07-14 15:51:20 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)

    2011-07-14 15:51:20 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)

    2011-07-14 15:51:20 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)

    2011-07-14 15:51:20 Slp: ----------------------------------------

    Thanks in advance.

    Chris

  • Duplicate post. No replies to this thread please. Direct replies to:http://qa.sqlservercentral.com/Forums/Topic1141896-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply