DBMS Issues

[ivylawjm]

I setup the server as I was supposed to... still cant connect for some reason.....

[i] 19:26:59 - Start application without service mode
[i] 19:26:59 - application_commandline : "C:\RaiderZ Server Files\RaiderZ Server Files\MasterServer\MasterServer.exe"
[i] 19:26:59 - Server Socket Opened. (Port = 7500)
[e] 19:26:59 - Init AccountDB fail.
[i] 19:26:59 - Can't Connect To DBMS
[e] 19:26:59 - Failed InitDB
[e] 19:26:59 - Server Init Failed: 1: DB? ??? ? ??
[i] 19:26:59 - ZConsole > OnDestroy
[i] 19:26:59 - Server Closed

-----
Master Server.ini

; MasterServer server.ini

[SERVER_INFO]
// dont touch any of this.
NAME = "MasterServer"
SERVER_ID = 100
WORLD_ID = 1
ODBC = "SQL Native Client"
SOCKET_POOL_SIZE = 100
SERVER_MODE = 0

[CONFIG]
// can change but no point to
PORT = 7500


[ACCOUNTDB]
SERVER = "UEBARI-PC\SQLEXPRESS" // update for your MSSQL server info (can use remote connections if you want to use multi boxes)
DATABASE = "RZ_ACCOUNTDB" // Accounts database name
USERNAME = "ragezone"
PASSWORD = "rageonze"

[DB]
SERVER = "UEBARI-PC\SQLEXPRESS" // update for your MSSQL server info (can use remote connections if you want to use multi boxes)
DATABASE = "RZ_GAMEDB" // Games database name
USERNAME = "ragezone"
PASSWORD = "rageonze"

[LOGDB]
SERVER = "UEBARI-PC\SQLEXPRESS" // update for your MSSQL server info (can use remote connections if you want to use multi boxes)
DATABASE = "RZ_LOGDB" // Logs database name
USERNAME = "ragezone"
PASSWORD = "rageonze"

// dont touch below this.

[PATH]
SYSTEM = "system"
FIELD = "field"

[LOG]
LOG_PATH = "log"
LOG_LEVEL = 1

I'm using MSSQL Server 2008 R2

[MentaL]

[Dawson]

Please make sure you have set up the user "ragezone" as a proper user in your SQL server, it doesn't come by default.

In addition it could just be a problem with your ODBC I will screenshot the proper setup of ODBC





And don't touch the final page, main thing is making sure it's a SYSTEM DSN and that it's SQL Native Client 10.0

Otherwise all I can say is make sure the user ragezone exists in your SQL server, if not add it via the management studio (google how to do that)

[WireShark]

I setup the server as I was supposed to... still cant connect for some reason.....

[i] 19:26:59 - Start application without service mode
[i] 19:26:59 - application_commandline : "C:\RaiderZ Server Files\RaiderZ Server Files\MasterServer\MasterServer.exe"
[i] 19:26:59 - Server Socket Opened. (Port = 7500)
[e] 19:26:59 - Init AccountDB fail.
[i] 19:26:59 - Can't Connect To DBMS
[e] 19:26:59 - Failed InitDB
[e] 19:26:59 - Server Init Failed: 1: DB? ??? ? ??
[i] 19:26:59 - ZConsole > OnDestroy
[i] 19:26:59 - Server Closed

-----
Master Server.ini

; MasterServer server.ini

[SERVER_INFO]
// dont touch any of this.
NAME = "MasterServer"
SERVER_ID = 100
WORLD_ID = 1
ODBC = "SQL Native Client"
SOCKET_POOL_SIZE = 100
SERVER_MODE = 0

[CONFIG]
// can change but no point to
PORT = 7500


[ACCOUNTDB]
SERVER = "UEBARI-PC\SQLEXPRESS" // update for your MSSQL server info (can use remote connections if you want to use multi boxes)
DATABASE = "RZ_ACCOUNTDB" // Accounts database name
USERNAME = "ragezone"
PASSWORD = "rageonze"

[DB]
SERVER = "UEBARI-PC\SQLEXPRESS" // update for your MSSQL server info (can use remote connections if you want to use multi boxes)
DATABASE = "RZ_GAMEDB" // Games database name
USERNAME = "ragezone"
PASSWORD = "rageonze"

[LOGDB]
SERVER = "UEBARI-PC\SQLEXPRESS" // update for your MSSQL server info (can use remote connections if you want to use multi boxes)
DATABASE = "RZ_LOGDB" // Logs database name
USERNAME = "ragezone"
PASSWORD = "rageonze"

// dont touch below this.

[PATH]
SYSTEM = "system"
FIELD = "field"

[LOG]
LOG_PATH = "log"
LOG_LEVEL = 1

I'm using MSSQL Server 2008 R2

[SERVER_INFO]
// dont touch any of this.
NAME = "MasterServer"
SERVER_ID = 100
WORLD_ID = 1
ODBC = "SQL Native Client" Change this <-- into "SQL Server"
SOCKET_POOL_SIZE = 100
SERVER_MODE = 0

[jM2.me]

[SERVER_INFO]
// dont touch any of this.
NAME = "MasterServer"
SERVER_ID = 100
WORLD_ID = 1
ODBC = "SQL Native Client" Change this <-- into "SQL Server"
SOCKET_POOL_SIZE = 100
SERVER_MODE = 0

Do this and don't create any ODBC configuration. Just put in server ip, user and pass in server.ini files.

[JaKKing_]

Do this and don't create any ODBC configuration. Just put in server ip, user and pass in server.ini files.

You need to make a new ODBC configuration with SQL Server, then in the server.ini, you have to replace the "SQL Native Client" with "SQL Server". This worked for me.