Community AlphaAlpha MUADMINS
RORomână
Autentificare
Pe MuADMINSConfig ScannerÎncarcă zip-ul fișierelor tale: rate-uri, drop-uri, spoturi, limiteDeschidePe MuADMINSÎntâlnește-ne pe DiscordCere ajutor, arată la ce lucrezi și vorbește despre MU cu alți proprietari de servere.Deschide

MuADMINS

Soluții

Rezolvări scurte pentru probleme frecvente ale serverelor, clienților și site-urilor MU Online, fiecare cu sursa și data ei. “Confirmată” înseamnă că persoana care a întrebat a spus că rezolvarea a funcționat.

Soluții: 83 pentru “mssql connection” · Șterge

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

    ✓ Confirmată de autorul topiculuiRaGEZONE · 2007-08-20
  2. InstrumenteMuEmu / 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...

    ✓ Confirmată de autorul topiculuiTUServerMU · 2019-11-24
  3. Siteany

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

    ✓ Confirmată de autorul topiculuiTuServerMU · 2020-05-23
  4. InstrumenteMuEmu / 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...

    ✓ Confirmată de autorul topiculuiTuServerMU · 2016-09-14
  5. Configurarea serveruluiMuEmu / 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...

    ✓ Confirmată de autorul topiculuiTuServerMU · 2020-08-08
  6. Configurarea serveruluiWebZen 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...

    ✓ Confirmată de autorul topiculuiTuServerMU · 2018-08-05
  7. Configurarea serveruluiMuEmu / 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...

    ✓ Confirmată de autorul topiculuiTuServerMU · 2018-06-06
  8. SiteSeason 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....

    ✓ Confirmată de autorul topiculuiTUServerMU · 2021-02-07
  9. Instrumente

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

    Rescriere MuADMINS a surseiNot verifiedRaGEZONE · 2013-10-09
  10. Instrumente

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

    ✓ Confirmată de autorul topiculuiRaGEZONE · 2013-09-25
  11. Configurarea serverului

    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 verifiedScris de MuADMINS
  12. Configurarea serverului

    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 verifiedScris de MuADMINS
  13. Configurarea serveruluiMuDevsS18, 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 verifiedScris de MuADMINS
  14. Configurarea serveruluiMSProS2, 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 verifiedScris de MuADMINS
  15. Configurarea serverului0.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...

    ✓ Confirmată de autorul topiculuiTUServerMU · 2020-02-21
  16. Site

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

    ✓ Confirmată de autorul topiculuiRaGEZONE · 2017-07-28
  17. SiteS6

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

    ✓ Confirmată de autorul topiculuiRaGEZONE · 2018-03-23
  18. Siteany

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

    ✓ Confirmată de autorul topiculuiTuServerMU · 2019-03-17
  19. Configurarea serveruluiany

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

    ✓ Confirmată de autorul topiculuiTuServerMU · 2020-05-23
  20. Siteany

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

    ✓ Confirmată de autorul topiculuiTuServerMU · 2017-12-27

MuADMINS Community Alpha: gratuit, făcut de comunitate, în dezvoltare activă.