July 14, 2011 at 10:00 am
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
July 14, 2011 at 11:49 am
This is a hunch as I have not seen this error before. Check the "SQL Server Browser" service to see who the service is logging in as. If it's a specific user make sure the account exists and that the service can be started (i.e. that the password used by the service is correct).
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 18, 2011 at 9:05 am
Tried that. Never got this working, had to isntall a new instance
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply