Server wont connect to SQL SERVER

ellemen · Sep 2, 2008

Hello this is big problem and i dont have idea how to slove it...

so Dedicted Server dont want to connect to my Desktop PC

My router is D-LINK : DSL-2740B

i unblocked 1433 port but still saying in Db Agent log cant connect..

Anyone can help?

Code:

[Tue Sep  2 2008 17:35:37.531407 3086087888]: open log file  '/var/log/cabal/DBAgent_24.log'
[Tue Sep  2 2008 17:35:37.531484 3086087888]: LOG LEVEL: 3
[Tue Sep  2 2008 17:35:37.531507 3086087888]: MemPoolUnitSizeClass(2): 24576Bytes
[Tue Sep  2 2008 17:35:37.531995 3086087888]: Start DBAgent_24 Server
[Tue Sep  2 2008 17:35:37.532369 3086087888]: UseEcryptText (Off)
[Tue Sep  2 2008 17:35:37.532590 3086085008]: CProcessLayer(0)::svc Start [3086085008]
[Tue Sep  2 2008 17:35:37.532658 3075595152]: CProcessLayer(0)::svc Start [3075595152]
[Tue Sep  2 2008 17:35:37.532768 3086087888]: try listening 38181 port
[Tue Sep  2 2008 17:35:37.532827 3086087888]: [##ERROR##] listen 38181 port fail (Address already in use)
[Tue Sep  2 2008 17:35:37.532912 3086087888]: [##ERROR##] active fail
[Tue Sep  2 2008 17:35:37.532954 3065105296]: CProcessLayer(0)::svc Start [3065105296]
[Tue Sep  2 2008 17:35:37.532991 3065105296]: CProcessLayer(0)::svc Terminated [3065105296]
[Tue Sep  2 2008 17:35:37.533066 3054615440]: CProcessLayer(0)::svc Start [3054615440]
[Tue Sep  2 2008 17:35:37.533096 3054615440]: CProcessLayer(0)::svc Terminated [3054615440]
[Tue Sep  2 2008 17:35:37.533131 3044125584]: CProcessLayer(0)::svc Start [3044125584]
[Tue Sep  2 2008 17:35:37.533165 3044125584]: CProcessLayer(0)::svc Terminated [3044125584]
[Tue Sep  2 2008 17:35:37.533193 3086085008]: [##ERROR##] getq fail (108)
[Tue Sep  2 2008 17:35:37.533210 3086085008]: CProcessLayer(0)::svc Terminated [3086085008]
[Tue Sep  2 2008 17:35:37.533232 3075595152]: [##ERROR##] getq fail (108)
[Tue Sep  2 2008 17:35:37.533248 3075595152]: CProcessLayer(0)::svc Terminated [3075595152]
[Tue Sep  2 2008 17:35:37.595697 3086927568]: accept success 8(91.204.162.165:58560)
[Tue Sep  2 2008 17:35:37.595812 3086927568]: 1.open user 8 [9E67E50] (91.204.162.165)
[Tue Sep  2 2008 17:35:37.694211 3086927568]: accept success 10(91.204.162.165:58565)
[Tue Sep  2 2008 17:35:37.694301 3086927568]: 2.open user 10 [9E70568] (91.204.162.165)
[Tue Sep  2 2008 17:37:14.732342 3086924688]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Tue Sep  2 2008 17:37:14.732396 3086924688]: [##ERROR##] DB ERROR(CODE)     : 20009
[Tue Sep  2 2008 17:37:14.732414 3086924688]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Tue Sep  2 2008 17:37:14.732431 3086924688]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Tue Sep  2 2008 17:37:14.732447 3086924688]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Tue Sep  2 2008 17:37:14.732465 3086924688]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Tue Sep  2 2008 17:37:14.732512 3086924688]: [##ERROR##] check 'pDB' fail
[Tue Sep  2 2008 17:37:14.732529 3086924688]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Tue Sep  2 2008 17:37:14.732547 3086924688]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(91.204.162.165)

[hidden] · Sep 2, 2008

from centos try this : telnet (your windows ip) 1433

then from windows, repeat the same at the command line.

observe differences.

ellemen · Sep 2, 2008

Code:

telnet 78.146.242.32 1433
Trying 78.146.242.32...
telnet: connect to address 78.146.242.32: Connection timed out

I think the port is blocked but i got choice how i want to unblock it no one has told us how to unblock them TCP/UDP and things like that anyone can help?

External Port

Internal Port

Protocol TCP/UDP

chumpywumpy · Sep 2, 2008

Nobody can tell you "click this, change that" as every router is slightly different and were i to tell you how i forward ports it won't work for you.

You really should be checking your router manual or googling for guides om how to port forward on d-link routers as it isn't exactly a rare question. I have done it for you in this case, study some of these as it explains how to do it for other games and you just need to use ort 1533.

To view the content, you need to sign in or register

Be warned that connecting to an SQL server over a WAN link is a very dangerous thing from a security point of view. MSSQL servers are easy to hack and and leaving port 1433 open is going to leave you vunerable.