Problem connecting to database

[Lazy]

hi, its about 2 months ago i came online was busy and things, but in the mean while my pc needed new windows, you know that stuff and yes now i have a problem, i want my cabal server back
so i reinstalled it. But now i got the problem it wont connect to database wich i could fix 2 months ago, that i forgot now
i also did a search for the word "database" but no resul'

so heres the log msg :

[Sat Feb 14 2015 15:53:16.360562 3075693456]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb 14 2015 15:53:16.360675 3075693456]: [##ERROR##] DB ERROR(CODE) : 20009
[Sat Feb 14 2015 15:53:16.360712 3075693456]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sat Feb 14 2015 15:53:16.360748 3075693456]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb 14 2015 15:53:16.360783 3075693456]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sat Feb 14 2015 15:53:16.360818 3075693456]: [##ERROR##] Database Connect Fail (uid=MyUser;pwd=MyPass;dsn=CabalGame24;APP=DBAgent_24)
[Sat Feb 14 2015 15:53:16.360872 3075693456]: [##ERROR##] check 'pDB' fail
[Sat Feb 14 2015 15:53:16.373389 3075693456]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sat Feb 14 2015 15:53:16.373436 3075693456]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(192.168.0.114)

all ini files contain my user and pass so wtf is wrong i never may have stopped

Mvg Lazy

[MentaL]

[tzinpo]

hi, its about 2 months ago i came online was busy and things, but in the mean while my pc needed new windows, you know that stuff and yes now i have a problem, i want my cabal server back
so i reinstalled it. But now i got the problem it wont connect to database wich i could fix 2 months ago, that i forgot now
i also did a search for the word "database" but no resul'

so heres the log msg :

[Sat Feb 14 2015 15:53:16.360562 3075693456]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb 14 2015 15:53:16.360675 3075693456]: [##ERROR##] DB ERROR(CODE) : 20009
[Sat Feb 14 2015 15:53:16.360712 3075693456]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sat Feb 14 2015 15:53:16.360748 3075693456]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb 14 2015 15:53:16.360783 3075693456]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sat Feb 14 2015 15:53:16.360818 3075693456]: [##ERROR##] Database Connect Fail (uid=MyUser;pwd=MyPass;dsn=CabalGame24;APP=DBAgent_24)
[Sat Feb 14 2015 15:53:16.360872 3075693456]: [##ERROR##] check 'pDB' fail
[Sat Feb 14 2015 15:53:16.373389 3075693456]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sat Feb 14 2015 15:53:16.373436 3075693456]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(192.168.0.114)

all ini files contain my user and pass so wtf is wrong i never may have stopped

Mvg Lazy

Hello There Here's the FAQ Section

---> FAQ SECTION <---

[chumpywumpy]

I love how so many people can't work out what "server is unavailable or does not exist." means. As with any connectivity problem you must test things to see where the problem is, either that or post a whole load of info. Posting just a log is no help whatsoever unless we all know every part of your network setup, which we don't.

This is nothing to do with user and pass or it would give an "access denied" type error. The centos machine cannot even see the sql server, it thinks it doesn't exist.

Can you ping the windows machine from centos? How about telnet to port 1433?

Is mssql server service running on windows?

Is the windows firewall enabled?

If you use sql 2005 express did you configure it properly to allow remote connections (which are off by default)?

If you use sql 2005 express did you install it properly as a default instance and not a named one (which it does by default)?

Is your /etc/odbc.ini correctly configured with the windows ip and does it have a [CabalGame24] section?

[Lazy]

@Chumpy

i forgot to enable the dam 1433 port
I'm going to install your files, u made a nice script for the channels ;o
Realy nice

@tzinpo

Thanks for the FAQ page, Many things have changed here sins i gone afk from ragezone :o

Anyway thanks you both

Closed. ;)