MuADMINS
Giải pháp
Các cách sửa ngắn gọn cho những lỗi thường gặp của server, client và website MU Online, mỗi cách đều kèm nguồn và ngày. “Đã xác nhận” nghĩa là người đặt câu hỏi cho biết cách sửa đã hiệu quả.
94 giải pháp cho “mssql” trong Cài đặt server · Xóa lọc
IGCN S9 E2 repack: DataServer says 'Login failed for user ...' (SQLSTATE 28000) and 'DATA SERVER CANNOT CONNECT TO MSSQL'
1. The repack DataServer config came with a SQL login that does not exist on your SQL Server (here a random name like D2a78Rtko0), so the login fails. 2. Open the database settings of the...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2019-07-14MuEditor 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.
✓ Được người mở chủ đề xác nhậnCreandoMU · 2020-08-14SQL Server 2000 setup says there is not enough free disk space although 60 GB are free
1. Extract the SQL Server 2000 installer files with WinRAR into a normal folder. 2. Run setup from that extracted folder.
✓ Được người mở chủ đề xác nhậnDarksTeam · 2010-08-08SQL query to delete only characters and guilds but keep the accounts and their warehouse
1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2021-03-30Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)
The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2020-05-0497d GameServer on a VPS says 'Failed to connect to SQL Server' although the SQL login, the MuOnline database and the IPs look correct
The database and the SQL settings were fine; the IP passed to GameServer.exe in its shortcut was the problem. 1. Right-click the GameServer.exe shortcut you start the server with and open...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2021-02-08MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config
MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2020-07-12Creating the MuOnline ODBC data source fails with 'SQL Server Error: 2' (EX700 server, SQL Express)
1. Error 2 means the ODBC wizard cannot find the SQL Server you typed. 2. Make sure the SQL Server service is running. 3. With SQL Server Express the server name must include the instance...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2015-04-22Season 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2016-12-14SQL Server 2008 R2 setup crashes and closes while installing support files. Formatting and installing it before .NET did not help.
1. Stop using the repacked or modified installer you downloaded. 2. Download the SQL Server installer directly from Microsoft (a forum moderator linked the official download). 3. Run that...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-09-17MuEmu 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-11-11MuEmu S6 (KoshGames/Louis) on SQL Server Express 2012: JoinServer says "Could not connect to database" although MuOnline is restored and the .reg files were run.
1. SQL Express installs a named instance, usually SQLEXPRESS, so (local) alone does not reach it. 2. Open the ODBC admin for your Windows bits and create the DSNs by hand. 3. In the serve...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2020-08-08Season 2 files on SQL Server 2000: after creating the MuOnline database with the query, DataServer shows a database error. What was wrong?
1. Run the database creation query in Query Analyzer logged in as sa, without selecting another database first. 2. Check the ODBC admin: the files' ODBC.reg had created the entries under...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-03-23DarksTeam 97d+99i on Windows 10 64-bit: servers say they cannot connect to SQL after installing SQL 2008. Editing the ODBC .reg did not help.
1. Uninstall the SQL Server 2008 instance that was installed with Windows authentication only. 2. Reinstall it choosing Mixed Mode and give sa a password. 3. Restore the MuOnline database...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-08-05SQL Server 2012 installed without errors but SQL Server Agent will not start (Browser starts fine) when preparing MU files. What fixed it?
1. In services.msc set SQL Server Agent to Automatic and try to start it. 2. If it still fails, the instance was installed with the wrong authentication choice. 3. Reinstall SQL Server an...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-11-19SQL 2000 will not install on Windows 7, so how do I run DarksTeam 97d files on SQL Server 2008 R2 instead?
1. Install SQL Server 2008 R2 and set a password for sa during setup (do not skip it). 2. Restore the MuOnline database from the files. 3. Open the ODBC admin (32-bit one on 64-bit Window...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-08-06MuEmu S6 DataServer and JoinServer show "Could not connect to database" on SQL 2008 R2 even after renaming MuOnlineS6 to MuOnline. What fixed it?
1. In the DataServer and JoinServer config files make sure the database name is the one you restored (MuOnline, not MuOnlineS6). 2. Delete the old or duplicate MuOnline DSNs and create th...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-06-06Louis S4 (TSM FirePremium) local server worked for one day, then shows SQL connection errors.
1. Create the ODBC data sources by hand in the ODBC administrator (instead of the .reg file). 2. Point them to the right SQL server and database and restart the servers.
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-06-11Louis S6E3 server suddenly stops saving player data and seems to restart; SQL reports 'The transaction log for database MuOnline is full'.
1. The disk had no free space for the SQL transaction log. 2. Free or add disk space on the VPS (the topic starter added more GB). 3. Restart SQL Server and the MU servers.
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-11-25Restoring the MuOnline database fails in SQL Server 2022 (MSPro v17 files)
1. In SQL Server Management Studio right click Databases > Restore Database, choose Device and pick the .bak file that came with the files. 2. Open the Options page. 3. Tick "Overwrite th...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2026-09-27



