MSSQL 2008 on Server 2008

[Ron]

I finally moved to a dedicated solution for my database and am running in to an issue where no matter what I try, cabal fails to connect to the database. I've gone over the original guide I used to set it up and have done everything right, yet when I start Cabal I'm getting the following error in the DBAgent server,

[Mon Jun  4 2012 05:06:06.181854 3057015696]: [##ERROR##] Database Connect Fail (uid=sa;pwd=password;dsn=CabalGame;APP=DBAgent_01)[Mon Jun  4 2012 05:06:06.181867 3057015696]: [##ERROR##] check 'pDB' fail
[Mon Jun  4 2012 05:06:06.181878 3057015696]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Mon Jun  4 2012 05:06:06.181891 3057015696]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Mon Jun  4 2012 05:07:06.181450 3057015696]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Login failed for user 'uid=sa;pwd=password;dsn=CabalGame;APP=DBAgent_01'.
[Mon Jun  4 2012 05:07:06.181508 3057015696]: [##ERROR##] DB ERROR(CODE)     : 18456
[Mon Jun  4 2012 05:07:06.181521 3057015696]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Jun  4 2012 05:07:06.181532 3057015696]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Mon Jun  4 2012 05:07:06.181543 3057015696]: [##ERROR##] DB ERROR(STM_TEXT) :
[Mon Jun  4 2012 05:07:06.181555 3057015696]: [##ERROR##] Database Connect Fail (uid=sa;pwd=password;dsn=CabalGame;APP=DBAgent_01)

I can connect remotely via MSSQL Server Management Studio, and the custom scripts on my website are working fine as well. It seems to be directly related to MSSQL 2008 and Cabal, however I can't seem to pinpoint what the exact problem is.

Edit-
Telnet connects fine, not sure whats going on.

[root@server etc]# telnet 216.xxx.xxx.188 1433Trying 216.xxx.xxx.188...
Connected to 216.xxx.xxx.188.

tsql connects fine as well.

[MentaL]

[schneemann101]

I don't know, but all run smoofly for me, did you upgrade your database?

If not, KLICK ME HARD! THE SEARCH BUTTON IS MY BEST FRIEND ;D


Greetz

[Ron]

Compatibility didn't work, tried that way before posting this thread. lol

The only thing that fixed it was a server reimage and a reinstallation of the files. No idea why that fixed it or what was wrong in the first place but its all working now.

And just a fyi, I restored the databases with no compatibility settings and they're working fine now, so I'm guessing something was wrong with the odbc setup on centos.