MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN:
- JoinServer.ini
JoinServerODBC = MuOnline, DataServer.iniDataServerODBC = MuOnline(MSPro:ODBC = MuOnline). - The packs ship the DSN as registry files:
MuOnline.regwrites HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline,MuOnline64.regwrites HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MuOnline: Driver SQLSRV32.dll ("SQL Server"), Server (local), Database MuOnline.
Checks:
- On 64 bit Windows a 32 bit server program sees only the 32 bit DSNs: use MuOnline64.reg or create the DSN in C:\Windows\SysWOW64\odbcad32.exe.
- The DSN must point at the right SQL instance: (local) is the default instance; a named instance needs PCNAME\SQLEXPRESS.
- The DSN default database must be MuOnline (not master), or the server looks for the tables in the wrong database.
- MSPro logs in with an SQL user (JoinServerUSER / SQLUser = sa): SQL Server must allow mixed mode authentication.
IGCN is different: IGCDS.ini [SQL] connects with SQLServerName, User and Pass, no DSN name; the IGCN documentation asks for an English language SQL user and a case insensitive collation.
Source: JoinServer.ini / DataServer.ini and DB/MuOnline.reg / MuOnline64.reg of Louis S6E3 V13, Louis S6 Update 27, X-Team S17, MSPro V14; IGCN S16 IGCDS.ini; IGCN doc notes in the MuADMINS SQL guide research.