MuADMINS
Solutions
Des correctifs courts pour les problèmes courants de serveur, de client et de site web MU Online, chacun avec sa source et sa date. “Confirmé” signifie que la personne qui a posé la question a indiqué que le correctif a fonctionné.
83 solutions pour “mssql connection” · Effacer
CzF MuEditor 1.05a: the editor freezes or hangs on connect (Windows Vista 64 bit, SQL Server 2005)
1. Open the ODBC Data Source Administrator. 2. Make a data source for every database the editor uses: the MU database (MuOnline) as well as Ranking and Event. The asker had only made Rank...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2007-08-20MuEditor 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...
✓ Confirmé par l'auteur du sujetTUServerMU · 2019-11-24WebEngine 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...
✓ Confirmé par l'auteur du sujetTuServerMU · 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...
✓ Confirmé par l'auteur du sujetTuServerMU · 2016-09-14MuEmu S6 (KoshGames/Louis) on SQL Server Express 2012: JoinServer says "Could not connect to database" although MuOnline is restored and the .reg files were run.
1. SQL Express installs a named instance, usually SQLEXPRESS, so (local) alone does not reach it. 2. Open the ODBC admin for your Windows bits and create the DSNs by hand. 3. In the serve...
✓ Confirmé par l'auteur du sujetTuServerMU · 2020-08-08DarksTeam 97d+99i on Windows 10 64-bit: servers say they cannot connect to SQL after installing SQL 2008. Editing the ODBC .reg did not help.
1. Uninstall the SQL Server 2008 instance that was installed with Windows authentication only. 2. Reinstall it choosing Mixed Mode and give sa a password. 3. Restore the MuOnline database...
✓ Confirmé par l'auteur du sujetTuServerMU · 2018-08-05MuEmu S6 DataServer and JoinServer show "Could not connect to database" on SQL 2008 R2 even after renaming MuOnlineS6 to MuOnline. What fixed it?
1. In the DataServer and JoinServer config files make sure the database name is the one you restored (MuOnline, not MuOnlineS6). 2. Delete the old or duplicate MuOnline DSNs and create th...
✓ Confirmé par l'auteur du sujetTuServerMU · 2018-06-06WebEngine on web hosting says "Could not connect to database (1)"
Shared web hosting often blocks outgoing connections to port 1433, the default SQL Server port, so the website cannot reach the database on your VPS even when tools on your own PC can. 1....
✓ Confirmé par l'auteur du sujetTUServerMU · 2021-02-07MuMaker: 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...
Titan Editor: cannot connect to the MU database to create accounts (single MuOnline database)
1. Open the Titan Editor config. With only one database (MuOnline) both ODBC names point to it: [Connection] ODBC=MuOnline, ODBC_Me=MuOnline, User=sa, Password=yourpass, SQLServer=(local)...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2013-09-25Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedRédigé par MuADMINSPlayers show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)
How it works in every MSSQL files family we read (IGCN, MuEmu, Louis, MSPro, X-Team, MuDevs, WebZen): at login the server runs WZ_CONNECT_MEMB, which inserts or updates MEMB_STAT with Con...
Not verifiedRédigé par MuADMINSMuDevs: WZ_CONNECT_MEMB has 4 parameters (@HarwareID) and MEMB_STAT has HWID / OnlineHours
MuDevs differs from the other MuEmu based files here: - WZ_CONNECT_MEMB @memb___id varchar(10), @ServerName varchar(50), @IP varchar(20), @HarwareID varchar(74) (4th parameter, spelled Ha...
Not verifiedRédigé par MuADMINSWhat are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?
MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...
Not verifiedRédigé par MuADMINSAminyuz 97d files: GameServer gives a conexion.ini connection error at start although all IPs are right (EventServer and Ranking open fine)
The SQL login in the Aminyuz connection file was wrong. 1. Open C:\MuServer\Aminyuz\Conexion (the connection ini of these files). 2. In the [SQL] block set Usuario = sa (your SQL user), C...
✓ Confirmé par l'auteur du sujetTUServerMU · 2020-02-21No MU website works on XAMPP (Windows 7 64-bit): SQL connection errors and php.ini extension errors although the extension is enabled
1. Turn User Account Control (UAC) back on if you had disabled it. 2. Install XAMPP again (version 1.7.1, the one these old MSSQL based sites need). 3. Put the site back and test; the SQL...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2017-07-28MuCore install on a web host: after the serial number step, step_1 of the installer shows nothing (Season 6 repack)
1. Open the MuCore configuration file that holds the database settings. 2. Find $core['connection_type'] = "MSSQL";. 3. Change the value to lower case: $core['connection_type'] = "mssql";...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2018-03-23MuCore on a web host cannot connect to the MuOnline database on a Google Cloud VPS (Connection with MuOnline Database Failed), although 1433 is open in Windows.
1. Enable TCP/IP and Named Pipes for the instance in SQL Server Configuration Manager and restart SQL. 2. Open TCP 1433 in the Windows firewall of the VPS. 3. Also open TCP 1433 in the cl...
✓ Confirmé par l'auteur du sujetTuServerMU · 2019-03-17After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?
1. In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance. 2. Open the ODBC DSNs used by the server files. 3. Change the Server field from the LAN IP to...
✓ Confirmé par l'auteur du sujetTuServerMU · 2020-05-23MuCore on XAMPP on the same VPS as SQL Server cannot connect to the database.
1. Easiest: in the MuCore config.php change the connection type from MSSQL to ODBC. 2. Or open SQL Server Configuration Manager, enable TCP/IP and Named Pipes, and restart SQL Server. 3....
✓ Confirmé par l'auteur du sujetTuServerMU · 2017-12-27