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.
145 solutions for “cannot open database” · Clear
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 MuADMINSWhy did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?
Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...
Not verifiedWritten by MuADMINSLouis files: after testing the auction system no new auction starts (or it starts and ends at once).
1. A finished auction does not run again. 2. Back up the database, then run on MuOnline: DELETE FROM EventAuction and DELETE FROM EventAuctionReward. 3. Restart the GameServer to start ne...
✓ Confirmed by the topic starterCreandoMU · 2020-12-02SCFdb (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-16MuMaker 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...
MuMaker: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
1. The error means SQL Server only accepts Windows logins, so the sa login that MuMaker uses is refused. 2. Change the SQL Server authentication to SQL Server and Windows Authentication m...
✓ Confirmed by the topic starterRaGEZONE · 2008-01-29OpenMU in Docker: how do I update to a new version without losing accounts and characters?
1. Back up the PostgreSQL database first. 2. In the folder with the compose file run docker-compose pull to pull all images of the stack. 3. Run docker-compose up -d. Containers that use...
MuEditor cannot connect to SQL Server (Louis S6 update 15).
1. Follow the Louis setup video for SQL and ODBC. 2. The missing part was opening the SQL port (1433 by default) in the firewall. 3. Open it and connect again.
✓ Confirmed by the topic starterCreandoMU · 2020-08-14MuEditor on the host PC cannot connect to the SQL Server that runs inside a local virtual machine
1. In SQL Server Configuration Manager inside the VM enable TCP/IP (and Named Pipes), restart the SQL service and allow port 1433 in the VM firewall. 2. In the editor config fill both blo...
✓ Confirmed by the topic starterTUServerMU · 2019-11-24SQL query to delete only characters and guilds but keep the accounts and their warehouse
1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...
✓ Confirmed by the topic starterTUServerMU · 2021-03-30Creating 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-0497d GameServer on a VPS says 'Failed to connect to SQL Server' although the SQL login, the MuOnline database and the IPs look correct
The database and the SQL settings were fine; the IP passed to GameServer.exe in its shortcut was the problem. 1. Right-click the GameServer.exe shortcut you start the server with and open...
✓ Confirmed by the topic starterTUServerMU · 2021-02-08MuEmu S8 EP3: the server runs but MuEditor cannot connect to SQL, so I cannot create accounts or items. Changing the SQL password in config.ini did not help.
1. Open the editor's config.ini. 2. In the SERVER field put the name of your computer (right click This PC > Properties shows it), not an IP. 3. Fill in the SQL user (sa) and your passwor...
✓ Confirmed by the topic starterTuServerMU · 2016-09-14MuEmu 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-08SQL 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-06MuEmu S6 DataServer and JoinServer show "Could not connect to database" on SQL 2008 R2 even after renaming MuOnlineS6 to MuOnline. What fixed it?
1. In the DataServer and JoinServer config files make sure the database name is the one you restored (MuOnline, not MuOnlineS6). 2. Delete the old or duplicate MuOnline DSNs and create th...
✓ Confirmed by the topic starterTuServerMU · 2018-06-06MuCore 2.2.0 installer stops with 'SQL Failed' at the connection step.
1. Open TCP port 1433 in the Windows firewall. 2. In SQL Server Configuration Manager enable Named Pipes and TCP/IP, set IPAll TCP Port 1433. 3. Restart SQL Server and run the installer a...
✓ Confirmed by the topic starterTuServerMU · 2019-07-27RJLauncher: 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-17MuEmu S6 E3 Castle Siege: when the battle starts the defending guild shows as attacker, with no config change
The Castle Siege data stored in SQL had gone bad. 1. Back up the database first. 2. The asker cleared the SQL tables used by Castle Siege (in MuEmu databases they are the MuCastle_ tables...
✓ Confirmed by the topic starterTUServerMU · 2020-11-15MuEmu 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