Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

16 solutions for “sql server instance” in Server setup · Clear

  1. Server setupany

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

    MuADMINS rewrite of the sourceNot verifiedMicrosoft Learn · 2025-08-26
  2. Server setup

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

    ✓ Confirmed by the topic starterRaGEZONE · 2015-04-22
  3. Server setupMuEmu / 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...

    ✓ Confirmed by the topic starterTuServerMU · 2017-11-11
  4. Server setupMuEmu / 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...

    ✓ Confirmed by the topic starterTuServerMU · 2020-08-08
  5. Server setupWebZen 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...

    ✓ Confirmed by the topic starterTuServerMU · 2018-08-05
  6. Server setupany

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

    ✓ Confirmed by the topic starterTuServerMU · 2018-11-19
  7. Server setupIGCNS16, 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 verifiedWritten by MuADMINS
  8. Server setupIGCNS9

    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.

    ✓ Confirmed by the topic starterTuServerMU · 2017-04-21
  9. Server setupany

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

    ✓ Confirmed by the topic starterTuServerMU · 2017-07-05
  10. Server setupany

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

    ✓ Confirmed by the topic starterTuServerMU · 2020-05-23
  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...

    ✓ Confirmed by the topic starterTUServerMU · 2020-02-21
  12. Server setupIGCNS9

    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.

    ✓ Confirmed by the topic starterTuServerMU · 2017-06-18
  13. Server setupMuEmu / 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...

    ✓ Confirmed by the topic starterTUServerMU · 2021-04-26
  14. Server setup

    ODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)

    MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...

    Not verifiedWritten by MuADMINS
  15. Server setupIGCN

    IGCN License Manager: what the GameServer license errors mean (Cannot connect to Auth Server, Time Check Failed, IP Address or HWID not found, Activation Time is over)

    1. Cannot connect to Auth Server (first connect) or Failed to connect to any of auth servers (reconnect): check that the subscription is active, that the IPs in the license data on the Li...

    MuADMINS rewrite of the sourceNot verifiedIGCN · 2022-03-28
  16. Server setupOpenMUS6E3

    OpenMU in Docker: how do I update to a new version without losing accounts and characters?

    1. Back up the PostgreSQL database first. 2. In the folder with the compose file run docker-compose pull to pull all images of the stack. 3. Run docker-compose up -d. Containers that use...

    MuADMINS rewrite of the sourceNot verifiedGitHub (MUnique/OpenMU) · 2024-07-19
Still stuck? Ask the MU Assistant Search MuGPS Search MUTube

MuADMINS Community Alpha: free and community made, in active development.