I can't find or install SP2 for the SQL Server 2005 Express edition that
installs with Visual Studio 2005 x64.

This is a fresh new install on a fresh Visa x64 machine.

During the installation process of Visual Studio 2005 x64 I was informed of
a compatability issue of the SQL Server 2005 Express edition being installed
with the package on Vista and that I needed to install Service Pack 2.
I cannot find which update to use for SP2? I followed the links provided and
did some searches of my own, but every link takes me to either to an update
that fails or to a full installation exe. Help!!!!!

Here are the pages I found and links to them:
---------------------------------------
This one fails:

Page title: Microsoft SQL Server 2005 Service Pack 2
Link:
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

Available downloads:
SQLServer2005SP2-KB921896-IA64-ENU.exe - 392.4 MB
SQLServer2005SP2-KB921896-x64-ENU.exe - 339.4 MB <<< I thought it was this
one.
SQLServer2005SP2-KB921896-x86-ENU.exe - 282.4 MB
---------------------------------------
This is a full install

Page title: Microsoft SQL Server 2005 Express Edition Service Pack 2
Link:
http://www.microsoft.com/downloads/details.aspx?familyid=31711D5D-725C-4AFA-9D65-E4465CDFF1E7&displaylang=en

Available downloads:
SQLEXPR.EXE - 55.4 MB <<<< I thought it was this one.
SQLEXPR32.EXE - 36.5 MB
---------------------------------------
This too is a full install

Page title: Microsoft SQL Server Management Studio Express Service Pack 2
Link:
http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

Available downloads:
SQLServer2005_SSMSEE.msi - 43.1 MB
SQLServer2005_SSMSEE_x64.msi - 43.6 MB <<< I thought it was this one.
---------------------------------------

Where do I go to get the SP2 to update the SQL Server 2005 Express edition
that is installs with Visual Studio 2005 Professional?!?!?!?

Hi dbuchanan,

From your description, you've installed VS 2005 and SQL express 2005 on a
Vista X64 box, however, after that you found that you can not find the
proper SP2 update for the SQL Express to install , correct?

Based on my understanding, for SQL Server Express edition, the SP2 update
package should contains all the update for different versions(Deverloper,
Enterpse... 32bit , 64bit .....). You can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=d07219b2-1e23-49c8-
8f0c-63fa18f26d3a&displaylang=en

also, if you've installed Microsoft Update, you should be able to detect
the SQL server sp2 for SQL Express in Microsoft Update scan.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.

Thank you

[quoted text, click to view]