MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 55 по запросу “dsn” · Сбросить
Which php_pdo_sqlsrv DLL do I need for WebEngine on Windows PHP 8.x, and why does it not load?
1. The driver file must match PHP version, thread safety and bitness: e.g. php_pdo_sqlsrv_82_ts_x64 for PHP 8.2 thread safe 64 bit. 2. XAMPP Apache uses thread safe (ts) PHP; IIS FastCGI...
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...
✓ Подтверждено автором темыTuServerMU · 2017-11-11MuMaker 1.13: "Format of the initialization string does not conform to specification starting at index 30" when connecting to SQL
1. Check that SQL Server has TCP/IP enabled on port 1433 and that port 1433 is allowed in the Windows firewall; check the ODBC source and the MuMaker config. 2. Make sure .NET Framework 3...
✓ Подтверждено автором темыRaGEZONE · 2025-04-30CzF 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...
✓ Подтверждено автором темыImperyus Games Brasil · 2011-06-03MuEditor 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.
✓ Подтверждено автором темыCreandoMU · 2020-08-14DarksTeam 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...
✓ Подтверждено автором темыTUServerMU · 2020-07-08Season 2 Ep X (Evolution Team) files ship the database as SQL scripts, not a .bak. How do I create the database?
1. On SQL Server 2008 or newer, restore the database backup if the files include one. 2. On SQL Server 2000 or 2005, open Query Analyzer (Start menu) and log in as sa. 3. Paste the script...
✓ Подтверждено автором темыTuServerMU · 2016-12-14During 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...
✓ Подтверждено автором темыTuServerMU · 2017-07-21How do I back up and restore MU databases: which ones, in which order, and moving to a new PC?
Back up every database of the server at the same moment (server closed), and restore them together: - IGCN: MuOnline, Me_MuOnline (if used), Events, Ranking, BattleCore - MuEmu, Louis, MS...
Not verifiedНаписано MuADMINS"Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database
Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...
Not verifiedНаписано MuADMINSCould not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedНаписано MuADMINSWhich databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?
IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...
Not verifiedНаписано MuADMINSWebEngine cannot connect to an older SQL Server (2008, 2012, 2014, 2016). What settings help?
1. Linux with pdo_dblib: install FreeTDS (apt install freetds-bin) and add a named block in /etc/freetds/freetds.conf with host, port 1433, encryption off and tds version 7.1. 2. Test it...
What does a server need before installing WebEngine CMS 1.2.x?
1. Apache with mod_rewrite (or the Nginx or IIS rules from the wiki). 2. PHP 8.1 or newer, 8.4 suggested. 3. One SQL Server driver: PDO dblib (Linux), ODBC, or SQLSRV (Windows). 4. PHP ex...
"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...