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.

94 solutions for “mssql” in Server setup · Clear

  1. Server setupIGCNS9, S12, S16, S17, S18

    How do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?

    On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...

    Not verifiedWritten by MuADMINS
  2. Server setup

    How do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?

    Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...

    Not verifiedWritten by MuADMINS
  3. Server setupMuEmu / Louis97d

    Kayito MuEmu 0.97k download has no JoinServer and DataServer folders. Where are they?

    1. First choose your database engine: SQL Server or MySQL. 2. For SQL Server copy JoinServer and DataServer from the MSSQL folder; for MySQL take them from the MySQL folder. 3. Put both n...

    ✓ Confirmed in the issueGitHub (nicomuratona/MuEmu-0.97k-kayito) · 2025-06-22
  4. Server setupMuEmu / LouisSeason 6 (Louis update 24)

    ODBC test works but JoinServer and DataServer still do not connect (Louis files on a VPS)

    The topic starter fixed it by reinstalling SQL Server: it was installed wrong. The helper's diagnosis was a named instance (SQLEXPRESS) while the files expect the default instance. 1. Ope...

    ✓ Confirmed by the topic starterTUServerMU · 2021-04-26
  5. Server setup

    How to protect the server from attackers with the firewall

    Only the ConnectServer and GameServer must be reachable from outside. 1. In the firewall block outside access for: MySQL (mysqld.exe), the DataServer(s), ExDB, EventServer, RankingServer,...

    ✓ Confirmed by the topic starterDarksTeam · 2008-06-30
  6. Server setup

    Guild war gives no points: the website shows a negative score and the in-game G Score stays 0

    The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...

    ✓ Confirmed by the topic starterDarksTeam · 2010-05-03
  7. Server setup

    How to protect Game Master characters (give them the protected GM status)

    The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...

    ✓ Confirmed by the topic starterDarksTeam · 2012-05-11
  8. Server setupany

    JoinServer and DataServer show Could not connect to database on start.

    1. Restore the MuOnline database correctly in SQL Server (from the backup shipped with your files). 2. Create the ODBC data source the servers expect, pointing to that database. 3. Make s...

    ✓ Confirmed by the topic starterTuServerMU · 2017-07-05
  9. Server setupWebZen 97d / 99b99b

    Files 99B DarksTeam on Windows 7: MuServer startup throws an ODBC error even with the 64-bit ODBC .reg applied. How was it solved?

    1. Use the ODBC .reg (or manual DSN) that matches your Windows: 32-bit or 64-bit. 2. Make sure the databases were created or restored in SQL Server. 3. Right click the startup shortcuts (...

    ✓ Confirmed by the topic starterTuServerMU · 2018-06-16
  10. Server setupSeason 8

    DataServer and JoinServer do not connect after running the ODBC file that came with the files

    The .reg or .bat ODBC file bundled with many server files does not always create the data source on your Windows. Create it by hand: 1. Open the ODBC Data Source Administrator (on 64-bit...

    ✓ Confirmed by the topic starterTUServerMU · 2021-06-08
  11. Server setup

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Confirmed by the topic starterTUServerMU · 2021-03-24
  12. 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
  13. Server setupOpenMU

    OpenMU in Docker: how do I back up and restore the PostgreSQL database, and fix 'permission denied for schema config' after a restore?

    1. The openmu-db-backup container of nolt/openmu-docker runs pg_dump -Fc every BACKUP_INTERVAL seconds (default 86400), checks the dump and keeps gzipped files in ./backups/ for RETENTION...

    MuADMINS rewrite of the sourceNot verifiedGitHub (nolt/openmu-docker) · 2026-10-24
  14. Server setupany

    How do I open the MU server ports (44405, 55901, 55919 and others) in Windows Firewall quickly and correctly?

    1. Open PowerShell as administrator on the server. 2. Create one inbound rule for all TCP ports, for example: New-NetFirewallRule -DisplayName "MU Server" -Direction Inbound -Protocol TCP...

    MuADMINS rewrite of the sourceNot verifiedMicrosoft Learn · 2025-05-14

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