[Guide] How To Solve "System Error Cause Login Failed"

[Jejemon]

First Go To "Start -> Control Panel -> Administrative Tools -> Data Source (ODBC)"

Then Go To "User DSN" Tab And Follow This SS :

1.


2.


3.


4.


5.


6.


7.


8.


Note : Do The Same Procedure In "RanLog , RanShop , And RanUser".


Then Go To Your Server's CFG Folder And Open The "Session , Field And Agent CFG's"

Then Change The RED Part And Type Your SQL Password Then SAVE

In Session :

// ////////////////////////////////////////////////////////////////////////////
// Session server cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1
patch_version 1
server_name session.ran.cn
server_max_client 2000

// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 2
max_thread 4
// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
service_provider 2

server_ip 127.0.0.1
server_service_port 5003
server_control_port 6003
heartbeat 1

// ////////////////////////////////////////////////////////////////////////////
// RanAlphaDB
// ////////////////////////////////////////////////////////////////////////////

// ////////////////////////////////////////////////////////////////////////////
// Terra user database setting value
//terra_odbc_name RanUser
//terra_odbc_user sa
//terra_odbc_pass 123456789
//terra_odbc_database RanUser
//terra_odbc_pool_size 5
//terra_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456789
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456789
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456789
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456789
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10

In Field :

// ////////////////////////////////////////////////////////////////////////////
// Field server cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1 // ¼­¹ö ¹öÀü, Ŭ¶óÀ̾ðÆ® ¹öÀü°ú µ¿ÀÏ
patch_version 1 // ÆÐÄ¡ ÇÁ·Î±×·¥ ¹öÀü
server_name field1.ran.cn // ¼­¹ö¸í
server_max_client 2000 // ÃÖ´ë Á¢¼Ó °¡´É Ŭ¶óÀ̾ðÆ® ¼ö
// server_max_client 2000 // ÃÖ´ë Á¢¼Ó °¡´É Ŭ¶óÀ̾ðÆ® ¼ö
server_ip 127.0.0.1 // ¼­¹ö IP, ÇÁ·Î±×·¥¿¡¼­ ÀÚµ¿À¸·Î °áÁ¤µÉ¼ö ÀÖ´Ù
server_service_port 5502 // ¼­ºñ½º¿ë Æ÷Æ®
server_control_port 6004 // ÄÁÆ®·Ñ¿ë Æ÷Æ®
heartbeat 1

gameguard 0
pk 1

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
// 6 Thailand (XinXere)
service_provider 2

// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 3 // server type
server_group 1 // game server group
server_number 0 // game server number
server_channel 0 // Field server channel
server_field 0 // Field server number

// ////////////////////////////////////////////////////////////////////////////
// RanAlphaDB
// ////////////////////////////////////////////////////////////////////////////

// ////////////////////////////////////////////////////////////////////////////
// Terra user database setting value
//terra_odbc_name RanUser
//terra_odbc_user sa
//terra_odbc_pass 123456789
//terra_odbc_database RanUser
//terra_odbc_pool_size 5
//terra_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456789
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456789
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456789
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456789
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server session.ran 127.0.0.1 5003 ran ran
// session_server session.ran-online.co.kr 192.168.1.43 5003 ran ran

// ////////////////////////////////////////////////////////////////////////////
// Agent server
// agent_server [server_name] [ip]
agent_server agent1.ran 127.0.0.1

In Agent :

// ////////////////////////////////////////////////////////////////////////////
// Field server cfg file

// ////////////////////////////////////////////////////////////////////////////
// server setting value
server_version 1 // ¼­¹ö ¹öÀü, Ŭ¶óÀ̾ðÆ® ¹öÀü°ú µ¿ÀÏ
patch_version 1 // ÆÐÄ¡ ÇÁ·Î±×·¥ ¹öÀü
server_name agent1.ran.cn // ¼­¹ö¸í
server_max_client 2000 // ÃÖ´ë Á¢¼Ó °¡´É Ŭ¶óÀ̾ðÆ® ¼ö
server_max_channel_client 2000 // ä³Î´ç ÃÖ´ë Á¢¼Ó °¡´É Ŭ¶óÀ̾ðÆ® ¼ö
server_channel_number 1 // ¼­¹öÀÇ Ã¤³Î °¹¼ö
// server_max_client 1000 // ÃÖ´ë Á¢¼Ó °¡´É Ŭ¶óÀ̾ðÆ® ¼ö
// server_max_channel_client 1000 // ä³Î´ç ÃÖ´ë Á¢¼Ó °¡´É Ŭ¶óÀ̾ðÆ® ¼ö
// server_channel_number 1 // ¼­¹öÀÇ Ã¤³Î °¹¼ö

// server type [type]
// [type]
// 1 : login server
// 2 : session server
// 3 : field server
// 4 : agent server
server_type 4
server_group 1 // game server group
server_number 1 // game server number

gameguard 0

pk 1

