Community AlphaAlpha MUADMINS
FRFrançais
Connexion
Sur MuADMINSConfig ScannerDéposez le zip de vos fichiers : rates, drops, spots, limitesOuvrirSur MuADMINSRetrouvez-nous sur DiscordDemandez de l'aide, partagez ce que vous créez et parlez de MU avec d'autres propriétaires de serveurs.Ouvrir

MuADMINS

Solutions

Des correctifs courts pour les problèmes courants de serveur, de client et de site web MU Online, chacun avec sa source et sa date. “Confirmé” signifie que la personne qui a posé la question a indiqué que le correctif a fonctionné.

145 solutions pour “cannot open database” · Effacer

  1. Installation du serveurMSProS2, 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 verifiedRédigé par MuADMINS
  2. Installation du serveurIGCNS16, S17, S18

    Why 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 verifiedRédigé par MuADMINS
  3. Installation du serveurMuEmu / LouisSeason 6 (Louis)

    Louis 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...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2020-12-02
  4. Installation du serveurS4

    SCFdb (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.

    ✓ Confirmé par l'auteur du sujetDarksTeam · 2008-10-16
  5. Outils

    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...

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2017-01-12
  6. Outils

    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...

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2008-01-29
  7. Installation du serveurOpenMUS6E3

    OpenMU 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...

    Réécriture de la source par MuADMINSNot verifiedGitHub (MUnique/OpenMU) · 2024-07-19
  8. Installation du serveurMuEmu / LouisSeason 6 (Louis update 15)

    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.

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2020-08-14
  9. OutilsMuEmu / Louisany

    MuEditor 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2019-11-24
  10. Installation du serveurany

    SQL 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2021-03-30
  11. Installation du serveurMuEmu / LouisSeason 6 Episode 3

    Creating 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2020-05-04
  12. Installation du serveur0.97d

    97d 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2021-02-08
  13. OutilsMuEmu / LouisS8

    MuEmu 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...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2016-09-14
  14. Installation du serveurMuEmu / LouisS6

    MuEmu 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...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2020-08-08
  15. Installation du serveurWebZen 97d / 99b97d

    SQL 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...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2018-08-06
  16. Installation du serveurMuEmu / LouisS6

    MuEmu 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...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2018-06-06
  17. Site webany

    MuCore 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...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2019-07-27
  18. OutilsMuEmu / 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...

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2022-03-17
  19. GameplayMuEmu / LouisSeason 6 Episode 3

    MuEmu 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2020-11-15
  20. Installation du serveurMuEmu / LouisS4

    MuEmu 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...

    ✓ Confirmé par l'auteur du sujetTuServerMU · 2017-11-11

MuADMINS Community Alpha : gratuit, fait par la communauté, en développement actif.