MuADMINS
Soluții
Rezolvări scurte pentru probleme frecvente ale serverelor, clienților și site-urilor MU Online, fiecare cu sursa și data ei. “Confirmată” înseamnă că persoana care a întrebat a spus că rezolvarea a funcționat.
Soluții: 16 pentru “sql server instance” în Configurarea serverului · Șterge
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...
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...
✓ Confirmată de autorul topiculuiRaGEZONE · 2015-04-22MuEmu 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...
✓ Confirmată de autorul topiculuiTuServerMU · 2017-11-11MuEmu 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...
✓ Confirmată de autorul topiculuiTuServerMU · 2020-08-08DarksTeam 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...
✓ Confirmată de autorul topiculuiTuServerMU · 2018-08-05SQL 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...
✓ Confirmată de autorul topiculuiTuServerMU · 2018-11-19Why 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 verifiedScris de MuADMINSIGC 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.
✓ Confirmată de autorul topiculuiTuServerMU · 2017-04-21JoinServer 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...
✓ Confirmată de autorul topiculuiTuServerMU · 2017-07-05After 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...
✓ Confirmată de autorul topiculuiTuServerMU · 2020-05-23Aminyuz 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...
✓ Confirmată de autorul topiculuiTUServerMU · 2020-02-21IGCN 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.
✓ Confirmată de autorul topiculuiTuServerMU · 2017-06-18ODBC 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...
✓ Confirmată de autorul topiculuiTUServerMU · 2021-04-26ODBC / 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 verifiedScris de MuADMINSIGCN 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...
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...