Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

MuADMINS

Lösungen

Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.

83 Lösungen für “mssql connection” · Zurücksetzen

  1. ToolsWebZen 97d / 99bS3

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2007-08-20
  2. 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2019-11-24
  3. 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...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2020-05-23
  4. ToolsMuEmu / 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...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2016-09-14
  5. Server-SetupMuEmu / LouisS6

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2020-08-08
  6. Server-SetupWebZen 97d / 99b97d

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-08-05
  7. Server-SetupMuEmu / LouisS6

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-06-06
  8. WebsiteSeason 6

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-02-07
  9. Tools

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

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2013-10-09
  10. Tools

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2013-09-25
  11. Server-Setup

    Could 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 verifiedVon MuADMINS geschrieben
  12. Server-Setup

    Players 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 verifiedVon MuADMINS geschrieben
  13. Server-SetupMuDevsS18, S20

    MuDevs: 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 verifiedVon MuADMINS geschrieben
  14. Server-SetupMSProS2, S3, S6

    What 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 verifiedVon MuADMINS geschrieben
  15. Server-Setup0.97d

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-02-21
  16. Website

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-07-28
  17. WebsiteS6

    MuCore 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";...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2018-03-23
  18. Websiteany

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2019-03-17
  19. Server-Setupany

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2020-05-23
  20. Websiteany

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-12-27

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.