[Help] "update server state query failed." problem

[lizardo]

I follow the tutorial in a few threads and stuck on Gameserver.

It's always show "update server state query failed" and "update sever auth state query failed"

***I can login , Named my character but can't see any Server on Server List.

here's from Gameserver log.

[E_ODBC] ErrCode(IM006) ErrMsg([Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed)
[E_ODBC] ErrCode(08001) ErrMsg([Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: No credentials are available in the security package
[E_ODBC] ErrCode(08001) ErrMsg([Microsoft][SQL Server Native Client 10.0]Client unable to establish connection)
[E_ODBC] ErrCode(08001) ErrMsg([Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.)
[F_ODBC] CONNECT 2 : Query({ call dbo.ProcUpdateServerState (20201,0,0,100,'2010022400','',0,0,100,1,1,0,4,10,1,0,55, 0, 0) }), IP(Pangya_S4_TH), Account(sa), PW(123456)

I try to change ODBC config in few ways but it's not work.
Help me please, Thank You.

***I'm not good in English, Sorry.

[MentaL]

[Tsukasa]

Sounds like either a misconfigured system-DSN connection or an SQL server problem.

Please check whether each system-DSN connection contains a username and a password (check in the ODBC control panel) and these credentials match the ones from your INIs.

If you're using SQL server on a remote machine, make sure remote connections are allowed.

Should the error persist despite the pointers above, make sure the connection language for each system-DSN connection is set to English - otherwise you'll run into trouble with numbering in dates and some procedures will fail.

[lizardo]

After Check system-DSN I try to check something in Server.ini and I found something useful.

If you use too much letter in log dir(in *.inis) it may occurs error like me.(I only change "C:\PANGYA_PS\PANGYA_GS_LOG" to "C:\PANGYA_GS_LOG" and it's work)


***Thank you very much for your help. I can go next step right now ^^