Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan

MuADMINS

Mga Solusyon

Maiikling fix para sa mga karaniwang problema sa MU Online server, client at website, bawat isa ay may source at petsa. Ang ibig sabihin ng “Kinumpirma” ay sinabi ng nagtanong na gumana ang fix.

239 solusyon para sa “SQL Server” · I-clear

  1. Mga Tool

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

    ✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2012-08-18
  2. Mga ToolWebZen 97d / 99b97d

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

    ✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2016-05-07
  3. Mga Tool

    MuMaker: "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...

    ✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2008-01-29
  4. Mga ToolWebZen 97d / 99bS1

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

    ✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2020-07-10
  5. Mga Tool

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

    ✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2025-04-30
  6. Mga ToolMuEmu / Louis

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

    ✓ Kinumpirma ng nagsimula ng topicCreandoMU · 2023-01-01
  7. Server setupMuEmu / LouisSeason 6 (Louis update 15)

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

    ✓ Kinumpirma ng nagsimula ng topicCreandoMU · 2020-08-14
  8. Server setup

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

    ✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2010-08-08
  9. Website

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

    ✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2019-02-07
  10. Mga ToolMuEmu / Louisany

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

    ✓ Kinumpirma ng nagsimula ng topicTUServerMU · 2019-11-24
  11. Server setupany

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

    ✓ Kinumpirma ng nagsimula ng topicTUServerMU · 2021-03-30
  12. Server setupMuEmu / LouisSeason 6 Episode 3

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

    ✓ Kinumpirma ng nagsimula ng topicTUServerMU · 2020-05-04
  13. Server setup0.97d

    97d 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...

    ✓ Kinumpirma ng nagsimula ng topicTUServerMU · 2021-02-08
  14. Server setupMuEmu / LouisSeason 6

    MuEmu (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...

    ✓ Kinumpirma ng nagsimula ng topicTUServerMU · 2020-07-12
  15. Server setup

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

    ✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2015-04-22
  16. Server setupIbang filesS2

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

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2016-12-14
  17. Websiteany

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

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2020-05-23
  18. Mga ToolMuEmu / LouisS8

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

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2016-09-14
  19. Server setupany

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

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2017-09-17
  20. Server setupMuEmu / LouisS4

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

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2017-11-11

Mga video sa MUTube

Iba pang video para sa “SQL Server”

Naipit pa rin? Magtanong sa MU Assistant Maghanap sa MuGPS

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.