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.

14 Lösungen für “login failed for user 'sa'” · Zurücksetzen

  1. Tools

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2011-06-30
  2. Tools

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2008-01-29
  3. Server-SetupIGCNS9

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2019-07-14
  4. Server-Setupany

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

    Neufassung der Quelle durch MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  5. Tools

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2012-08-18
  6. Game-ClientS2

    Login fails with "error-L1 : serial error [account] WSARecv() failed with error 10038" (Season 2 server)

    1. The serial of the main does not match the server: the GameServer window shows its serial (here muservicesinfoss) and the main has another one (here k5lEopalwaudns8h). 2. On the server...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-08-12
  7. Server-Setup

    How to change the ConnectServer port 44405, and login fails after changing it

    1. Use the BoR Team ConnectServer, which has ini files with a port option, and set the new port there. 2. Put the same port in the launcher. 3. If login still fails, open MuServer\Connect...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2010-12-21
  8. Game-Client

    Login fails with 'error-L1 : serial error [account] WSARecv() failed with error 10038' for every client

    1. The error means the client serial and the GameServer serial do not match: compare the serial the GameServer window shows (here muservicesinfoss) with the one in main.exe (here k5lEopal...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-08-11
  9. Server-SetupMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2018-10-06
  10. Server-SetupIGCNS12

    IGCN Season 12: DataServer is not responding although TCP/IP is enabled in SQL Server

    1. Open DataServer.ini and check SQLServerName. 2. When SQL Server runs on the same machine use SQLServerName = (local) or the exact PC name as shown in SQL Server Management Studio (for...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2020-01-08
  11. 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
  12. Website

    What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?

    The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...

    Not verifiedVon MuADMINS geschrieben
  13. 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
  14. ToolsWebZen 97d / 99b97d-99

    MuEditor 2.1 (SkyTeam): how to set it up on another PC to edit the server database remotely (ODBC and DNS.ini)

    1. On the PC where you run MuEditor open Control Panel, Administrative Tools, Data Sources (ODBC). 2. In System DSN click Add, choose SQL Server: Name MuOnline, Description MuEditor, Serv...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2005-07-17

Videos auf MUTube

Mehr Videos zu „login failed for user 'sa'“

Kommst du immer noch nicht weiter? Frag den MU-Assistenten MuGPS durchsuchen

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