Sep 252009
 

Installing SQL Server 2000 in Windows 7 is pretty much the same as installing in any version of Windows. I provide the guide here just for clarity and to help newbie.
As you have seen in my previous post at Running SQL Server 2000 in Windows 7, I have successfully installed and run SQL Server 2000 in Windows 7 RTM.
Sudarpo.Net - SQL Server 2000 Windows 7

SQL Server 2000 Installation Guide.

Step 1 – You are likely to see Program Compatibility Assistant when you run the setup. Ignore it, just Run the program.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 2 – Welcome to the classic installation wizard.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 3 – Select where to install the server. Local / Remote ?

Sudarpo.Net - SQL Server 2000 Windows 7

In some cases, you probably get the following error message after selecting LOCAL COMPUTER.

—————————
Error
—————————
A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.
—————————
OK
—————————

as shown in this screen.
Sudarpo.Net - SQL Server 2000 Windows 7

This is a known issue with SQL Server 2000 installation and Microsoft Support has the solution. It will tell you to modify registry setting. You can backup and delete PendingFileRenameOperations as mentioned. If you don’t feel safe, just rename to “xxPendingFileRenameOperations” or anything you like. It will do the trick.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 4 – Select Create new instance.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 5 – Select Server and Client Tools.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 6 – Use default instance name or rename it as you see fit. I would recommend you to rename the instance if you are going to install another version of SQL Server.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 7 – Select TYPICAL, MINIMUM, or CUSTOM. If you wish to change the installation folder, you can do it here.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 8 – use Local System account for highest security privilege level.

Sudarpo.Net - SQL Server 2000 Windows 7

Step 9 – Select MIXED MODE (recommended). This enables SQL Server Authentication mode. Enter password for default sa login.

Sudarpo.Net - SQL Server 2000 Windows 7

Wait..wait…wait…done.

Sudarpo.Net - SQL Server 2000 Windows 7

After installation is complete, you can apply SQL Server 2000 Service Pack 4 as well. Ignore the Program Compatibility Assistant again and run the update.

Sudarpo.Net - SQL Server 2000 Windows 7

Wait till wizard appears.

Sudarpo.Net - SQL Server 2000 Windows 7

Select your SQL Server 2000 instance name.

Sudarpo.Net - SQL Server 2000 Windows 7

Upgrade it! and wait till it completes.

Sudarpo.Net - SQL Server 2000 Windows 7

Have fun with your SQL Server 2000.


Notes:
The only issue that I have right now is I can’t apply the latest security patch for SQL Server 2000 such as:

  • KB899761-v8.00.2040
  • KB948110-v8.00.2050
  • KB960082-v8.00.2055
  • KB948111-8.00.2273
  • KB960083-v8.00.2282

I keep getting Not enough storage error or just a dumb error “installation did not complete“. It’s really not recommended to run SQL Server 2000 in your production server without these updates.

Error 1:

—————————
Setup Error
—————————
Not enough storage is available to process this command.

—————————
OK
—————————

Error 2:
After applying compatibility mode to Windows XP SP2 or SP3.

