MuADMINS
Soluzioni
Fix brevi per i problemi comuni di server, client e siti web di MU Online, ognuno con la sua fonte e la sua data. “Confermato” significa che chi ha fatto la domanda ha detto che il fix ha funzionato.
239 soluzioni per “SQL Server” · Azzera
MuMaker: "Cannot open database "MuOnline" requested by the login. The login failed" on SQL Server 2005 Express
1. Enable the sa login: Management Studio > Security > Logins > sa > Properties: untick "Enforce password policy", set a password; on the Status page tick Grant and Enabled. 2. Server Pro...
✓ Confermato dall'autore della discussioneRaGEZONE · 2012-08-18MuEditor 2.1 / MuMaker: 'SQL Connection failed' with a 97d+99i server, even when run as administrator
1. Running the editor as administrator did not help. 2. The editors connect through the ODBC data sources of the server (MuOnline, MuOnlineJoinDB and so on), so these must be registered c...
✓ Confermato dall'autore della discussioneDarksTeam · 2016-05-07MuMaker: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
1. The error means SQL Server only accepts Windows logins, so the sa login that MuMaker uses is refused. 2. Change the SQL Server authentication to SQL Server and Windows Authentication m...
✓ Confermato dall'autore della discussioneRaGEZONE · 2008-01-29CzF MU Editor 1.5: DBNETLIB error at install; it only finds the SQL Server 2019 instance, not the 2008 R2 one with the MU database
1. The editor setup only lists the database options when it reaches the newer SQL Server instance; with two instances (2008 R2 and 2019) it failed with the DBNETLIB error on the old one....
✓ Confermato dall'autore della discussioneRaGEZONE · 2020-07-10MuMaker 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...
✓ Confermato dall'autore della discussioneRaGEZONE · 2025-04-30MuEditor and MuEditorDeCuenta (account editor) cannot connect to SQL Server on the VPS, both show connection errors at start
1. Configure both editors with the IP of your VPS, the SQL user sa and its password. 2. Open the SQL Server port (1433 unless you changed it) in the Windows Firewall of the VPS. 3. In SQL...
✓ Confermato dall'autore della discussioneCreandoMU · 2023-01-01MuEditor 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.
✓ Confermato dall'autore della discussioneCreandoMU · 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.
✓ Confermato dall'autore della discussioneDarksTeam · 2010-08-08Website error "Fatal error: Call to undefined function mssql_connect()" (XAMPP 1.7.7, SQL Server 2008, DarksWeb 0.3)
New XAMPP builds no longer have the mssql_* functions these old sites use. 1. Install XAMPP 1.7.1 (said to be the last one with mssql_*), or add code that defines those functions to the s...
✓ Confermato dall'autore della discussioneDarksTeam · 2019-02-07MuEditor on the host PC cannot connect to the SQL Server that runs inside a local virtual machine
1. In SQL Server Configuration Manager inside the VM enable TCP/IP (and Named Pipes), restart the SQL service and allow port 1433 in the VM firewall. 2. In the editor config fill both blo...
✓ Confermato dall'autore della discussioneTUServerMU · 2019-11-24SQL 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...
✓ Confermato dall'autore della discussioneTUServerMU · 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...
✓ Confermato dall'autore della discussioneTUServerMU · 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...
✓ Confermato dall'autore della discussioneTUServerMU · 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...
✓ Confermato dall'autore della discussioneTUServerMU · 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...
✓ Confermato dall'autore della discussioneRaGEZONE · 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...
✓ Confermato dall'autore della discussioneTuServerMU · 2016-12-14WebEngine on shared hosting cannot reach SQL on my VPS. Port 1433 is open and MuMaker connects from home, but the web install still fails.
1. The hosting company may block outgoing traffic to port 1433. 2. In SQL Server Configuration Manager > TCP/IP > IP Addresses > IPAll set TCP Port to another free port and leave TCP Dyna...
✓ Confermato dall'autore della discussioneTuServerMU · 2020-05-23MuEmu S8 EP3: the server runs but MuEditor cannot connect to SQL, so I cannot create accounts or items. Changing the SQL password in config.ini did not help.
1. Open the editor's config.ini. 2. In the SERVER field put the name of your computer (right click This PC > Properties shows it), not an IP. 3. Fill in the SQL user (sa) and your passwor...
✓ Confermato dall'autore della discussioneTuServerMU · 2016-09-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...
✓ Confermato dall'autore della discussioneTuServerMU · 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...
✓ Confermato dall'autore della discussioneTuServerMU · 2017-11-11



