How to install SQL Server 2000 for a MU Online server

SQL Server 2000 is the database of MU Online's oldest versions. Though discontinued, it's still used on classic servers whose distributions were made for it.

When to use SQL 2000

• Classic distributions (0.97/0.99) prepared specifically for it;
• Old tutorials and files that weren't migrated;
• Study environments of MU's "golden era".

Prerequisites

• Preferably Windows XP / Server 2003 (real or in a virtual machine) for maximum compatibility;
• Administrator permission;
• The SQL Server 2000 installer + Service Pack 4 (SP4).

Step by step

1. Install SQL Server 2000 choosing the default instance;
2. In authentication mode, select Mixed Mode and set the sa password;
3. Finish the installation;
4. Apply Service Pack 4 (SP4) — essential for stability and fixes;
5. Install the Enterprise Manager / Query Analyzer (the era's tools) to manage.

Compatibility on modern Windows

On Windows 10/11, SQL 2000 may not install or may be unstable. Alternatives:

• Run in a virtual machine with Windows XP/2003;
• Use compatibility mode (results vary);
• Migrate the distribution to SQL Server 2008 R2 (recommended).

Security

Being unsupported, SQL 2000 has known vulnerabilities. Never expose its port to the internet and keep it isolated behind a firewall.

Next steps

With the database installed, go to configure SQL Server for MU Online (restore database + user) and then configure MuServer.

Perguntas frequentes