question

Steve Jones - Editor avatar image
Steve Jones - Editor asked

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?

sql-server-2000windows7
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steve Jones - Editor avatar image
Steve Jones - Editor answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Brad Sarsfield avatar image
Brad Sarsfield answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Felipe Ferreira avatar image
Felipe Ferreira answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image
TimothyAWiseman answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rbeca avatar image
rbeca answered

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

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Umesh avatar image
Umesh answered

I have the same problem...........but now i'll try to use Server 2005 with compatibility mode................U

2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks bolna to bhul hi gaya tha.............Thanks yar
0 Likes 0 ·
or ha mera mail id he : umesh8all@gmail.com Pl. kuch or point milta he jisse SQL 2000 SERVER windows 7 me dal jae to batana.................U
0 Likes 0 ·
Shaibal Nayak avatar image
Shaibal Nayak answered

I think SQL doesnot work in windows 7, Because windows 7 is a 64 bit os and SQL 2000 is 32 bit softwer.

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Windows 7 is available in x86 (32-bit) http://en.wikipedia.org/wiki/Windows_7
1 Like 1 ·
dip avatar image
dip answered

hi sir ,

i haeve an comercial application having database connectivity with sql server 2000 now i have installed sql server 2005 for windows 7.but i could not succeed . when i did.

sql server does not connect .

how should i go through out ?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

mmmm avatar image
mmmm answered

I could successfully install evaluation edition of SQL server 2000 on Windows 7 and it works properly.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

salinda avatar image
salinda answered

sql sever 2000 is not working in windos 7 how can i fix it ?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.