SQL Express SP2 available on Microsoft Update


Just a quick not to let you know that the SP2 update for SQL Express, SQL Express with Advanced Services and SQL Express Toolkit are being published to Microsoft Update today. These are automatic updates and will apply to computers based on your Microsoft Update settings for automatic updates. (i.e. Notify, Download and Notify or Download and Install)

The updates will also be part of WSUS so that IT Administrators have control over deployment of these updates throughout an Enterprise.

When applied through Microsoft Update or WSUS, the Express SP2 updates will discover the list of installed features on an instance and update those features appropriately. Additionally, Microsoft Update will detect and update all instances of SQL Express at the same time. This is different from the UI version of the Express SP2 update which must be run seperately for each instance of SQL Express installed on your computer.

-Mike

Comments (3)

  1. smcreamer says:

    Getting error upgrading from SP1 to SP2:

    SQL Server Database ServicesConfiguring Components:

    The installed has encountered an unexpected error. The error code is 2259. Database: Table(s) update failed

    Attached is the section of the SQL setup log where the error occurs:

    MSI (s) (70!C4) [10:50:00:107]: PROPERTY CHANGE: Deleting SQLACCOUNT property. Its current value is ‘NT AUTHORITYNETWORK SERVICE’.

    <Func Name=’updateFeatureSellection’>

    Attempt to start service when it is already running

    SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections

    SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect

    sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to ‘master’.

    sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.

    <Func Name=’SqlComponentUpgrade’>

    <Func Name=’SetCAContext’>

    <EndFunc Name=’SetCAContext’ Return=’T’ GetLastError=’111′>

    <Func Name=’ProcessHeaderTable’>

    <Func Name=’ProcessScriptTable’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’ProcessScriptTable’>

    <Func Name=’GetFileTargetPath’>

    MSI (s) (70!C4) [10:50:00:417]: Note: 1: 2259 2:  3:  4:  

    <Func Name=’GetFileTargetPath’>

           Error Code: 0x8007065b (1627)

    Windows Error Text: Function failed during execution.

     Source File Name: darlibviewinstaller.cpp

    Compiler Timestamp: Wed Jun 14 16:19:22 2006

        Function Name: sqls::ViewInstaller::modify

    Source Line Number: 137

    —- Context ———————————————–

    Setting status of unmanaged components and removing unmanaged resources

    Failed to modify installer view

    1: 2259 2:  3:  4:  

    Error Code: 1627

    MSI (s) (70!C4) [10:52:33:376]: Product: Microsoft SQL Server 2005 Express Edition — Error 2259. The installer has encountered an unexpected error. The error code is 2259. Database:  Table(s) Update failed

    Error 2259. The installer has encountered an unexpected error. The error code is 2259. Database:  Table(s) Update failed

    <Func Name=’SetCAContext’>

    <EndFunc Name=’SetCAContext’ Return=’T’ GetLastError=’203′>

    Doing Action: ValidateUpgrade

    PerfTime Start: ValidateUpgrade : Mon Mar 12 10:52:33 2007

    <Func Name=’ValidateUpgrade’>

    <Func Name=’updateFeatureSellection’>

    <Func Name=’SqlComponentUpgrade’>

    <Func Name=’SetCAContext’>

    <EndFunc Name=’SetCAContext’ Return=’T’ GetLastError=’111′>

    <Func Name=’ProcessHeaderTable’>

    <Func Name=’ProcessScriptTable’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’GetFileTargetPath’>

    <Func Name=’ProcessScriptTable’>

    <Func Name=’GetFileTargetPath’>

    MSI (s) (70!C4) [10:52:33:506]: Note: 1: 2205 2:  3: _sqlSqlUpgradeInstallSequence

    MSI (s) (70!C4) [10:52:33:506]: Note: 1: 2228 2:  3: _sqlSqlUpgradeInstallSequence 4: CREATE TABLE `_sqlSqlUpgradeInstallSequence` (`Action` CHAR(255) NOT NULL, `Sequence` INT NOT NULL, `Param` CHAR(0), `Retryable` INT NOT NULL, `Fatal` INT NOT NULL PRIMARY KEY `Action`, `Sequence`)

    MSI (s) (70!C4) [10:52:33:506]: Note: 1: 2262 2: _sqlSqlUpgradeInstallSequence 3: -2147287038

    <Func Name=’GetFileTargetPath’>

    MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘310719000’. Its new value: ‘325719000’.

    MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘325719000’. Its new value: ‘325759000’.

    MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘325759000’. Its new value: ‘325769000’.

    MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘325769000’. Its new value: ‘395769000’.

    MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘395769000’. Its new value: ‘576338000’.

    MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘576338000’. Its new value: ‘591338000’.

    MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘591338000’. Its new value: ‘621338000’.

    MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is ‘621338000’. Its new value: ‘621438000’.

    Couldn’t find SQL Agent service SQLAgent$SQLEXPRESS. Skipping service stop

    Thanks for your help in advance,

    Marty

  2. rc2007 says:

    I just installed SQL Server 2005 Express with Advanced Services on a WinXP SP2 machine.  When I go to Programs, SQL Server 2005, Configuration Tools… it displays 3 submenus: SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server Surface Area Configuration. I feel I’m missing the critical elements to launch the application.  Did the missing element(s) fail to install due to not having IIS installed?

    Thanks

  3. sqlexpress says:

    For rc2007 –

    You don’t "launch" SQL Express, it’s is a Service that starts when you boot Windows, it’s always on. You connect to SQL with the programs you wish to retrieve data into such as Excel, Access and custom applications written in Visual Studio.

    You’re probably thinking of Management Studio Express, which you need to select explicitly when you install Express Advanced. If it’s not showing up in the Start menu, then you didn’t select it from the feature tree. Go back into maintence mode from Add/Remove Programs and choose to update SQL Express where you will be able to select additional features.

    This types of questions would be better asked on the Express Forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=385&SiteID=1

    – Mike