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.

128 solusyon para sa “SQL Server” para sa MuDevs at kahit anong files · 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 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Mga Toolany

    SQL Server Management Studio shows "Value cannot be null. Parameter name: viewInfo" when opening Databases on the MU server. What causes it?

    1. Check the free space on the drive where Windows, SQL Server and its temp folder live. 2. In this case the disk was full. 3. Free space: clear temp folders, old server logs and old back...

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2019-06-19
  12. Server setupany

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

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2018-11-19
  13. Websiteany

    MuCore 2.2.0 installer stops with 'SQL Failed' at the connection step.

    1. Open TCP port 1433 in the Windows firewall. 2. In SQL Server Configuration Manager enable Named Pipes and TCP/IP, set IPAll TCP Port 1433. 3. Restart SQL Server and run the installer a...

    ✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2019-07-27
  14. Server setup

    What breaks a MU server database? Safe SQL checklist before you run a query

    What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...

    Not verifiedIsinulat ng MuADMINS
  15. Server setup

    I changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)

    The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...

    Not verifiedIsinulat ng MuADMINS
  16. Server setupS2, S6, S16, S17, S18, S20

    How do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?

    Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...

    Not verifiedIsinulat ng MuADMINS
  17. Server setupS6, S16, S17, S18, S20

    How do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?

    The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...

    Not verifiedIsinulat ng MuADMINS
  18. Server setupS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedIsinulat ng MuADMINS
  19. Mga Tool

    MuMaker: cannot connect to SQL Server 2005 Express (SQLEXPRESS)

    1. Open SQL Server Configuration Manager, then Protocols for SQLEXPRESS. 2. Right click TCP/IP, Properties, set Enabled to Yes. 3. In the IP Addresses tab set Active and Enabled to Yes fo...

    Muling isinulat ng MuADMINS mula sa sourceNot verifiedRaGEZONE · 2013-10-09
  20. Mga Tool

    MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)

    1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...

    Muling isinulat ng MuADMINS mula sa sourceNot verifiedRaGEZONE · 2007-12-22

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.