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.
12 solutions for “sqlsrv” · Clear
How do I add the SQLSRV drivers to XAMPP 8.2.12 for WebEngine?
1. Download the Microsoft Drivers for PHP for SQL Server. 2. Copy php_pdo_sqlsrv_82_ts_x64.dll and php_sqlsrv_82_ts_x64.dll into C:\xampp\php\ext. 3. In C:\xampp\php\php.ini, below extens...
Which php_pdo_sqlsrv DLL do I need for WebEngine on Windows PHP 8.x, and why does it not load?
1. The driver file must match PHP version, thread safety and bitness: e.g. php_pdo_sqlsrv_82_ts_x64 for PHP 8.2 thread safe 64 bit. 2. XAMPP Apache uses thread safe (ts) PHP; IIS FastCGI...
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-07Installing WebEngine CMS 1.2.5 with the ODBC driver fails with '[ODBC SQL Server Driver] The data types varchar(max) and text are incompatible in the equal to operator'.
1. Do not use the old ODBC SQL Server driver for the install. 2. Install the Microsoft PHP SQLSRV / PDO_SQLSRV drivers that match your PHP version and enable them in php.ini. 3. Restart A...
✓ Confirmed in the issueGitHub (lautaroangelico/WebEngine) · 2025-02-20WebEngine cannot connect to an older SQL Server (2008, 2012, 2014, 2016). What settings help?
1. Linux with pdo_dblib: install FreeTDS (apt install freetds-bin) and add a named block in /etc/freetds/freetds.conf with host, port 1433, encryption off and tds version 7.1. 2. Test it...
How do I enable the SQL Server PDO driver in php.ini and check it is really loaded?
1. Copy the matching php_sqlsrv and php_pdo_sqlsrv DLLs into the PHP ext folder (run php -i to see extension_dir). 2. Add extension= lines for both files in php.ini. 3. On Linux, load pdo...
MuCore does not load on XAMPP 7.2.1.
1. MuCore needs the old mssql PHP extension that newer XAMPP/PHP 7 no longer ships. 2. Use XAMPP 1.7.1 (old PHP with the mssql extension) for MuCore, or move to a CMS that supports PDO sq...
✓ Confirmed by the topic starterTuServerMU · 2018-02-08WebEngine 1.0.9 with a remote SQL Server IP fails with 'Could not connect to database (1)', while MuCore connects to the same server without problems.
1. In the WebEngine installer select the ODBC driver instead of dblib/sqlsrv. 2. Make sure the matching PHP ODBC extension is enabled and port 1433 is reachable. 3. Finish the install.
✓ Confirmed by the topic starterRaGEZONE · 2017-09-09After the VPS (SQL) IP changed, a WebEngine CMS 1.2.4 site hosted on a separate Linux server shows 'Connection to database failed (MuOnline)' and the installer says the install is already complete.
1. Open includes/config/webengine.json and set "webengine_cms_installed": false, then upload it. 2. In the web host cPanel open PHP Selector and (re)enable pdo_dblib and pdo_sqlsrv. 3. Ru...
✓ Confirmed by the topic starterRaGEZONE · 2024-02-16ODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)
MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...
Not verifiedWritten by MuADMINSWhat does a server need before installing WebEngine CMS 1.2.x?
1. Apache with mod_rewrite (or the Nginx or IIS rules from the wiki). 2. PHP 8.1 or newer, 8.4 suggested. 3. One SQL Server driver: PDO dblib (Linux), ODBC, or SQLSRV (Windows). 4. PHP ex...
Can WebEngine run on Windows IIS? Paths and pretty URLs break.
1. Install the IIS URL Rewrite module and non thread safe PHP (8.3 was suggested for SQLSRV driver support). 2. Install the SQLSRV drivers for that PHP. 3. Create a web.config in the site...



