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

MuADMINS

Решения

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

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

  1. ИнструментыWebZen 97d / 99bS1

    CzF MU Editor 1.5: DBNETLIB error at install; it only finds the SQL Server 2019 instance, not the 2008 R2 one with the MU database

    1. The editor setup only lists the database options when it reaches the newer SQL Server instance; with two instances (2008 R2 and 2019) it failed with the DBNETLIB error on the old one....

    ✓ Подтверждено автором темыRaGEZONE · 2020-07-10
  2. Настройка сервераany

    Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?

    1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...

    Пересказ источника от MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  3. Настройка сервера

    Creating the MuOnline ODBC data source fails with 'SQL Server Error: 2' (EX700 server, SQL Express)

    1. Error 2 means the ODBC wizard cannot find the SQL Server you typed. 2. Make sure the SQL Server service is running. 3. With SQL Server Express the server name must include the instance...

    ✓ Подтверждено автором темыRaGEZONE · 2015-04-22
  4. Настройка сервераMuEmu / LouisS4

    MuEmu S4: the server and MuMaker do not see the databases on SQL Server 2008 R2 even with remote connections and TCP/IP enabled.

    1. Check how SQL Server was installed: it had been set up as a named instance. 2. The files and MuMaker expect the default instance, reached as (local) or the PC name. 3. Reinstall SQL Se...

    ✓ Подтверждено автором темыTuServerMU · 2017-11-11
  5. Настройка сервера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
  6. ИнструментыMuEmu / Louis

    MuEditor and MuEditorDeCuenta (account editor) cannot connect to SQL Server on the VPS, both show connection errors at start

    1. Configure both editors with the IP of your VPS, the SQL user sa and its password. 2. Open the SQL Server port (1433 unless you changed it) in the Windows Firewall of the VPS. 3. In SQL...

    ✓ Подтверждено автором темыCreandoMU · 2023-01-01
  7. Сайт

    Website error "Fatal error: Call to undefined function mssql_connect()" (XAMPP 1.7.7, SQL Server 2008, DarksWeb 0.3)

    New XAMPP builds no longer have the mssql_* functions these old sites use. 1. Install XAMPP 1.7.1 (said to be the last one with mssql_*), or add code that defines those functions to the s...

    ✓ Подтверждено автором темыDarksTeam · 2019-02-07
  8. Настройка сервераWebZen 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...

    ✓ Подтверждено автором темыTuServerMU · 2018-08-05
  9. Настройка сервераany

    SQL Server 2012 installed without errors but SQL Server Agent will not start (Browser starts fine) when preparing MU files. What fixed it?

    1. In services.msc set SQL Server Agent to Automatic and try to start it. 2. If it still fails, the instance was installed with the wrong authentication choice. 3. Reinstall SQL Server an...

    ✓ Подтверждено автором темыTuServerMU · 2018-11-19
  10. Сайтany

    MVCore 1.17.1 and MuCore 1.8 on XAMPP 1.7.1 both fail to connect to SQL Server 2008 R2, even with Named Pipes enabled.

    1. SQL Server was installed as the named instance SQLEXPRESS, so there was no MSSQLSERVER default instance. 2. Reinstall SQL Server with the default instance (MSSQLSERVER) and keep the sa...

    ✓ Подтверждено автором темыTuServerMU · 2018-07-30
  11. ИнструментыIGCNS9, S12

    IGC.EssentialTools opens and closes by itself after about 3 seconds, even with the SQL user, password and server filled in.

    1. In the EssentialTools config set IP = (local) when SQL Server is on the same PC (it does not accept DNS names). 2. Port = 1433. 3. SQLInstance empty when there is a single SQL instance...

    ✓ Подтверждено автором темыRaGEZONE · 2020-05-17
  12. Настройка сервераIGCNS16, S17, S18

    Why did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?

    Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...

    Not verifiedНаписано MuADMINS
  13. ИнструментыДругие файлыS6

    BeastMaker admin tool: how to set up the SQL connection and the allowed user (and SQL 2000 without "Edit Top 200 Rows")

    1. Run the table script from the release post to create the BeastMaker table (columns BeastMaker_Allowed, BeastMaker_Logs) in the MuOnline database. 2. Add your allowed entry {"YOURNAME":...

    Пересказ источника от MuADMINSNot verifiedRaGEZONE · 2015-07-14
  14. Настройка сервераIGCNS9

    IGC DataServer stays on its loading window and never finishes starting.

    1. Check the ODBC/SQL settings of the DataServer. 2. The SQL instance name was wrong. When SQL Server is on the same PC use (local) as the instance/host. 3. Start the DataServer again.

    ✓ Подтверждено автором темыTuServerMU · 2017-04-21
  15. Настройка сервераany

    JoinServer and DataServer show Could not connect to database on start.

    1. Restore the MuOnline database correctly in SQL Server (from the backup shipped with your files). 2. Create the ODBC data source the servers expect, pointing to that database. 3. Make s...

    ✓ Подтверждено автором темыTuServerMU · 2017-07-05
  16. Настройка сервераany

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

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

    ✓ Подтверждено автором темыTUServerMU · 2020-02-21
  18. Сайтany

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

    ✓ Подтверждено автором темыTuServerMU · 2019-03-17
  19. Настройка сервераIGCNS9

    IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.

    1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.

    ✓ Подтверждено автором темыTuServerMU · 2017-06-18
  20. Настройка сервераMuEmu / LouisSeason 6 (Louis update 24)

    ODBC test works but JoinServer and DataServer still do not connect (Louis files on a VPS)

    The topic starter fixed it by reinstalling SQL Server: it was installed wrong. The helper's diagnosis was a named instance (SQLEXPRESS) while the files expect the default instance. 1. Ope...

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

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