Error 207: Error 28092 when upgrading from Express to Workgroup Edition

Hello,

when I try to upgrade SQL Server 2005 using this command line:

setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SQLACCOUNT=NT-AUTORIT?T\SYSTEM SECURITYMODE=SQL SAPWD=XXXXXX

I get error 28092 (administrator rights needed).

It seems like the upgrade tries to use Windows authentification although I've told it to use SQL Server authentification. Or did I miss a parameter in my command line?

If I do the upgrade manually it works without needing Windows authentification.

can you goto %program files%\microsoft sql server\90\setup bootstrap\log folder, and search for the error code, and share out the log content near/around the error?|||

The file SQLSetup0008_Z1TESTVISTA_SQL.log contains:

Attempt to start service when it is already running
SQL service MSSQL$Z1 started successfully waiting for SQL service to accept client connections
Loaded DLL:
C:\Windows\system32\Odbc32.dll
Version:
6.0.6000.16386

SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Der Datenbankkontext wurde auf 'master' ge?ndert.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Die Spracheneinstellung wurde auf Deutsch ge?ndert.

Error Code: 0x80076dbc (28092)
Windows Error Text: Source File Name: sqlca\upgradesql.cpp
Compiler Timestamp: Thu Aug 11 01:12:02 2005
Function Name: sqls::UpgradeSql::validateDatabases
Source Line Number: 187

- Context --

Setting status of unmanaged components and removing unmanaged resources

Error Code: 28092
MSI (s) (38!74) [17:34:44:691]: Produkt: Microsoft SQL Server 2005 -- Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.

Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Thu Feb 01 17:34:44 2007
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
Attempt to start service when it is already running
SQL service MSSQL$Z1 started successfully waiting for SQL service to accept client connections
Loaded DLL:
C:\Windows\system32\Odbc32.dll
Version:
6.0.6000.16386

- Context --

Setting status of unmanaged components and removing unmanaged resources

Error Code: 28092
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 2504 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3304 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 2040 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3548 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3172 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3996 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3664 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 1456 could not be cancelled. Error: 1168
MSI (s) (38:FC) [17:34:46:848]: I/O on thread 3848 could not be cancelled. Error: 1168
MSI (s) (38!74) [17:34:46:863]: Produkt: Microsoft SQL Server 2005 -- Fehler 28092. Das SQL Server-Setup ben?tigt Administratorberechtigungen für die aktualisierte SQL Server-Instanz. Melden Sie sich mit einem Administratorkonto an, um den Vorgang fortzusetzen.

And the file SQLSetup0008_Z1TESTVISTA_Core(Patched).log:

Installing: sql on target: Z1TESTVISTA
Failed to install package
Schwerwiegender Fehler bei der Installation.
Setting package return code to: 28092
Complete: InstallSqlAction at: 2007/1/1 17:34:48, returned false
Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.

|||

two questions:

1) were you running a admin on the box?

2) your express was ENU (English) or not? What language SKU it is? The same quesstion for the WorkGroup Edition?

|||

1) Yes, but on Vista with UAC enabled. Vista asks for admin evelation and I allow it.

May this be the problem? Shall I try under Windows XP?

2) Both are the German versions.

Maybe this is a similar problem like in

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1084672&SiteID=1

|||

This error means that the user who is running the setup is not sysadmin in the SQL instance. It makes sense this happens on Vista because of AUC the user is not recognize as NT administrator. You need to add yourself as sysadmin to SQL. From elevated application connect to SLQ and run:

EXEC sys.sp_grantlogin N'YourAccount'

EXEC sys.sp_addsrvrolemember N'[YourAccount]', N'sysadmin'

|||

Sorry, but this doesn't answer my question:

Why does this error not occur if I do the upgrade manually?

And how do I have to change my command line above to get the same result?

|||

So; after trying the same under Windows XP and experiencing the same problems again, I compared the log files created by the working manual upgrade with the ones from the aborting automatic upgrade.

I discovered some undocumented property names, especially "UPGRADEUSER" and "UPGRADEPWD". After changing my command line to

setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=XXXXXX

the automatic upgrade works now (with one exception).

THANK YOU VERY MUCH MICROSOFT FOR YOUR INCOMPLETE DOCUMENTATIONS!!!

The remaining problem now is, that the upgrade deletes Tools_Legacy even if I add

ADDLOCAL=Tools_Legacy

to the command line above. Any idea?

|||

I've found the solution for the last problem. So my (hopefully) final command line is:

setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine ADDLOCAL=SQL_BC_DEP INSTANCENAME=Z1 SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=XXXXXX

Friday, February 24, 2012

Error 28092 when upgrading from Express to Workgroup Edition

No comments:

Post a Comment

Error 207

Blog Archive

About Me