Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

184 solutions for “mssql” · Clear

  1. ToolsS6

    WebEngine CMS installer: "Could not connect to database (1)" at the database step with MSSQL Server 2008 (PDO ODBC, XAMPP)

    1. In this case the game files connected fine but the WebEngine installer kept failing on the database step, with no error in the SQL logs or the Windows event log. 2. The cause was a con...

    ✓ Confirmed by the topic starterRaGEZONE · 2023-10-06
  2. Tools

    MuCore install: "Connection with MuOnline Database Failed" and "Extension php_mssql.dll must be enabled"

    1. MuCore needs a PHP that still has the old php_mssql.dll extension: in php.ini find extension=php_mssql.dll and remove the ; in front of it. 2. If your web server package has no php_mss...

    ✓ Confirmed by the topic starterRaGEZONE · 2011-03-05
  3. Tools

    MuCore 1.08 installer: with the MSSQL connection it cannot get past step 3 (MSSQL 2008 R2, XAMPP 1.7.1)

    1. Use XAMPP 1.7.7 for MuCore 1.08 (XAMPP 1.7.1 with MSSQL 2008 works badly). 2. Install the client DLL that supports your MSSQL version (linked in the reply). 3. Open C:/xampp/php/php.in...

    ✓ Confirmed by the topic starterRaGEZONE · 2016-05-26
  4. Website

    MuWeb 0.9 installer check shows Mssql: NO even after editing php.ini

    1. Install XAMPP 1.7.0 (it includes the mssql extension the site needs). 2. Put MuWeb 0.9 in its htdocs and open the installer again; Mssql now shows YES.

    ✓ Confirmed by the topic starterDarksTeam · 2009-02-12
  5. Website

    Error #123 Loading php_mssql.dll Failed when installing DarksWeb, although the dll is in the ext folder

    1. Install AppServ 2.5.9 instead of the XAMPP / VertrigoServ builds that failed. 2. Edit C:\Windows\php.ini (the php.ini AppServ really uses) and enable extension=php_mssql.dll there. 3....

    ✓ Confirmed by the topic starterDarksTeam · 2009-10-28
  6. 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...

    ✓ Confirmed by the topic starterDarksTeam · 2019-02-07
  7. Website

    How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?

    1. G_Mark in the Guild table is binary: turn it into text with bin2hex(). You get 64 hex digits, one per cell of an 8x8 grid. 2. Map each digit to a color: 0 transparent, 1 #000000, 2 #8c...

    ✓ Confirmed by the topic starterRaGEZONE · 2020-07-01
  8. Server setupIGCNS9

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

    ✓ Confirmed by the topic starterRaGEZONE · 2019-07-14
  9. Tools

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

    ✓ Confirmed by the topic starterRaGEZONE · 2012-08-18
  10. ToolsWebZen 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...

    ✓ Confirmed by the topic starterDarksTeam · 2016-05-07
  11. Tools

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

    ✓ Confirmed by the topic starterRaGEZONE · 2008-01-29
  12. ToolsWebZen 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....

    ✓ Confirmed by the topic starterRaGEZONE · 2020-07-10
  13. Tools

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

    ✓ Confirmed by the topic starterRaGEZONE · 2025-04-30
  14. ToolsMuEmu / 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...

    ✓ Confirmed by the topic starterCreandoMU · 2023-01-01
  15. 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.

    ✓ Confirmed by the topic starterCreandoMU · 2020-08-14
  16. 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.

    ✓ Confirmed by the topic starterDarksTeam · 2010-08-08
  17. ToolsMuEmu / 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...

    ✓ Confirmed by the topic starterTUServerMU · 2019-11-24
  18. 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...

    ✓ Confirmed by the topic starterTUServerMU · 2021-03-30
  19. 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...

    ✓ Confirmed by the topic starterTUServerMU · 2020-05-04
  20. 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...

    ✓ Confirmed by the topic starterTUServerMU · 2021-02-08

Videos on MUTube

More videos for “mssql”

Still stuck? Ask the MU Assistant Search MuGPS

MuADMINS Community Alpha: free and community made, in active development.