Both SQL server 2005 standard edition and SQL server express edition are compatible with Microsoft Windows Vista. For installing and configuring SQL server 2005 standard edition in Windows Vista we need to install SQL server services pack 2 (SP2). Even (SP1) will not work.
Image Source: i0.wp.com/www.lemonthemovie.com/sql-server-2008-express-management-studio-installation-19.jpg
ADVERTISEMENTS:
For downloading SQL Server service pack 2 – Click here
For learning more about Microsoft SQL Server – Click here
For learning the solution for the Microsoft SQL Server, Error: 262 – Click here