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.

56 solutions for “SQL Server” in Tools · Clear

  1. Tools

    MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1

    1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...

    ✓ Confirmed by the topic starterRaGEZONE · 2014-02-11
  2. 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
  3. ToolsEx702 to S8E2

    MU DB Helper: how do I install the item, inventory and vault database editor for Ex702 and newer servers?

    1. Requirements: Visual Studio 2013, SQL Server 2012 or newer, ODBC Driver 13 and a MU Online Ex702+ database. 2. Clone the repository and make sure a MuOnline database exists (CREATE DAT...

    MuADMINS rewrite of the sourceNot verifiedGitHub (kyleruss/mu-db-helper) · 2018-04-30
  4. ToolsOpenMUS6E3

    OpenMU admin panel: the Setup page says 'Can't connect to the database, probably not created yet' or 'Update required'

    1. Open Setup (/setup). It shows the state of the database. 2. *Can't connect to the database, probably not created yet* or *Not created*: click Create, pick the game version (Season 6 Ep...

    MuADMINS rewrite of the sourceNot verifiedGitHub (MUnique/OpenMU) · 2026-10-26
  5. ToolsMuEmu / LouisSeason 6

    Cash Editor gives an error when editing credits, although the SQL user and password are set

    The cash table and column names in the editor config were wrong. 1. Open the editor config file (XTRMu in the thread). 2. [SQLConnection]: SQLHost = (local), SQLUser = your SQL user, SQLP...

    ✓ Confirmed by the topic starterTUServerMU · 2020-07-10
  6. Tools

    MuMaker 1.13: how to use a new item database (.mdb) with tier sets, and socket options that do not appear

    1. Replace MuMaker.mdb in the MuMaker folder with the new .mdb and open mumaker.exe. 2. The items only work in game if your server files already have those tier sets. 3. In the shared .md...

    MuADMINS rewrite of the sourceNot verifiedRaGEZONE · 2017-01-12
  7. Tools

    MuWeb 0.8 does not work with XAMPP on Windows 7 and SQL 2008 (php.ini edits do not help)

    1. MuWeb 0.8 needs an old PHP with the MSSQL functions: the newer XAMPP builds do not run it even after php.ini changes. 2. Install XAMPP 1.6.1 (not higher), configure php.ini as the MuWe...

    ✓ Confirmed by the topic starterRaGEZONE · 2013-01-23
  8. ToolsWebZen 97d / 99b

    Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs

    1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...

    MuADMINS rewrite of the sourceNot verifiedImperyus Games Brasil · 2009-10-04
  9. Tools

    MuMaker 1.12: "No connection could be made because the target machine actively refused it, error 0" or "error 40" when connecting

    1. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER. 2. Set TCP/IP to Enabled. 3. In TCP/IP Properties, IP Addresses tab: set Enabled t...

    ✓ Confirmed by the topic starterRaGEZONE · 2017-08-08
  10. ToolsIGCN

    IGC.EssentialTools: creating an account fails with "Could not find stored procedure master.dbo.XP_MD5_EncodeKeyVal"

    1. The tool hashes the password with the MD5 extended procedure, which is not installed in your SQL Server. 2. Install the MD5 procedure for your SQL Server: the fix in the thread is the...

    ✓ Confirmed by the topic starterRaGEZONE · 2018-10-21
  11. ToolsIGCN

    IGC.EssentialTools crashes after the first-run notice although SQL named pipes and TCP/IP are enabled (crash dump in CrashDumps)

    1. Symptoms: the first-run notice pops up, then the tool crashes on every start; compatibility mode and run as admin do not help; a dump such as IGCN.EssentialTools.exe.5908.dmp appears i...

    ✓ Confirmed by the topic starterRaGEZONE · 2020-01-05
  12. ToolsS4.5

    MuMaker 1.12 / 1.13: warehouse and inventory items do not load on a Season 4.5 database (other MuMaker builds fail too)

    1. The cause is the database layout of these files, not the MuMaker install: reinstalling, MSSQL 2005 vs 2014, an Items column set to varbinary(1920) and five other MuMaker builds gave th...

    ✓ Confirmed by the topic starterRaGEZONE · 2021-04-11
  13. ToolsWebZen 97d / 99b1.02n S2

    CzF Editor: after restoring the databases the editor login fails with 'ID not authenticated or banned' (1.02n + S2)

    1. The editor login you created on the first run was lost when the databases were restored. 2. Close the editor and open its folder. 3. Delete (or edit) CzFMuEditor.ini. Its [ODBCConnecti...

    ✓ Confirmed by the topic starterImperyus Games Brasil · 2011-06-03
  14. Tools

    MuMaker: "Login failed for user 'sa'" although the server runs and the password is right (only one MuMaker build works)

    1. Check that the sa login has rights on the MU databases and that the password in the MuMaker Config.ini is right. 2. If it still says login failed, the MuMaker build does not fit your s...

    ✓ Confirmed by the topic starterRaGEZONE · 2011-06-30
  15. ToolsWebZen 97d / 99b97d, 99

    MuOnline Shop Editor 1.6 (Mu Shop.exe) does not work on 64-bit Windows: the Microsoft.Jet.OLEDB.4.0 provider is not registered

    1. The editor reads its item list through the old 32-bit Microsoft.Jet.OLEDB.4.0 provider, so on 64-bit Windows (the asker used Windows Server 2012 x64) it fails; installing .NET Framewor...

    ✓ Confirmed by the topic starterDarksTeam · 2020-04-14
  16. ToolsMuEmu / Louis

    MuEmu Editor (2017) + Fixs: an error shows at start although Config.ini has localhost, port 1433, sa and the password

    1. Open the editor Config.ini. 2. In the [Me_MuOnline] and [MuOnline] blocks change EnableTrusted = 0 to EnableTrusted = 1. 3. Save and start the editor again: it connects.

    ✓ Confirmed by the topic starterTUServerMU · 2017-04-29
  17. 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
  18. 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
  19. ToolsMuEmu / Louis

    RJLauncher: how to set up the launcher and its patch download for Louis files (patchver, patchlink, launch line)

    1. Set up a web server first (for example XAMPP) and make sure the site works; locally the IP is 127.0.0.1, for players use your public IP and forward the game ports and the web port (usu...

    ✓ Confirmed by the topic starterRaGEZONE · 2022-03-17
  20. ToolsMuEmu / Louis

    MuEmu Editor: an error appears when searching an account and inventory changes are not saved ('los cambios no han sido guardados')

    1. Open the editor Config.ini and check the database names in both blocks: ME_DB under [Me_MuOnline] and MU_DB under [MuOnline]. 2. They must match the real name of your database in SQL S...

    ✓ Confirmed by the topic starterTUServerMU · 2018-06-04

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