-
SQL Svr Prob i Guess
Code:
[Sun Dec 6 2009 23:14:39.299145 3086558912]: open log file '/var/log/cabal/DBAgent_01.log'
[Sun Dec 6 2009 23:14:39.300081 3086558912]: LOG LEVEL: 3
[Sun Dec 6 2009 23:14:39.300159 3086558912]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Dec 6 2009 23:14:39.305118 3086558912]: Start DBAgent_01 Server
[Sun Dec 6 2009 23:14:39.309096 3086558912]: UseEcryptText (Off)
[Sun Dec 6 2009 23:14:39.352004 3086556064]: CProcessLayer(0)::svc Start [3086556064]
[Sun Dec 6 2009 23:14:39.352970 3076066208]: CProcessLayer(0)::svc Start [3076066208]
[Sun Dec 6 2009 23:14:39.353141 3065576352]: CProcessLayer(0)::svc Start [3065576352]
[Sun Dec 6 2009 23:14:39.353974 3055086496]: CProcessLayer(0)::svc Start [3055086496]
[Sun Dec 6 2009 23:14:39.354215 3044596640]: CProcessLayer(0)::svc Start [3044596640]
[Sun Dec 6 2009 23:14:39.355018 3086558912]: try listening 38181 port
[Sun Dec 6 2009 23:14:40.626744 3086558912]: accept success 8(192.168.0.102:32795)
[Sun Dec 6 2009 23:14:40.632909 3086558912]: 1.open user 8 [8AC1430] (192.168.0.102)
[Sun Dec 6 2009 23:14:41.810756 3086558912]: accept success 10(192.168.0.102:32797)
[Sun Dec 6 2009 23:14:41.812626 3086558912]: 2.open user 10 [8ACFB70] (192.168.0.102)
[Sun Dec 6 2009 23:18:08.045190 3044596640]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Dec 6 2009 23:18:08.045541 3044596640]: [##ERROR##] DB ERROR(CODE) : 20009
[Sun Dec 6 2009 23:18:08.045640 3044596640]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Dec 6 2009 23:18:08.046188 3044596640]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sun Dec 6 2009 23:18:08.046224 3044596640]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Dec 6 2009 23:18:08.046494 3044596640]: [##ERROR##] Database Connect Fail (uid=sa;pwd=cabalserver;dsn=CabalGame01;APP=DBAgent_01)
[Sun Dec 6 2009 23:18:08.046612 3044596640]: [##ERROR##] check 'pDB' fail
[Sun Dec 6 2009 23:18:08.046680 3044596640]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Dec 6 2009 23:18:08.047196 3044596640]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(192.168.0.102)
I checked my usr/pass/ip ... are correct ... sql server is setted up good (i runned chumpy`s "code" in query) ... i have reinstalled windows ... no effect ... some help please ...
<walkernight88>
-
Re: SQL Svr Prob i Guess
are you sure you set in sql....to allow both ip&named pipes,and linked server and also if port 1433 is open;
you can try turn off firewall and try again