Share via

SQL Express SP2 available on Microsoft Update

  • Article

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

  • Anonymous
    March 12, 2007
    The comment has been removed

  • Anonymous
    March 15, 2007
    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

  • Anonymous
    March 16, 2007
    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