How to solve DB connection Error in your Server writh Windows 7, Vista

[nitro+]

Some people encounter this error in their Centos, the thing is they successfully setup the server and they can connect it with Winscp but can't connect to database as you can see in the log if you go to:
var/log/cabal/DBAgent_01.log

[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=test123;dsn=CabalGame01;APP=DBAgent_01)
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] check 'pDB' fail
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=test123;dsn=CabalGame01;APP=DBAgent_01)
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] check 'pDB' fail
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=test123;dsn=CabalGame01;APP=DBAgent_01)
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] check 'pDB' fail
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Sep 2 2010 19:21:07.095189 3086362304]: SIGTERM

The problem is the Protocol 127.0.0.1 or your ip 192.168.1.xx is not enable

Follow this guide for Microsoft SQL server 2005 in Windows 7 or Vista

First off you need to follow chumpywumpy guides of how to install MSSQL 2005 properly in your computer.

Then follow the picture below if you finish:

Restart your MSSQL service if Done!!!

Tadah!!!!! Check to see the log if the database connection is successfull

[MentaL]

[darkknight]

Thank for guide
My Client can't open in Windows7

[xrevoltado]

and with mssql 2000 ??? how resolve ? pls help-me

[S37uP!Update]

and with mssql 2000 ??? how resolve ? pls help-me

Control Panel>User Accounts And Family Safety>User Accounts>Change User Account Control Settings.



Then Restart Your Computer.

[xrevoltado]

N o t!
W o r k ;(