The database and the SQL settings were fine; the IP passed to GameServer.exe in its shortcut was the problem.
- Right-click the GameServer.exe shortcut you start the server with and open Properties.
- Read the Target line: the IP written after the exe must be the same IP you use in the rest of the server configuration (in the thread one place had the local IP and the other the public IP).
- Put the same IP in both places (local IP for a local test, the public IP of the VPS for an online server), save and start GameServer again.
Tip from the thread: in the files config (EMU config.xml, SPD_Config\SPD.ini) the database host should be (local), localhost or the PC name, not the public IP.