MuADMINS
Soluções
Correções curtas para problemas comuns de servidor, cliente e site de MU Online, cada uma com a fonte e a data. “Confirmado” significa que quem perguntou disse que a correção funcionou.
79 soluções para “SQL Server” em Configuração do servidor para MuEmu / Louis e para todos os files · Limpar
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.
✓ Confirmado pelo autor do tópicoCreandoMU · 2020-08-14Creating 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...
✓ Confirmado pelo autor do tópicoTUServerMU · 2020-05-04MuEmu (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...
✓ Confirmado pelo autor do tópicoTUServerMU · 2020-07-12MuEmu 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...
✓ Confirmado pelo autor do tópicoTuServerMU · 2017-11-11MuEmu 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...
✓ Confirmado pelo autor do tópicoTuServerMU · 2020-08-08MuEmu 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...
✓ Confirmado pelo autor do tópicoTuServerMU · 2018-06-06Louis S4 (TSM FirePremium) local server worked for one day, then shows SQL connection errors.
1. Create the ODBC data sources by hand in the ODBC administrator (instead of the .reg file). 2. Point them to the right SQL server and database and restart the servers.
✓ Confirmado pelo autor do tópicoTuServerMU · 2018-06-11Louis S6E3 server suddenly stops saving player data and seems to restart; SQL reports 'The transaction log for database MuOnline is full'.
1. The disk had no free space for the SQL transaction log. 2. Free or add disk space on the VPS (the topic starter added more GB). 3. Restart SQL Server and the MU servers.
✓ Confirmado pelo autor do tópicoTuServerMU · 2018-11-25SQL 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.
✓ Confirmado pelo autor do tópicoDarksTeam · 2010-08-08SQL 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...
✓ Confirmado pelo autor do tópicoTUServerMU · 2021-03-3097d 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...
✓ Confirmado pelo autor do tópicoTUServerMU · 2021-02-08Creating the MuOnline ODBC data source fails with 'SQL Server Error: 2' (EX700 server, SQL Express)
1. Error 2 means the ODBC wizard cannot find the SQL Server you typed. 2. Make sure the SQL Server service is running. 3. With SQL Server Express the server name must include the instance...
✓ Confirmado pelo autor do tópicoRaGEZONE · 2015-04-22MuEmu Season 8 Episode 3 asks for a Me_MuOnline database; where do I get it?
1. There is no separate Me_MuOnline download: for these files it is the same database as MuOnline. 2. Point the Me_MuOnline connection (ODBC data source or config entry) to your MuOnline...
✓ Confirmado pelo autor do tópicoRaGEZONE · 2017-03-09SQL 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...
✓ Confirmado pelo autor do tópicoTuServerMU · 2017-09-17SQL 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...
✓ Confirmado pelo autor do tópicoTuServerMU · 2018-11-19MuEmu S6 by Louis: DataServer and JoinServer say 'Could not connect to database' with both included databases, even with correct IPs and open ports.
1. The included ODBC .reg created a data source named MuOnlineS6 pointing to database MuOnlineS6. 2. Edit the ODBC data source (or the .reg) so the name and database match what the server...
✓ Confirmado pelo autor do tópicoTuServerMU · 2017-10-10Nothing is saved in game and editors say the database is read-only
The database that came with a repack can be damaged or incomplete. Here the fix was to use the clean database of the package the files are based on. 1. Download the original package the r...
✓ Confirmado pelo autor do tópicoTUServerMU · 2024-01-28Unicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedEscrito pelo MuADMINSWhat 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 verifiedEscrito pelo MuADMINSI 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 verifiedEscrito pelo MuADMINS
Vídeos no MUTube
Como configurar o SQL Server 2008 para MuOnline
MuADMINS · 4:43 · 2016
Instalar Sql Para MuOnline sem erro 2018
Rk Games · 10:37 · 2018
Como configurar o MSSQL 2000 para MuOnline
MuADMINS · 7:20 · 2013
Como Baixar e Instalar o SQL Server 2014 para Servidor de MuOnline [Passo a Passo]
LABMU · 43:26 · 2025