Sql Server 2005 enterprise on Windows 7

Question

Is there any possibility to install Sql Server 2005 enterprise on Windows 7?

thank you

Answer 1

Enterprise edition does work only on Server OSs (Server 2k3 2k8 ...) if you are just using it for development try Sql server developer edition it has the same features as Enterprise and it is way cheaper (But it can be used for development only).

Answer 2

SQL Server 2005 Enterprise Edition is not supported on client OS's like Vista, XP, or Windows 7. Developer Edition is supported on the client OS's and allow you to develop with Enterprise features, but Enterprise Edition is only supported on Window Server Installations as per the BOL:

http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx

Answer 3

Yep, works fine.

Make sure that you install it before Visual Studio, and also make sure you enable these Windows features first:

Common HTTP Features

• Static Content
• Default Document
• HTTP Redirection
• Directory Browsing

Application Development

• ASP.Net
• ISAPI Extension
• ISAPI Filters

Security

• Windows Authentication

IIS6

• IIS 6 WMI
• IIS Metabase

Then install SP2 at least, but preferably SP3

Answer 4

Yes it is possible:

1. http://blogs.msdn.com/sqlexpress/archive/2009/05/14/installing-sql-server-express-on-windows-7-release-candidate.aspx
2. http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/6a569376-4207-4184-a8a7-73d5168c787e

You'll need to use Service Pack 3