Community AlphaAlpha MUADMINS
RUРусский
Войти
На MuADMINSConfig ScannerЗагрузите zip своих файлов: рейты, дропы, споты, лимитыОткрытьНа MuADMINSПрисоединяйтесь к нам в DiscordПросите помощи, показывайте свои проекты и общайтесь о MU с другими владельцами серверов.Открыть

MuADMINS

Решения

Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.

Решений: 40 по запросу “sql login” · Сбросить

  1. Инструменты

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

    ✓ Подтверждено автором темыRaGEZONE · 2012-08-18
  2. Инструменты

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

    ✓ Подтверждено автором темыRaGEZONE · 2008-01-29
  3. Настройка сервераIGCNS9

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

    ✓ Подтверждено автором темыRaGEZONE · 2019-07-14
  4. Настройка сервера

    "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 verifiedНаписано MuADMINS
  5. Настройка сервера0.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...

    ✓ Подтверждено автором темыTUServerMU · 2021-02-08
  6. Настройка сервера

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

    ✓ Подтверждено автором темыRaGEZONE · 2021-04-15
  7. Настройка сервераany

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

    Пересказ источника от MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  8. Инструменты

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

    ✓ Подтверждено автором темыRaGEZONE · 2011-06-30
  9. Настройка сервераIGCNS12, 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 verifiedНаписано MuADMINS
  10. Настройка сервераOpenMUSeason 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...

    ✓ Подтверждено в issueGitHub (MUnique/OpenMU) · 2024-07-21
  11. Настройка сервераS3E1

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

    ✓ Подтверждено автором темыDarksTeam · 2010-03-09
  12. Настройка сервераany

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

    ✓ Подтверждено автором темыTUServerMU · 2021-03-30
  13. Настройка сервераMuEmu / 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...

    ✓ Подтверждено автором темыTUServerMU · 2020-07-12
  14. Настройка сервераMuEmu / 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...

    ✓ Подтверждено автором темыTuServerMU · 2020-08-08
  15. Настройка сервераWebZen 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...

    ✓ Подтверждено автором темыTuServerMU · 2018-08-06
  16. ИнструментыWebZen 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...

    ✓ Подтверждено автором темыImperyus Games Brasil · 2011-06-03
  17. Настройка сервераДругие файлыS2

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

    ✓ Подтверждено автором темыTuServerMU · 2016-12-14
  18. Настройка сервераS2, 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 verifiedНаписано MuADMINS
  19. Настройка сервераany (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...

    ✓ Подтверждено автором темыCreandoMU · 2021-04-12
  20. Настройка сервераany

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

    ✓ Подтверждено автором темыTuServerMU · 2017-07-21
Всё ещё не получается? Спросить Помощника MU Поиск в MuGPS Искать на MUTube

MuADMINS Community Alpha: бесплатно, создаётся сообществом, в активной разработке.