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

239 soluciones para “sql server” · Limpiar

  1. Instalación del servidor0.97d

    DarksTeam 97d+99i moved to a VPS (Windows Server 2012 R2, SQL 2008 R2): RankingServer shows an error although the config did not change

    The VPS firewall was blocking the RankingServer connections. 1. In Windows Firewall (and the VPS provider firewall, if any) allow the RankingServer program, or open the port it uses, for...

    ✓ Confirmado por el autor del temaTUServerMU · 2020-07-08
  2. Instalación del servidor0.97d

    Aminyuz 97d files: GameServer gives a conexion.ini connection error at start although all IPs are right (EventServer and Ranking open fine)

    The SQL login in the Aminyuz connection file was wrong. 1. Open C:\MuServer\Aminyuz\Conexion (the connection ini of these files). 2. In the [SQL] block set Usuario = sa (your SQL user), C...

    ✓ Confirmado por el autor del temaTUServerMU · 2020-02-21
  3. Instalación del servidor

    Anyone can log in with a random account name and password, and the login creates that account in SQL

    1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...

    ✓ Confirmado por el autor del temaRaGEZONE · 2021-04-15
  4. Instalación del servidorany

    "Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?

    1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedMicrosoft Learn · 2025-08-26
  5. Sitio webany

    MuCore on a web host cannot connect to the MuOnline database on a Google Cloud VPS (Connection with MuOnline Database Failed), although 1433 is open in Windows.

    1. Enable TCP/IP and Named Pipes for the instance in SQL Server Configuration Manager and restart SQL. 2. Open TCP 1433 in the Windows firewall of the VPS. 3. Also open TCP 1433 in the cl...

    ✓ Confirmado por el autor del temaTuServerMU · 2019-03-17
  6. Instalación del servidorWebZen 97d / 99b97d

    DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?

    1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...

    ✓ Confirmado por el autor del temaTuServerMU · 2018-10-15
  7. Instalación del servidorIGCNS9

    IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.

    1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.

    ✓ Confirmado por el autor del temaTuServerMU · 2017-06-18
  8. Instalación del servidorIGCNS9

    IGC DataServer stays on its loading window and never finishes starting.

    1. Check the ODBC/SQL settings of the DataServer. 2. The SQL instance name was wrong. When SQL Server is on the same PC use (local) as the instance/host. 3. Start the DataServer again.

    ✓ Confirmado por el autor del temaTuServerMU · 2017-04-21
  9. Instalación del servidorMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Confirmado por el autor del temaTUServerMU · 2018-10-06
  10. HerramientasS4.5

    MuMaker 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-11
  11. HerramientasWebZen 97d / 99b1.02n S2

    CzF 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-03
  12. Sitio webany

    MVCore cannot add credits or gold to accounts: the credits table configured in the web does not match the database

    The credits table name in the MVCore settings had a 'Me_' prefix that the table in the database does not have. 1. Open the MVCore credits configuration where the credits table name is set...

    ✓ Confirmado por el autor del temaTUServerMU · 2018-09-29
  13. Instalación del servidorany

    I run one server on my VPS and want a second one with its own database on the same VPS, but it does not connect. What must change?

    1. Give the second server its own database and create a new ODBC data source pointing to it (same driver, Server = (local), Database = new name). 2. Point the second JoinServer and DataSe...

    ✓ Confirmado por el autor del temaTuServerMU · 2019-10-09
  14. Instalación del servidorMuEmu / Louisany

    After moving from TitansTech to MuEmu, characters roll back on relog: items and position are not saved. The database was converted. What fixed it?

    1. Character data is saved by the DataServer, so check that first, not the tables. 2. Do not reuse the DataServer from your old TitansTech files: it did not work with MuEmu. 3. Use the Da...

    ✓ Confirmado por el autor del temaTuServerMU · 2017-11-02
  15. Instalación del servidorIGCNS16, S17, S18

    IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)

    IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...

    Not verifiedEscrito por MuADMINS
  16. Sitio web

    How do I set up WebEngine credits (WCoin, Goblin Points, web credits) for my server files?

    WebEngine keeps each currency in a row of WEBENGINE_CREDITS_CONFIG: config_database, config_table, config_credits_col, config_user_col, config_user_col_id (userid, username or email), con...

    Not verifiedEscrito por MuADMINS
  17. Sitio web

    WebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)

    WebEngine 1.2.7 fills MEMB_INFO.sno__numb with _defaultAccountSerial = '1111111111111' (13 characters, includes/classes/class.account.php line 16). The column size depends on the files: -...

    Not verifiedEscrito por MuADMINS
  18. Sitio web

    WebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)

    WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...

    Not verifiedEscrito por MuADMINS
  19. Instalación del servidor

    ODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)

    MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...

    Not verifiedEscrito por MuADMINS
  20. Instalación del servidor

    A character exists in the Character table but does not appear (AccountCharacter slots)

    The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...

    Not verifiedEscrito por MuADMINS

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