x

Can I install SQL Server 2000 on Windows 7

I have an application that runs on SQL Server 2000. We have clients that use the Personal Edition or MSDE on their XP machines. If we upgrade to Windows 7, or get new Windows 7 clients, can we install SQL Server 2000 on them?

more ▼

asked Oct 23, 2009 at 01:03 PM in Default

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 77 79 82

(comments are locked)
10|1200 characters needed characters left

22 answers: sort oldest

I found this update from Microsoft's Release Services: http://blogs.msdn.com/sqlreleaseservices/archive/2009/10/23/sql-server-on-windows-7-and-windows-server-2008-r2.aspx

The reason given for not supporting 2000 on Vista/Win7 is because of LUA/UAC issues.

more ▼

answered Oct 26, 2009 at 11:15 PM

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 77 79 82

(comments are locked)
10|1200 characters needed characters left

SQL Server 2000 isn't supported on Vista+ OS's. The install will be blocked by Windows. Migrating MSDE to SQL Express may be the best option.

more ▼

answered Oct 23, 2009 at 02:48 PM

Brad Sarsfield gravatar image

Brad Sarsfield
21

(comments are locked)
10|1200 characters needed characters left

Hi,

Although you can install SQL Server 2000 on Windows 7 with some workarounds, it will not work properly. You can see several errors in both the database server and in Enterprise Manager MMC.

Only SQL Server 2005 SP3 or greater and SQL Server 2008 SP1 or greater are supported in Windows 7 by Microsoft.

more ▼

answered Oct 23, 2009 at 02:55 PM

Felipe Ferreira gravatar image

Felipe Ferreira
306 2

(comments are locked)
10|1200 characters needed characters left

There are several great answers here, but it is worth adding that there are ways of working around the fact you can't run it natively.

The obvious one is to use SQL Server 2005 SP3 and run the database in compatibility mode for 2000. That is certainly not the same as actually running SQL Server 2000, but it is good enough for most applications and better for a few.

Also remember that you can run an earlier version of windows as a virtual machine inside Windows 7. I have not tried that with SQL Server 2000, but I cannot think of any reason it would not work well.

more ▼

answered Dec 22, 2009 at 11:40 AM

TimothyAWiseman gravatar image

TimothyAWiseman
15.5k 20 23 32

(comments are locked)
10|1200 characters needed characters left

The real answer is this - sql requires Windows Authentication and Microsoft has decided to change this or do away with it. Not to worry though - SQL allows you to log in without windows authentication. Install the program and do not select windows authentication to log in. Use a user name and password - works great on Vista - should work the same on Win 7

more ▼

answered Jan 23, 2010 at 08:18 PM

rbeca gravatar image

rbeca
2

This answer has been clicked "down" by at least two people who haven't left a comment as to "Why". The answer rbeca gave seems plausible. Can someone say for certain if this is a good or a bad answer and why? Thanks.
Jun 20, 2010 at 09:05 PM Jeff Moden
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x473
x12

asked: Oct 23, 2009 at 01:03 PM

Seen: 94554 times

Last Updated: Feb 02, 2013 at 08:08 AM