Why SQL Server Express 2008 install requires Visual Studio 2008 in checklist?

When installing SQL Server Express Edition 2008, checklist says

“Previous version of Visual Studio 2008”

  • How can I defensively code against randomly referencing “Table 0” and null values?
  • Use “result expression” from CASE expression in WHERE clause
  • Delete records which are considered duplicates based on same value on a column and keep the newest
  • How to prevent SQL Server LocalDB auto shutdown?
  • How to import csv files
  • How to ensure the SQL is able to read all XML tag data
  • and asked me to upgrade to sp1. Unfortunately sp1 for some reason refuses to install on my brand new pc (Windows 7).

    So why can’t I just bypass this ? Why would SQL Server Express needs VS2008 to install that’s insane.

    SQL Server install used to be as easy as 123, now it has become a nightmare like installing Oracle.

    Will I have to go back to Windows XP ?

    3 Solutions collect form web for “Why SQL Server Express 2008 install requires Visual Studio 2008 in checklist?”

    Because Sql Server Management Studio is built upon the Visual Studio standalone Shell.

    You will find that if you choose not to install the SSMS this requirement will vanish, but this is probably not what you want to do.

    Normally you won’t need Visual Studio 2008 in order to install SQL Server. This can be caused by some previous versions that you had installed, beside the SSMS problem. Take a look here for required actions before installing SQL Server 2008.

    I have to agree that SQL Server 2008 install is probably the worst SQL install ever.

    Having said that, 2008 R2 is out now, perhaps the new management studio is built on VS2010? Alternatively, don’t install Management studio and use something else like VS2008, or VS2010 express to access the database.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.