Install SQL Server 2014/2017/2019 for MU Online
The modern SQL Server versions (2014, 2017, 2019) for new MU Online seasons: installation, Express vs Developer and tips.
The modern SQL Server versions (2014, 2017, 2019) are suited for new MU Online seasons and for those wanting a more current database. See how to install and which edition to choose.
Which edition to choose
| Edition | When to use |
|---|---|
| Express | Free; testing and small servers (has limits) |
| Developer | Free; ideal for learning/developing (no limits, non-production) |
| Standard | Production; without Express's limits |
Step by step
- Download the installer for the version (2014/2017/2019) and chosen edition;
- Choose Basic or Custom (Custom gives more control);
- In authentication, select Mixed Mode and set the
sapassword; - Finish and install SSMS (now a separate download);
- Enable TCP/IP in Configuration Manager.
Compatibility with the distribution
Some classic distributions were made for 2008 and may require tweaks on modern SQL (database compatibility modes). Modern seasons usually already assume new SQL.
After installing, go to configure SQL Server for MU Online.
Perguntas frequentes
Can I use SQL Server 2019 with MU Online?
Yes, especially in modern seasons. Some classic distributions prefer 2008, but many work well on new versions. Always check your distribution's recommendation.
Which edition to use: Express, Developer or Standard?
For testing and small servers, Express (free) works, but has memory/database limits. Developer (free, no limits for non-production use) is great for learning; Standard for production.