channel 0 1
channel 1 1
channel 2 1
channel 3 1

// /////////////////////////////////////////////////////////////////////////////
// 0 Korea (Mincoms) (default)
// 1 Korea (Daum game)
// 2 Taiwan / Hong Kong (Feya)
// 3 China
// 4 Japan (Excite)
// 5 Malaysia (Terra)
// 6 Thailand (XinXere)
service_provider 2

server_ip 127.0.0.1 // ¼­¹ö IP, ÇÁ·Î±×·¥¿¡¼­ ÀÚµ¿À¸·Î °áÁ¤µÉ¼ö ÀÖ´Ù
server_service_port 5103 // ¼­ºñ½º¿ë Æ÷Æ®
server_control_port 6088 // ÄÁÆ®·Ñ¿ë Æ÷Æ®
heartbeat 1

// ////////////////////////////////////////////////////////////////////////////
// RanAlphaDB
// ////////////////////////////////////////////////////////////////////////////

// ////////////////////////////////////////////////////////////////////////////
// Terra user database setting value
//terra_odbc_name RanUser
//terra_odbc_user sa
//terra_odbc_pass 123456789
//terra_odbc_database RanUser
//terra_odbc_pool_size 5
//terra_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// user database setting value
user_odbc_name RanUser
user_odbc_user sa
user_odbc_pass 123456789
user_odbc_database RanUser
user_odbc_pool_size 5
user_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// game database setting value
game_odbc_name RanGame1
game_odbc_user sa
game_odbc_pass 123456789
game_odbc_database RanGame1
game_odbc_pool_size 5
game_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// log database setting value
log_odbc_name RanLog
log_odbc_user sa
log_odbc_pass 123456789
log_odbc_database RanLog
log_odbc_pool_size 5
log_odbc_response_time 10

// ////////////////////////////////////////////////////////////////////////////
// shop database setting value
shop_odbc_name RanShop
shop_odbc_user sa
shop_odbc_pass 123456789
shop_odbc_database RanShop
shop_odbc_pool_size 5
shop_odbc_response_time 10


// ////////////////////////////////////////////////////////////////////////////
// Session server
// session_server [server_name] [ip] [port] [userid] [userpass]
session_server Session.ran.cn 127.0.0.1 5003 ran ran

// ////////////////////////////////////////////////////////////////////////////
// Field server list
// field_server [Channel] [serverID] [server_name] [ip] [port]
field_server 0 0 field1.ran.cn 127.0.0.1 5502

And Try To Run You Server .....

[MentaL]

[jeiemXbytes08]

Thanks For The Guide , It's Working !!!

[laklakbangi]

Nice Guide!:)

in All cfg files or ini files in cfg folder!

take a look!

//terra_odbc_pass 123456789

you can change that in to your Database Password
example:
1234

//terra_odbc_pass 1234

[I'm Not MentaL]

i know this since 2008, thanks again

[xuling]

thank,can open ran.......

[laklakbangi]

just tick the thanks button if help:)

[[GM]:Glenox]

(Client ID:100) (127.0.0.1:1147)
DB:{call user_verify('admin','62A90CCFF3FD73694BF','127.0.0.1',0,1,'','12',?)}
DB:42000, NativeError:8144, [Microsoft][SQL Native Client][SQL Server]Procedure or function user_verify has too many arguments specified.
DB:{call user_verify('admin','81DC9BDB52D04DC2003','127.0.0.1',0,1,'','12',?)}
DB:42000, NativeError:8144, [Microsoft][SQL Native Client][SQL Server]Procedure or function user_verify has too many arguments specified.


this error is not familiar....

[I'm Not MentaL]

(Client ID:100) (127.0.0.1:1147)
DB:{call user_verify('admin','62A90CCFF3FD73694BF','127.0.0.1',0,1,'','12',?)}
DB:42000, NativeError:8144, [Microsoft][SQL Native Client][SQL Server]Procedure or function user_verify has too many arguments specified.
DB:{call user_verify('admin','81DC9BDB52D04DC2003','127.0.0.1',0,1,'','12',?)}
DB:42000, NativeError:8144, [Microsoft][SQL Native Client][SQL Server]Procedure or function user_verify has too many arguments specified.


this error is not familiar....

i got this problem before, i recovery the backup database then no more problem

[Jake Talay]

Please Help me! :( i need your help sir
why is it too long to log in the game? i followed all the instructions and fix the problem all by my self by reading all the threads here on rage zone but this one is too hard for me. :( HELP PLEASE

Please Help me! :( i need your help sir
why is it too long to log in the game? i followed all the instructions and fix the problem all by my self by reading all the threads here on rage zone but this one is too hard for me. :( HELP PLEASE

[bleach1109]

i cant log in sir too long to login in my game

[Cm Marquez]

~i followed every step on this guide, but still doesn't work :( help

[gazerock1991]

ME TOO

version: EP8 http://forum.ragezone.com/f444/ran-s...eo-2pc-959772/