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.
- Open SQL Server Configuration Manager and look at the service name:
SQL Server (MSSQLSERVER)is the default instance,SQL Server (SQLEXPRESS)is a named instance. - With a named instance, reinstall SQL Server and choose "Default instance" in setup, or point the ODBC data source to
.\SQLEXPRESS. - In Security > Logins check that the login the servers use (Windows authentication for these files) is enabled.
- Restore the database, create the ODBC data source again and start JoinServer and DataServer.