All geek questions in one place

Need sql 2000 server to win 7 bit 64 bit

I have a version of SQL Server 2000 dev. But it is incompatible with my new 64-bit win7 pro computer. Is there a free version of 2000 that I can install on my 64-bit development computer?

As I understand it, I can restore the 2000 database on SQL Server 2008. But I cannot restore the database on the 2000 server after making any changes in 2008.

+3
source share
3 answers

The free version of SQL Server 2000 is called "MSDE." I have not tried it, but I do not think that it works with Windows 7. If it works with Windows 7, you will need to make sure that you run the installer as an administrator and remember that it is not logged in to the account administrator to ensure that it is happened.

Otherwise, you will need to upgrade to at least sql server 2005. Both SQL Server 2005 and SQL Server 2008 have express licenses that allow you to use production if that helps. If this does not work, you will need to install SQL Server 2000 on a separate computer (even vm) and use the newer SQL Server to manage the server to connect to it.

+1
source

. Virtualbox, , . Virtualbox XP Sql Server .

+1

1

1- gpedit.msc "" "Enter".

2. \ \ Windows\ . "" " ".

3. "", "" "", .

step2

step3

step4 SQL .

Then run setup.bat

step5 please install sql 2000 sp4 when the installation is complete. NB do not run autorun.exe bc, you will get an error.

THIS WORKS Sun. THIS WORKS ON MY W7 car. Talley Raleigh, NC talleyouro@hotmail.com "Light will always dominate darkness"

+1
source

Source: https://habr.com/ru/post/1735732/

More articles:


All Articles