Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSConfig ScannerCarica lo zip dei tuoi file: rates, drop, spot, limitiApriSu MuADMINSIncontraci su DiscordChiedi aiuto, condividi quello che stai creando e parla di MU con altri proprietari di server.Apri

MuADMINS

Soluzioni

Fix brevi per i problemi comuni di server, client e siti web di MU Online, ognuno con la sua fonte e la sua data. “Confermato” significa che chi ha fatto la domanda ha detto che il fix ha funzionato.

40 soluzioni per “sql login” · Azzera

  1. Strumenti

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

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2012-08-18
  2. Strumenti

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

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2008-01-29
  3. Setup del serverIGCNS9

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

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2019-07-14
  4. Setup del server

    "Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

    Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...

    Not verifiedScritto da MuADMINS
  5. Setup del server0.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...

    ✓ Confermato dall'autore della discussioneTUServerMU · 2021-02-08
  6. Setup del server

    Anyone can log in with a random account name and password, and the login creates that account in SQL

    1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2021-04-15
  7. Setup del serverany

    "Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?

    1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...

    Riscrittura della fonte da parte di MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  8. Strumenti

    MuMaker: "Login failed for user 'sa'" although the server runs and the password is right (only one MuMaker build works)

    1. Check that the sa login has rights on the MU databases and that the password in the MuMaker Config.ini is right. 2. If it still says login failed, the MuMaker build does not fit your s...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2011-06-30
  9. Setup del serverIGCNS12, S16, S17, S18

    IGCN Me_MuOnline (shared accounts): login fails or new accounts are not found after enabling it

    Me_MuOnline is a separate accounts database. It has its own MEMB_INFO, MEMB_STAT, T_VIPList, ConnectionHistory, IGC_MachineID_Banned, fn_md5, WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB. 1. IG...

    Not verifiedScritto da MuADMINS
  10. Setup del serverOpenMUSeason 6 (OpenMU 0.8.x)

    OpenMU (Docker all-in-one) after updating the server: the client stays on the login screen after entering the password.

    1. Open the admin panel and run every pending update; the maintainer notes you cannot enter the game without them. 2. In this case the database upgrade had not completed, and an old impor...

    ✓ Confermato nella issueGitHub (MUnique/OpenMU) · 2024-07-21
  11. Setup del serverS3E1

    DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed

    The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2010-03-09
  12. Setup del serverany

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

    ✓ Confermato dall'autore della discussioneTUServerMU · 2021-03-30
  13. Setup del serverMuEmu / LouisSeason 6

    MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config

    MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...

    ✓ Confermato dall'autore della discussioneTUServerMU · 2020-07-12
  14. Setup del serverMuEmu / 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...

    ✓ Confermato dall'autore della discussioneTuServerMU · 2020-08-08
  15. Setup del serverWebZen 97d / 99b97d

    SQL 2000 will not install on Windows 7, so how do I run DarksTeam 97d files on SQL Server 2008 R2 instead?

    1. Install SQL Server 2008 R2 and set a password for sa during setup (do not skip it). 2. Restore the MuOnline database from the files. 3. Open the ODBC admin (32-bit one on 64-bit Window...

    ✓ Confermato dall'autore della discussioneTuServerMU · 2018-08-06
  16. StrumentiWebZen 97d / 99b1.02n S2

    CzF Editor: after restoring the databases the editor login fails with 'ID not authenticated or banned' (1.02n + S2)

    1. The editor login you created on the first run was lost when the databases were restored. 2. Close the editor and open its folder. 3. Delete (or edit) CzFMuEditor.ini. Its [ODBCConnecti...

    ✓ Confermato dall'autore della discussioneImperyus Games Brasil · 2011-06-03
  17. Setup del serverAltri fileS2

    Season 2 Ep X (Evolution Team) files ship the database as SQL scripts, not a .bak. How do I create the database?

    1. On SQL Server 2008 or newer, restore the database backup if the files include one. 2. On SQL Server 2000 or 2005, open Query Analyzer (Start menu) and log in as sa. 3. Paste the script...

    ✓ Confermato dall'autore della discussioneTuServerMU · 2016-12-14
  18. Setup del serverS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedScritto da MuADMINS
  19. Setup del serverany (Morpheus web)

    Accounts created on the website get VIP months instead of days (Morpheus web).

    1. The SQL login used by the site had its language changed to Portuguese, which changes the date format. 2. Set the default language of that SQL login back to English (us_english). 3. Cre...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2021-04-12
  20. Setup del serverany

    During SQL Server setup the password for sa is rejected no matter what I type. Why?

    1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...

    ✓ Confermato dall'autore della discussioneTuServerMU · 2017-07-21
Non hai ancora risolto? Chiedi all'Assistente MU Cerca su MuGPS Cerca su MUTube

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.