Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

21 solutions for “sql server install” in Server setup · Clear

  1. Server setupany

    SQL Server 2008 R2 setup crashes and closes while installing support files. Formatting and installing it before .NET did not help.

    1. Stop using the repacked or modified installer you downloaded. 2. Download the SQL Server installer directly from Microsoft (a forum moderator linked the official download). 3. Run that...

    ✓ Confirmed by the topic starterTuServerMU · 2017-09-17
  2. Server setupWebZen 97d / 99b97d

    DarksTeam 97d+99i on Windows 10 64-bit: servers say they cannot connect to SQL after installing SQL 2008. Editing the ODBC .reg did not help.

    1. Uninstall the SQL Server 2008 instance that was installed with Windows authentication only. 2. Reinstall it choosing Mixed Mode and give sa a password. 3. Restore the MuOnline database...

    ✓ Confirmed by the topic starterTuServerMU · 2018-08-05
  3. Server setupany

    SQL Server 2012 installed without errors but SQL Server Agent will not start (Browser starts fine) when preparing MU files. What fixed it?

    1. In services.msc set SQL Server Agent to Automatic and try to start it. 2. If it still fails, the instance was installed with the wrong authentication choice. 3. Reinstall SQL Server an...

    ✓ Confirmed by the topic starterTuServerMU · 2018-11-19
  4. Server setupWebZen 97d / 99b97d

    SQL 2000 will not install on Windows 7, so how do I run DarksTeam 97d files on SQL Server 2008 R2 instead?

    1. Install SQL Server 2008 R2 and set a password for sa during setup (do not skip it). 2. Restore the MuOnline database from the files. 3. Open the ODBC admin (32-bit one on 64-bit Window...

    ✓ Confirmed by the topic starterTuServerMU · 2018-08-06
  5. Server setup

    SQL Server 2000 setup says there is not enough free disk space although 60 GB are free

    1. Extract the SQL Server 2000 installer files with WinRAR into a normal folder. 2. Run setup from that extracted folder.

    ✓ Confirmed by the topic starterDarksTeam · 2010-08-08
  6. Server setupMuEmu / LouisSeason 6 Episode 3

    Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)

    The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...

    ✓ Confirmed by the topic starterTUServerMU · 2020-05-04
  7. Server setupany

    During SQL Server setup the password for sa is rejected no matter what I type. Why?

    1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...

    ✓ Confirmed by the topic starterTuServerMU · 2017-07-21
  8. Server setupMuEmu / LouisS4

    MuEmu S4: the server and MuMaker do not see the databases on SQL Server 2008 R2 even with remote connections and TCP/IP enabled.

    1. Check how SQL Server was installed: it had been set up as a named instance. 2. The files and MuMaker expect the default instance, reached as (local) or the PC name. 3. Reinstall SQL Se...

    ✓ Confirmed by the topic starterTuServerMU · 2017-11-11
  9. Server setupMuEmu / LouisS6

    MuEmu S6 (KoshGames/Louis) on SQL Server Express 2012: JoinServer says "Could not connect to database" although MuOnline is restored and the .reg files were run.

    1. SQL Express installs a named instance, usually SQLEXPRESS, so (local) alone does not reach it. 2. Open the ODBC admin for your Windows bits and create the DSNs by hand. 3. In the serve...

    ✓ Confirmed by the topic starterTuServerMU · 2020-08-08
  10. Server setup

    What breaks a MU server database? Safe SQL checklist before you run a query

    What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...

    Not verifiedWritten by MuADMINS
  11. Server setup

    I changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)

    The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...

    Not verifiedWritten by MuADMINS
  12. Server setupany

    "Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?

    1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...

    MuADMINS rewrite of the sourceNot verifiedMicrosoft Learn · 2025-08-26
  13. Server setupOpenMUS6E3

    OpenMu Client Babylon: how do I install my own OpenMU server with the browser client on a VPS?

    1. Use a VPS with Ubuntu 22.04+ or Debian 12+ (or Rocky/Alma 9) with at least 4 GB RAM and 30 GB disk; Windows 10/11 or Server 2022 also works. A domain is optional; with one, players get...

    MuADMINS rewrite of the sourceNot verifiedGitHub (Ignies/OpenMu-Client-Babylon) · 2026-10-06
  14. Server setup1.0M, 1.0L

    Accounts do not work after putting a 1.0L database under 1.0M files

    The two versions use different password storage. 1. 1.0M files use MD5 on; 1.0L files use MD5 off. 2. Use the database (and website install option) that matches your files: MD5 on for 1.0...

    ✓ Confirmed by the topic starterDarksTeam · 2008-11-25
  15. Server setup

    JoinServer and DataServer cannot connect to the database although the backup is restored

    These files had the database name MuOnlineS6 in the server configs while the database was restored as MuOnline, so the servers looked for a database that does not exist. 1. In SQL Server...

    ✓ Confirmed by the topic starterTUServerMU · 2018-09-27
  16. Server setupIGCNS9

    IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.

    1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.

    ✓ Confirmed by the topic starterTuServerMU · 2017-06-18
  17. Server setup

    Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them

    WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...

    Not verifiedWritten by MuADMINS
  18. Server setupMuDevsS18, S20

    MuDevs: WZ_CONNECT_MEMB has 4 parameters (@HarwareID) and MEMB_STAT has HWID / OnlineHours

    MuDevs differs from the other MuEmu based files here: - WZ_CONNECT_MEMB @memb___id varchar(10), @ServerName varchar(50), @IP varchar(20), @HarwareID varchar(74) (4th parameter, spelled Ha...

    Not verifiedWritten by MuADMINS
  19. Server setupMuDevsS18

    MuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)

    The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...

    Not verifiedWritten by MuADMINS
  20. Server setupS4

    SCFdb (SCF Season 4 database manager) shows an error at start

    1. Reinstall Microsoft .NET Framework 2.0, or better install .NET Framework 3.0. 2. Start SCFdb again.

    ✓ Confirmed by the topic starterDarksTeam · 2008-10-16

Videos on MUTube

More videos for “sql server install”

Still stuck? Ask the MU Assistant Search MuGPS

MuADMINS Community Alpha: free and community made, in active development.