Como arrumar erro de Conexão com a db Win 7/Vista.
~MSSQL 2005 Windows 7/Vista~
Citação:
[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
O problema é o Protocolo de 127.0.0.1 ou 192.168.1.xx que seu IP não permiti a conexão
Siga este guia para o Microsoft SQL Server 2005 no Windows 7 ou Vista
Em primeiro lugar você precisa seguir o tutorial do chumpywumpy de como instalar o MSSQL 2005 corretamente em seu computador.
Em seguida, siga a imagem abaixo se você terminar:
[img width=411 height=494]http://i662.photobucket.com/albums/uu344/jericogarcia16/mamoru/Opensqlconfig.jpg[/img]
[img width=800 height=563]http://i662.photobucket.com/albums/uu344/jericogarcia16/mamoru/SQLmanagermenu.jpg[/img]
[img width=800 height=563]http://i662.photobucket.com/albums/uu344/jericogarcia16/mamoru/sqltciprightclick.jpg[/img]
[img width=550 height=582]http://i662.photobucket.com/albums/uu344/jericogarcia16/mamoru/enablenow.jpg[/img]
Reinicie o serviço do MSSQL e feito!
~MSSQL 2000 Windows 7/Vista~
Vá em Painel de Controle > Contas de Usuário e Segurança Familiar > Contas de Usuário > Alterar configurações de Controle de Conta de Usuario.
[Only registered and activated users can see links. Click Here To Register...]
Necessário Reiniciar o Computador.
Gostou ? Te Ajudei ? Agradeça :P
O Tópico foi Util ? Fixa ele ^^
Comente!