Tutorial
Intermediate Server
How to install SQL Server 2008 (R2) for MU Online
Step-by-step to install SQL Server 2008 R2 — the classic version most used on MU Online servers — in mixed authentication mode.
SQL Server 2008 R2 is the classic database most used on MU Online servers (especially classic and Season 6). See how to install it correctly.
Nota: After installing, see how to configure SQL Server for MU Online to restore the database and create the application user.
Prerequisites
- Windows (preferably Server, but works on desktop for testing);
- Updated .NET Framework and Windows Installer;
- Disk space and administrator permission.
Step by step
- Run the SQL Server 2008 R2 installer as administrator;
- In Installation, choose New installation;
- Select the features: Database Engine and management tools;
- In Instance Configuration, use the default instance (or name one);
- In Database Engine Configuration, choose Mixed Mode (Windows + SQL authentication);
- Set a strong password for the
sauser; - Finish the installation and install SSMS (Management Studio).
Atenção: Mixed Mode is mandatory for MuServer to connect. If you forget, you can change it later in the server properties, but it's easier to mark it during installation.
Post-installation
- Open SSMS and connect with
sa; - Enable the TCP/IP protocol in SQL Server Configuration Manager;
- Ensure the SQL Server Browser service is active (if using a named instance).
Dica: MuServer connection errors are almost always: stopped service, disabled TCP/IP, or Mixed Mode off. Check those three first.
Next step
With SQL 2008 installed, go to configure SQL Server for MU Online (restore database + user) and then configure MuServer.
Perguntas frequentes
Does SQL Server 2008 still work for MU Online?
Yes. SQL Server 2008 R2 is one of the most compatible versions with classic and Season 6 MuServer distributions, being widely used to this day.
Do I need SSMS along with SQL Server 2008?
Yes, it's highly recommended. SQL Server Management Studio (SSMS) is the graphical tool to restore databases, create users and run queries.