SQL 2005 express with Vista 64 Guide

[mazz]

Vista 64 bit sql express install guide

go to control panel add remove turn off windows features link
tick
IIS (Internet Information Services)
[What to tick Folder
Static Content Common HTTP Features
Default Document Common HTTP Features
HTTP Redirection Common HTTP Features
Directory Browsing Common HTTP Features
ASP.Net Application Development
ISAPI Extension Application Development
ISAPI Filters Application Development
Windows Authentication Security
IIS Metabase Management Tools
IIS 6 WMI Management Tools
hit ok let windows update your system

go to start then programs then acessories find command-line prompt, right click on it and run as admin is using the UAC, press OK, then paste the following:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
This allows us to run 32 bit apps on a 64 bit os

Install sqlexpress
http://www.microsoft.com/downloads/details.aspx?FamilyId=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en#filelist
File name SQLEXPR.exe
Should be no errors when installed
install service p2
http://www.microsoft.com/downloads/...9c8-8f0c-63fa18f26d3a&DisplayLang=en#filelist
file name SQLServer2005SP2-KB921896-x86-ENU
install service p3
http://www.microsoft.com/downloads/...faa-8ae5-949fdfbe59c4&displaylang=en#filelist
File name
SQLServer2005SP3-KB955706-x64-ENU.exe

Download sql management tools
http://www.microsoft.com/downloads/...79C-B25B-9ACA13141C9E&displaylang=en#filelist
File name
SQLServer2005_SSMSEE_x64.msi

open start all programs accesories (right click command prompt run as admin)
find the sql management studio and run it

Now go to this link step 3 and do the rest
http://www.lomcn.co.uk/forum/showthread.php?t=59803&highlight=vista