Server (xpt) wont connect to SQL server

[Savrill]

Hi, i try to setup a server for play with friends but i have a problem :

i have a correct client who connect on the server (verified with few spy), the server recive the network traffic but it wont connect to the sql server.


i have tri :
- del the sql.dll file
- setup different odbc
- use sql.dll generator files
- manually patch sql.dll

but the server wont connect.

here is the log :

232825|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
232825|SiegeMoneyTax lpszTt=0

233018|Savrill's DB Error [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé. SELECT userid,passwd,gamecode,gpcode,registday,disuseday,useperiod,credit,selectchk,eventchk,blockchk,inuse,delchk,servername,editday,rno,sno,channel,bnum FROM accountdb.dbo.SGameUser WHERE userid='Savrill'
233554|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
233554|SiegeMoneyTax lpszTt=0

i use xpt 1855 client and server.

could someone help me to correct this plz?

[MentaL]

[bobsobol]

Shouldn't remove SQL.dll without removing Clan.dll. But without them you will have no such log, and no Siege Tax, Bless or Clans.

Have you checked the details in the .reg file(s) you applied to your system registry?

Explanation:-

• ODBC should be irrelevant if you are using SQL.dll and Clan.dll
• Registry should be irrelevant if you are using ODBC. (ie. no SQL.dll and Clan.dll)

[Savrill]

i checked the reg file (client), server dont use (dont have reg files, info on reg key and dont try to read/write registry), i just try delete sql & clan.dll, and it dont work. and i dont have anything in my log.
i try to trace odbc request, but the server dont do any request...

--- edit ---
dont know why, but now he connect to odbc, but i still have an error, the trace end with

XPT1855         20f0-1c78	EXIT  SQLConnectW  with return code -1 (SQL_ERROR)
		HDBC                090A2208
		WCHAR *             0x090A1938 [      -3] "c8master\ 0"
		SWORD                       -3 
		WCHAR *             0x74734EC8 [      -3] "******\ 0"
		SWORD                       -3 
		WCHAR *             0x74734EC8 [      -3] "******\ 0"
		SWORD                       -3 

		DIAG [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'c8master'. (18456)

i re-checked odbc conf, but it's correct and the odbc rly connect on the sql serv.

--- edit ---

i swiched to NT auth and it work, dunno why.

but, thank you for help me, i was totally wrong about my sql conf.

[tnrh1]

check your ports dude

[bobsobol]

Ports shouldn't have any bearing if it is localhost. Ports only matter if your SQL server is on a different machine to the game server and ODBC is configured to connect via TCP/IP rather than named pipes or $IPC.

[Savrill]

this was not the ports, server and sql server was localhost, and the comp who is serv was in dmz for tests.

[Gregoo]

[CODE]233018|Savrill's DB Error [DBNETLIB][ConnectionOpen (Connect()).]Ce serveur SQL n'existe pas ou son accès est refusé.

For that first try apparently the server's instance name was incorrect or the server didn't accept inbound connections.
Maybe the instance name you input in the .dll didn't match your server's instance name.

		DIAG [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'c8master'. (18456)

--- edit ---

i swiched to NT auth and it work, dunno why.

For the second try, the ODBC link was probably misconfigured because it didn't recognize the c8master username O: .

That's why when you switched to the integrated NT auth, it went ok because the SQL server is aware of the computer account. You probably connected via an administrator account which has full privilege over the SQL server (: .