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.

20 solutions for “user dsn” · Clear

  1. 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
  2. Server setup

    ODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)

    MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...

    Not verifiedWritten by MuADMINS
  3. ToolsWebZen 97d / 99bS3

    CzF MuEditor 1.05a: the editor freezes or hangs on connect (Windows Vista 64 bit, SQL Server 2005)

    1. Open the ODBC Data Source Administrator. 2. Make a data source for every database the editor uses: the MU database (MuOnline) as well as Ranking and Event. The asker had only made Rank...

    ✓ Confirmed by the topic starterRaGEZONE · 2007-08-20
  4. Server setupMuEmu / LouisSeason 6

    MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config

    MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...

    ✓ Confirmed by the topic starterTUServerMU · 2020-07-12
  5. Server setupOther filesS2

    Season 2 files on SQL Server 2000: after creating the MuOnline database with the query, DataServer shows a database error. What was wrong?

    1. Run the database creation query in Query Analyzer logged in as sa, without selecting another database first. 2. Check the ODBC admin: the files' ODBC.reg had created the entries under...

    ✓ Confirmed by the topic starterTuServerMU · 2017-03-23
  6. 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
  7. WebsiteS6

    WebEngine CMS install keeps saying 'Could not connect to database (1)' with SQL Server 2008 and XAMPP (PDO ODBC), even though SSMS connects fine.

    1. The thread found a conflict between SQL Server 2008 and WebEngine's connection. 2. Install a newer SQL Server (2012 worked for the topic starter; another user had 2019 working). 3. Res...

    ✓ Confirmed by the topic starterRaGEZONE · 2023-10-06
  8. Server setupMSProS2, S3, S6

    What are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?

    MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...

    Not verifiedWritten by MuADMINS
  9. ToolsWebZen 97d / 99b97d-99

    MuEditor 2.1 (SkyTeam): how to set it up on another PC to edit the server database remotely (ODBC and DNS.ini)

    1. On the PC where you run MuEditor open Control Panel, Administrative Tools, Data Sources (ODBC). 2. In System DSN click Add, choose SQL Server: Name MuOnline, Description MuEditor, Serv...

    MuADMINS rewrite of the sourceNot verifiedRaGEZONE · 2005-07-17
  10. Server setup

    How do I back up and restore MU databases: which ones, in which order, and moving to a new PC?

    Back up every database of the server at the same moment (server closed), and restore them together: - IGCN: MuOnline, Me_MuOnline (if used), Events, Ranking, BattleCore - MuEmu, Louis, MS...

    Not verifiedWritten by MuADMINS
  11. Tools

    Guild Editor: "An Error was found in your CMTedit.ini !" when it starts

    1. Open CMTedit.ini next to the editor. 2. In [MuOnline] (and [MeMuOnline]) the DSN= value is the name of your ODBC data source, not the SQL Server name; it is generally MuOnline. Create...

    MuADMINS rewrite of the sourceNot verifiedRaGEZONE · 2020-05-30
  12. ToolsEX803

    IzsMuEditor 2.1.2 (EX803): the editor does not connect to the database

    1. By default IzsMuEditor connects through an ODBC DSN. 2. If it does not connect, open Data\IzsConfig.ini, set Use_ODBC to 0 and fill in your SQL connection data (server, user, password)...

    MuADMINS rewrite of the sourceNot verifiedRaGEZONE · 2016-11-19
  13. Tools

    Titan Editor: cannot connect to the MU database to create accounts (single MuOnline database)

    1. Open the Titan Editor config. With only one database (MuOnline) both ODBC names point to it: [Connection] ODBC=MuOnline, ODBC_Me=MuOnline, User=sa, Password=yourpass, SQLServer=(local)...

    ✓ Confirmed by the topic starterRaGEZONE · 2013-09-25
  14. 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
  15. Game clientWebZen 97d / 99b0.97

    Serial does not match the client and the main is encrypted, so HxD and main editors fail (0.97 + Retail2 files).

    1. Restore the MuOnline.bak shipped in C:\MuServer\DB. 2. Create the ODBC entry (64 bit). 3. Delete the CheckSum file in C:\MuServer\data\lang\kor. After this the client connected.

    ✓ Confirmed by the topic starterTuServerMU · 2020-03-28
  16. Server setupMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Confirmed by the topic starterTUServerMU · 2018-10-06
  17. 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
  18. 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
  19. Server setupIGCNS9, S12, S16, S17, S18

    Which databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?

    IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...

    Not verifiedWritten by MuADMINS
  20. Websiteany

    WebEngine cannot connect to an older SQL Server (2008, 2012, 2014, 2016). What settings help?

    1. Linux with pdo_dblib: install FreeTDS (apt install freetds-bin) and add a named block in /etc/freetds/freetds.conf with host, port 1433, encryption off and tds version 7.1. 2. Test it...

    MuADMINS rewrite of the sourceNot verifiedWebEngine docs · 2025-04-25
Still stuck? Ask the MU Assistant Search MuGPS Search MUTube

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