I can't connect at the login screen
Please kindly check this log for me and help me to solve this please :|
DBAgent_02
Code:
[Sun Apr 26 2009 00:31:26.743238 3086690000]: open log file '/var/log/cabal/DBAgent_02.log'
[Sun Apr 26 2009 00:31:26.743544 3086690000]: LOG LEVEL: 3
[Sun Apr 26 2009 00:31:26.743585 3086690000]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Apr 26 2009 00:31:26.746371 3086690000]: Start DBAgent_02 Server
[Sun Apr 26 2009 00:31:26.747835 3086690000]: UseEcryptText (Off)
[Sun Apr 26 2009 00:31:26.749234 3086690000]: try listening 38181 port
[Sun Apr 26 2009 00:31:26.750553 3086687120]: CProcessLayer(0)::svc Start [3086687120]
[Sun Apr 26 2009 00:31:26.751060 3076197264]: CProcessLayer(0)::svc Start [3076197264]
[Sun Apr 26 2009 00:31:26.751612 3065707408]: CProcessLayer(0)::svc Start [3065707408]
[Sun Apr 26 2009 00:31:26.751838 3055217552]: CProcessLayer(0)::svc Start [3055217552]
[Sun Apr 26 2009 00:31:26.752170 3044727696]: CProcessLayer(0)::svc Start [3044727696]
[Sun Apr 26 2009 00:31:27.238502 3086690000]: accept success 8(127.0.0.1:43821)
[Sun Apr 26 2009 00:31:27.240491 3086690000]: 1.open user 8 [8B8FFA0] (127.0.0.1)
[Sun Apr 26 2009 00:31:33.614153 3086690000]: accept success 10(127.0.0.1:43825)
[Sun Apr 26 2009 00:31:33.614951 3086690000]: 2.open user 10 [8B9E6C0] (127.0.0.1)
[Sun Apr 26 2009 00:31:33.717733 3065707408]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:31:33.718194 3065707408]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:31:33.718216 3065707408]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:31:33.718237 3065707408]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:31:33.718257 3065707408]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:31:33.718277 3065707408]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:31:33.718335 3065707408]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:31:33.718356 3065707408]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Sun Apr 26 2009 00:31:33.718379 3065707408]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Sun Apr 26 2009 00:31:33.749415 3055217552]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:31:33.749469 3055217552]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:31:33.749490 3055217552]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:31:33.749510 3055217552]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:31:33.749531 3055217552]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:31:33.749552 3055217552]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:31:33.749574 3055217552]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:31:33.749594 3055217552]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Sun Apr 26 2009 00:31:33.749617 3055217552]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Sun Apr 26 2009 00:31:44.861166 3044727696]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:31:44.861589 3044727696]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:31:44.861615 3044727696]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:31:44.861635 3044727696]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:31:44.861655 3044727696]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:31:44.861675 3044727696]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:31:44.861712 3044727696]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:31:44.861733 3044727696]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 26 2009 00:31:44.861912 3044727696]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 26 2009 00:32:33.637622 3044727696]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:32:33.637905 3044727696]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:32:33.638103 3044727696]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:32:33.638126 3044727696]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:32:33.638147 3044727696]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:32:33.638168 3044727696]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:32:33.638190 3044727696]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:32:33.638211 3044727696]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 26 2009 00:32:33.638234 3044727696]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 26 2009 00:33:12.793720 3086690000]: SIGTERM
3086690000: work_pending_i: Interrupted system call
[Sun Apr 26 2009 00:33:12.847890 3086687120]: CProcessLayer(0)::svc Terminated [3086687120]
[Sun Apr 26 2009 00:33:12.848364 3076197264]: [##ERROR##] getq fail (108)
[Sun Apr 26 2009 00:33:12.848412 3076197264]: CProcessLayer(0)::svc Terminated [3076197264]
[Sun Apr 26 2009 00:33:12.848871 3065707408]: [##ERROR##] getq fail (108)
[Sun Apr 26 2009 00:33:12.848907 3065707408]: CProcessLayer(0)::svc Terminated [3065707408]
[Sun Apr 26 2009 00:33:12.850469 3055217552]: [##ERROR##] getq fail (108)
[Sun Apr 26 2009 00:33:12.850520 3055217552]: CProcessLayer(0)::svc Terminated [3055217552]
[Sun Apr 26 2009 00:33:12.851124 3044727696]: [##ERROR##] getq fail (108)
[Sun Apr 26 2009 00:33:12.851174 3044727696]: CProcessLayer(0)::svc Terminated [3044727696]
[Sun Apr 26 2009 00:34:04.572321 3086272208]: open log file '/var/log/cabal/DBAgent_02.log'
[Sun Apr 26 2009 00:34:04.573304 3086272208]: LOG LEVEL: 3
[Sun Apr 26 2009 00:34:04.573369 3086272208]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Apr 26 2009 00:34:04.577139 3086272208]: Start DBAgent_02 Server
[Sun Apr 26 2009 00:34:04.578789 3086272208]: UseEcryptText (Off)
[Sun Apr 26 2009 00:34:04.580202 3086272208]: try listening 38181 port
[Sun Apr 26 2009 00:34:04.586211 3086269328]: CProcessLayer(0)::svc Start [3086269328]
[Sun Apr 26 2009 00:34:04.587375 3075779472]: CProcessLayer(0)::svc Start [3075779472]
[Sun Apr 26 2009 00:34:04.587596 3065289616]: CProcessLayer(0)::svc Start [3065289616]
[Sun Apr 26 2009 00:34:04.587864 3054799760]: CProcessLayer(0)::svc Start [3054799760]
[Sun Apr 26 2009 00:34:04.588135 3044309904]: CProcessLayer(0)::svc Start [3044309904]
[Sun Apr 26 2009 00:34:05.446889 3086272208]: accept success 8(127.0.0.1:60431)
[Sun Apr 26 2009 00:34:05.449798 3086272208]: 1.open user 8 [8E48FA0] (127.0.0.1)
[Sun Apr 26 2009 00:34:50.472325 3086268112]: open log file '/var/log/cabal/DBAgent_02.log'
[Sun Apr 26 2009 00:34:50.472438 3086268112]: LOG LEVEL: 3
[Sun Apr 26 2009 00:34:50.472474 3086268112]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Apr 26 2009 00:34:50.475408 3086268112]: Start DBAgent_02 Server
[Sun Apr 26 2009 00:34:50.476522 3086268112]: UseEcryptText (Off)
[Sun Apr 26 2009 00:34:50.477618 3086268112]: try listening 38181 port
[Sun Apr 26 2009 00:34:50.478102 3086268112]: [##ERROR##] listen 38181 port fail (Address already in use)
[Sun Apr 26 2009 00:34:50.478277 3086268112]: [##ERROR##] active fail
[Sun Apr 26 2009 00:34:50.478620 3086265232]: CProcessLayer(0)::svc Start [3086265232]
[Sun Apr 26 2009 00:34:50.478681 3086265232]: CProcessLayer(0)::svc Terminated [3086265232]
[Sun Apr 26 2009 00:34:50.479126 3075775376]: CProcessLayer(0)::svc Start [3075775376]
[Sun Apr 26 2009 00:34:50.479191 3075775376]: CProcessLayer(0)::svc Terminated [3075775376]
[Sun Apr 26 2009 00:34:50.479274 3065285520]: CProcessLayer(0)::svc Start [3065285520]
[Sun Apr 26 2009 00:34:50.479306 3065285520]: CProcessLayer(0)::svc Terminated [3065285520]
[Sun Apr 26 2009 00:34:50.479776 3054795664]: CProcessLayer(0)::svc Start [3054795664]
[Sun Apr 26 2009 00:34:50.479819 3054795664]: CProcessLayer(0)::svc Terminated [3054795664]
[Sun Apr 26 2009 00:34:50.480217 3044305808]: CProcessLayer(0)::svc Start [3044305808]
[Sun Apr 26 2009 00:34:50.480337 3044305808]: CProcessLayer(0)::svc Terminated [3044305808]
[Sun Apr 26 2009 00:34:50.920506 3086272208]: accept success 10(127.0.0.1:60436)
[Sun Apr 26 2009 00:34:50.921152 3086272208]: 2.open user 10 [8E576B8] (127.0.0.1)
[Sun Apr 26 2009 00:34:50.937320 3086272208]: 2.close user 10 [8E576B8] (127.0.0.1)
[Sun Apr 26 2009 00:34:57.815700 3086272208]: accept success 10(127.0.0.1:60440)
[Sun Apr 26 2009 00:34:57.815922 3086272208]: 2.open user 10 [8E576B8] (127.0.0.1)
[Sun Apr 26 2009 00:34:57.917665 3065289616]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:34:57.928308 3065289616]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:34:57.928346 3065289616]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:34:57.928367 3065289616]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:34:57.928503 3065289616]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:34:57.928525 3065289616]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:34:57.928886 3065289616]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:34:57.928972 3065289616]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Sun Apr 26 2009 00:34:57.928995 3065289616]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Sun Apr 26 2009 00:34:57.945402 3054799760]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:34:57.945456 3054799760]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:34:57.945477 3054799760]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:34:57.945815 3054799760]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:34:57.945856 3054799760]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:34:57.945876 3054799760]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:34:57.946323 3054799760]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:34:57.946361 3054799760]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Sun Apr 26 2009 00:34:57.946384 3054799760]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Sun Apr 26 2009 00:35:10.148179 3044309904]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:35:10.148515 3044309904]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:35:10.148537 3044309904]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:35:10.148557 3044309904]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:35:10.148667 3044309904]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:35:10.148688 3044309904]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:35:10.148723 3044309904]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:35:10.148745 3044309904]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 26 2009 00:35:10.148770 3044309904]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 26 2009 00:35:57.840179 3044309904]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Sun Apr 26 2009 00:35:57.840628 3044309904]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Apr 26 2009 00:35:57.840653 3044309904]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 26 2009 00:35:57.840673 3044309904]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Sun Apr 26 2009 00:35:57.840694 3044309904]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 26 2009 00:35:57.840715 3044309904]: [##ERROR##] Database Connect Fail (uid=sa;pwd=5897351;dsn=CabalGame02;APP=DBAgent_02)
[Sun Apr 26 2009 00:35:57.840737 3044309904]: [##ERROR##] check 'pDB' fail
[Sun Apr 26 2009 00:35:57.840757 3044309904]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 26 2009 00:35:57.840781 3044309904]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
Re: I can't connect at the login screen
It's a connection problem witht he database, though the error is a bit different to the usual "server not found" so the db is at least responding. Are you able to log in using query manager/management studio using the sa login and that password?
Also, run the following query in the db and tell me what it says:
SELECT @@ServerName
1 Attachment(s)
Re: I can't connect at the login screen
Yeah, I could login using system admin or sa.
Here's what it says (on the pic).
off-topic @sir chumpywumpy - I recently add you on MSN :D
Re: I can't connect at the login screen
look at my post he gave ascript that you have to run
Re: I can't connect at the login screen
Quote:
Originally Posted by
GunKill
Yeah, I could login using system admin or sa.
Here's what it says (on the pic).
off-topic @sir chumpywumpy - I recently add you on MSN :D
Your MSSQL is installed as a named instance and ths is wrong. That command should only return "JAZ", the other bit is the instance name. You re going to need to reinstall MSSQL to fix it. Check my guide on how to install correctly.
http://forum.ragezone.com/f460/dead-...ack-v2-444970/