Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir

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

130 soluciones para “SQL Server” para Otros server files y para todos los server files · Limpiar

  1. Instalación del servidorS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedEscrito por MuADMINS
  2. Herramientas

    MuMaker: cannot connect to SQL Server 2005 Express (SQLEXPRESS)

    1. Open SQL Server Configuration Manager, then Protocols for SQLEXPRESS. 2. Right click TCP/IP, Properties, set Enabled to Yes. 3. In the IP Addresses tab set Active and Enabled to Yes fo...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedRaGEZONE · 2013-10-09
  3. Herramientas

    MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)

    1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedRaGEZONE · 2007-12-22
  4. Instalación del servidor97d+99i

    SQL command to give credits to every account (DarksTeam 97d+99i)

    1. Open SSMS / Query Analyzer on the MuOnline database. 2. For all accounts run UPDATE MEMB_CREDITS SET credits=credits+500. 3. For one account run UPDATE MEMB_CREDITS SET credits=credits...

    ✓ Confirmado por el autor del temaDarksTeam · 2021-12-28
  5. Instalación del servidorany

    Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?

    1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedMicrosoft Learn · 2025-08-26
  6. Herramientasany

    I cannot delete a MU database in SQL Server Management Studio, it gives an error because it is in use. How do I remove it?

    1. Stop DataServer, JoinServer, the editors and the web that use the database. 2. In Management Studio right click the database > Delete. 3. In the Delete Object window tick Close existin...

    ✓ Confirmado por el autor del temaTuServerMU · 2018-01-06
  7. Instalación del servidorany

    During SQL Server setup the password for sa is rejected no matter what I type. Why?

    1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...

    ✓ Confirmado por el autor del temaTuServerMU · 2017-07-21
  8. Sitio webany

    WebEngine 1.0.9 with a remote SQL Server IP fails with 'Could not connect to database (1)', while MuCore connects to the same server without problems.

    1. In the WebEngine installer select the ODBC driver instead of dblib/sqlsrv. 2. Make sure the matching PHP ODBC extension is enabled and port 1433 is reachable. 3. Finish the install.

    ✓ Confirmado por el autor del temaRaGEZONE · 2017-09-09
  9. HerramientasS6

    WebEngine CMS installer: "Could not connect to database (1)" at the database step with MSSQL Server 2008 (PDO ODBC, XAMPP)

    1. In this case the game files connected fine but the WebEngine installer kept failing on the database step, with no error in the SQL logs or the Windows event log. 2. The cause was a con...

    ✓ Confirmado por el autor del temaRaGEZONE · 2023-10-06
  10. Herramientas

    MuCore install: "Connection with MuOnline Database Failed" and "Extension php_mssql.dll must be enabled"

    1. MuCore needs a PHP that still has the old php_mssql.dll extension: in php.ini find extension=php_mssql.dll and remove the ; in front of it. 2. If your web server package has no php_mss...

    ✓ Confirmado por el autor del temaRaGEZONE · 2011-03-05
  11. Herramientas

    MuCore 1.08 installer: with the MSSQL connection it cannot get past step 3 (MSSQL 2008 R2, XAMPP 1.7.1)

    1. Use XAMPP 1.7.7 for MuCore 1.08 (XAMPP 1.7.1 with MSSQL 2008 works badly). 2. Install the client DLL that supports your MSSQL version (linked in the reply). 3. Open C:/xampp/php/php.in...

    ✓ Confirmado por el autor del temaRaGEZONE · 2016-05-26
  12. Herramientas

    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-11
  13. Herramientas

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

    ✓ Confirmado por el autor del temaRaGEZONE · 2013-09-25
  14. Instalación del servidor1.0M, 1.0L

    Accounts do not work after putting a 1.0L database under 1.0M files

    The two versions use different password storage. 1. 1.0M files use MD5 on; 1.0L files use MD5 off. 2. Use the database (and website install option) that matches your files: MD5 on for 1.0...

    ✓ Confirmado por el autor del temaDarksTeam · 2008-11-25
  15. Sitio web

    MuWeb 0.9 installer check shows Mssql: NO even after editing php.ini

    1. Install XAMPP 1.7.0 (it includes the mssql extension the site needs). 2. Put MuWeb 0.9 in its htdocs and open the installer again; Mssql now shows YES.

    ✓ Confirmado por el autor del temaDarksTeam · 2009-02-12
  16. Sitio web

    Error #123 Loading php_mssql.dll Failed when installing DarksWeb, although the dll is in the ext folder

    1. Install AppServ 2.5.9 instead of the XAMPP / VertrigoServ builds that failed. 2. Edit C:\Windows\php.ini (the php.ini AppServ really uses) and enable extension=php_mssql.dll there. 3....

    ✓ Confirmado por el autor del temaDarksTeam · 2009-10-28
  17. Instalación del servidorany

    How to get the list of e-mail addresses of all registered accounts from the MU database

    1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...

    ✓ Confirmado por el autor del temaTUServerMU · 2021-03-17
  18. Instalación del servidorany

    How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database

    1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...

    ✓ Confirmado por el autor del temaTUServerMU · 2020-07-23
  19. Sitio web

    How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?

    1. G_Mark in the Guild table is binary: turn it into text with bin2hex(). You get 64 hex digits, one per cell of an 8x8 grid. 2. Map each digit to a color: 0 transparent, 1 #000000, 2 #8c...

    ✓ Confirmado por el autor del temaRaGEZONE · 2020-07-01
  20. Instalación del servidorany

    JoinServer and DataServer show Could not connect to database on start.

    1. Restore the MuOnline database correctly in SQL Server (from the backup shipped with your files). 2. Create the ODBC data source the servers expect, pointing to that database. 3. Make s...

    ✓ Confirmado por el autor del temaTuServerMU · 2017-07-05

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.