—————————
KB899761(ENU) Setup Error
—————————
KB899761(ENU) installation did not complete.
—————————
OK
—————————

  • http://pulse.yahoo.com/_D3GCKR5HOGGGPBVH36IDPD5PSM Randolf

    Hey, for some reason. i wasn’t able to succesfully install SP4 in my first attempt. O.o not sure why, but it works following your instruction. thanks!

    • Stanislav

      When working with Enterprise Manager, there is this message:

      Problem Event Name: APPCRASH
      Application Name: mmc.exe
      Application Version: 6.1.7127.0
      Application Timestamp: 4a03bd54
      The name of the module with the error: msdt70.dll
      Version of the module with the error: 7.0.8948.0
      The time stamp module with the error: 398cc3c2
      Exception Code: c0000005
      Exception Offset: 0008fc04
      OS Version: 6.1.7127.2.0.0.256.1
      Language Code: 1059
      Additional Information 1: 0a9e
      Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
      Additional Information 3: 0a9e
      Additional Information 4: 0a9e372d3b4ad19135b953a78882e789

      • nah

        this server can make online

  • Anthony

    OK, but what about getting the database diagrams to save? I get this error: “Internal error, not fully constructed” when adding tables to a diagram and then saving that diagram… Any ideas?

  • JohnC

    cant you use windows xp mode (virtual xp in windows 7) and install sql server 2000 into this ?, un-tested, but maybe worth a try ?

  • Anthony

    I found out that if you click the Save icon, the Diagram saves. Beware that its going to ask you if you want to save, again, when you X out that window that the diagram is in. You decline to save at that point and you do not get an error. Going back into the diagram will show the changes you made when clicking on the Save icon… That is the workaround I found…

  • Myacc123

    Nice to have this article. However, I can’t proceed my installation anymore and it’s failed after filling the MIXED MODE password.

    Below is the error and kindly advice on how to complete the full installation.
    Problem signature:
    Problem Event Name: APPCRASH
    Application Name: _INS5576._MP
    Application Version: 5.53.168.0
    Application Timestamp: 36d2e6b6
    Fault Module Name: sqlsui.dll
    Fault Module Version: 2000.80.194.0
    Fault Module Timestamp: 398d26d8
    Exception Code: c0000005
    Exception Offset: 000280fd
    OS Version: 6.1.7600.2.0.0.256.48
    Locale ID: 18441
    Additional Information 1: 83be
    Additional Information 2: 83be62c0dff2ef9eb8b12ea8513e7572
    Additional Information 3: d29d
    Additional Information 4: d29dcda7dbf18baa78081f19d33e7168

    • ET LINISH

      DID U GET THE SOLUTION????

  • Ramesh

    I am not able o install sql server 2000 in Windows 7 Home Premium. after entering sa user password and click next, it it giving the error ‘InstallSheild Engine stopped working’. May I know the compatabiliy of sql server 2000 in Windows 7 Home premium. Please help me in this regard. It is very urgent somehow I have to get it installed on my machine.

    • Samba_india2006

      how to solutation

    • Keong

       Hi, any solution regarding this issue? Im getting same error message as well.

  • Ramesg

    Where can I get this SQL 2000 copy to download and install

  • vinu

    how can i get the 2nd step?

  • Cvinucse

    can u pls send the url of the site where i get the sql 2000

  • Muhammad Ishfaq

    Dear I am unalbe to add SQL 2000 as data source in VB 2010 . Kindly guide me about it . SQL server is working fine with some other apllications.
    The issu is that i can’t locate SQL 2000 in new connection box of VB 2010.It is not there.

  • Bousshabib

    please where  can i found the step 2

  • Nidhi Sharma0703

    Hey thanks fo support but still unable to follow step 2 and hence Server and Client Tools option is disabled in step 5.. Please suggest!!
    Thanks in advance.

    • Doccocaubai11487

      I can not do the way you guide, you can say it was not more specific. thanhks!

    • Doccocaubai11487

      I can not do the way you guide, you can say it was not more specific. thanhks!

  • Rajroashan

    i successfully installed the sql 2000 but now getting the problem ” unable to connect to server “server name” plz send me the solution on “[email protected]

  • Sameerkanade007

    Thanx a lot.. Helped Me lot..

    • Venkatkanna

      Thanx a lot.. :)

  • Maher-job1986

    thanks a lot ……………………..

  • sumon

    i have installed SQL Server 2000 in Win-7 without any problem. But when i open Enterprise Manager and try to create a table(under a database) i get the attached error message. Several time i have install uninstall SQL server 2000 and Win-7. Still no hope.

    • Saafinkhan

       hey i need urgent help i have a database created in sql server 2000 and visual studio 2005 now i want to open that application with database in visual studio 2008 help me i want download link of sql server 2000 plzzz its urgent..

    • Farooq10000

       how install plz tell

    • sulyono

      yes right… if u want create the table… use query analizer for create it. and use syntax create table …. if the table created… u can modification from the table. right click and chose design table

  • Keren

    Thanks a lot…….

  • Kauan

    ah n comsigo –’

  • Patelsandip07

    hi can you please tell me from where i can download the sql server 2000 i have download it from microsoft site but i am unable to install it in windows 7 as i think that i m not getting proper edition of sql server 2000 for windows 7

  • Hilton_1203

    pa link naman kong pano madownload

  • A Nanda Unse

    Hi… Win7 is not compatible with SQL Server 2000 but Xp is compatible with SQL Server 2000… if ur PC cannot be installed Win XP… u can install virtual machine (virtual box) for installing ur Xp, after that u can install SQL server on ur XP…
    Tks,

  • cbarrettma

    Did you ever getthe memoryissue fixed with cumulative update installation? Thanks!

  • Mr.DOCTERINESALEMONDERORORORO

    Can you Help me ?
    im install this but in #setup2
    im fail because the run time is bla bla bla…
    can you help Me ???

  • Ardhieanto

    i successfully installed the sql 2000 but now getting the problem ”
    unable to connect to server “server name” plz send me the solution on “[email protected]”..thx

  • suresh

    I am not able o install sql server 2000 in Windows 7 Home Premium. after
    entering sa user password and click next, it it giving the error
    ‘InstallSheild Engine stopped working’. May I know the compatabiliy of
    sql server 2000 in Windows 7 Home premium. Please help me in this
    regard. It is very urgent somehow I have to get it installed on my
    machine.

  • Ranga

    I am not able o install sql server 2000 in Windows 7 32 bit ultimate. after entering sa user password and click next, it it giving the error ‘InstallSheild Engine stopped working’. May I know the compatabiliy of sql server 2000 in Windows 7 32bit Ultimate.

  • shaniz

    dude plz get me link for sql server 2000 please

  • Guest

    Error…!!!