Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir

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.

239 soluções para “sql” · Limpar

  1. Configuração do 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 pelo autor do tópicoTUServerMU · 2020-07-08
  2. Configuração do 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 pelo autor do tópicoTUServerMU · 2020-02-21
  3. Configuração do 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 pelo autor do tópicoRaGEZONE · 2021-04-15
  4. Configuração do 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...

    Reescrita da fonte pelo MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  5. Siteany

    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 pelo autor do tópicoTuServerMU · 2019-03-17
  6. Configuração do 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 pelo autor do tópicoTuServerMU · 2018-10-15
  7. Configuração do 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 pelo autor do tópicoTuServerMU · 2017-06-18
  8. Configuração do 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 pelo autor do tópicoTuServerMU · 2017-04-21
  9. Configuração do 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 pelo autor do tópicoTUServerMU · 2018-10-06
  10. FerramentasS4.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 pelo autor do tópicoRaGEZONE · 2021-04-11
  11. FerramentasWebZen 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 pelo autor do tópicoImperyus Games Brasil · 2011-06-03
  12. Siteany

    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 pelo autor do tópicoTUServerMU · 2018-09-29
  13. Configuração do 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 pelo autor do tópicoTuServerMU · 2019-10-09
  14. Configuração do 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 pelo autor do tópicoTuServerMU · 2017-11-02
  15. Configuração do 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 pelo MuADMINS
  16. Site

    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 pelo MuADMINS
  17. Site

    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 pelo MuADMINS
  18. Site

    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 pelo MuADMINS
  19. Configuração do 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 pelo MuADMINS
  20. Configuração do 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 pelo MuADMINS

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.