MuADMINS
Soluciones
Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.
56 soluciones para “sql server” en Herramientas · Limpiar
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...
✓ Confirmado por el autor del temaRaGEZONE · 2014-02-11Titan 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)...
✓ Confirmado por el autor del temaRaGEZONE · 2013-09-25MU 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...
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...
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...
✓ Confirmado por el autor del temaTUServerMU · 2020-07-10MuMaker 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...
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...
✓ Confirmado por el autor del temaRaGEZONE · 2013-01-23Cash 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...
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...
✓ Confirmado por el autor del temaRaGEZONE · 2017-08-08IGC.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...
✓ Confirmado por el autor del temaRaGEZONE · 2018-10-21IGC.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...
✓ Confirmado por el autor del temaRaGEZONE · 2020-01-05MuMaker 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...
✓ Confirmado por el autor del temaRaGEZONE · 2021-04-11CzF 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...
✓ Confirmado por el autor del temaImperyus Games Brasil · 2011-06-03MuMaker: "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...
✓ Confirmado por el autor del temaRaGEZONE · 2011-06-30MuOnline 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...
✓ Confirmado por el autor del temaDarksTeam · 2020-04-14MuEmu 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.
✓ Confirmado por el autor del temaTUServerMU · 2017-04-29MuEditor 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...
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)...
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...
✓ Confirmado por el autor del temaRaGEZONE · 2022-03-17MuEmu 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...
✓ Confirmado por el autor del temaTUServerMU · 2018-06-04